Re: Filername ?

Stark wrote:
In the statement: Select * from "MyDatase.dbf" "MyDataset.dbf" needs to be the actual filename on disk.
Since I need to apply the same Select statement to different datasets (on disk I name them with a suffix like MyDataset_1, .._2, etc.), how can I do it ?

A normal Table, would allow me to set programmatically a different Tablename .. But with a TQuery, while I can set Databasename, there is no property correspondig to Tablename.

What property do you normally set the query text? Construct the query using the name of the file you want to use that time (using normal string-concatenation statements).

--
Rob
.

Relevant Pages

  • RE: Has any Informix DBA had to do the following?
    ... I've never had that problem myself using IDS, granted then I was using c and esql/c for the connections so I knew every piece of code and had no thread issues. ... Disk access - busy disks but no predominant ... duration of the query. ... Has any Informix DBA had to do the following? ...
    (comp.databases.informix)
  • Re: Single-Threading / Performance issues
    ... Apparently not since at least 3 physical disks are required for RAID-5. ... This is normal but the percent disk utilization metric isn't much use ... might want to set SQL Server 'max server memory' if you have other apps ... > From Query Analyser, I run my import proc - which first copies data ...
    (microsoft.public.sqlserver.server)
  • Re: Whats the deal with PAGEIOLATCH_SH?
    ... In addition to what Greg suggests are you monitoring the Checkpoint Pages ... Checkpoints can really hose a disk with low ... About 20 minutes into the query everything goes bad. ... > I'll work on getting the real execution plan, ...
    (microsoft.public.sqlserver.programming)
  • Re: Whats the deal with PAGEIOLATCH_SH?
    ... About 20 minutes into the query everything goes bad. ... > That sounds like a disk I/O problem to me, ... > I'll work on getting the real execution plan, ... >>scans or inefficient joins such as hash joins. ...
    (microsoft.public.sqlserver.programming)
  • Re: Whats the deal with PAGEIOLATCH_SH?
    ... but more than that on average represents the disk subsystem lagging. ... SQL Server performs much of it's work in cache, so the absence of disk i/o ... is the actual execution plans for those queries. ... Query / Show Execution Plan in Query Analyser if you're submitting the ...
    (microsoft.public.sqlserver.programming)