Re: SQL file not hardcoded

[rob@xxxxxxxxx]

Jeff,

It can be done, although I wish your solution was supported.

I don't think you use EXECUTE IMMEDIATE when using a PREPARE.  EXECUTE 
IMMEDIATE is a combination of PREPARE and EXECUTE.  You should be able to 
do an EXECUTE Stmt1 USING ...  But it still won't let you use the file 
name.

One way is to issue an OVRDBF prior to the sql statement.

Another way is to concatenate the file name.  I think it would be 
something like
ActSQL = 'Select Coalesce(Min(INVDT),' + @Q + '0001-01-01' + @Q + ')' +
              ', Coalesce(Max(INVDT),' + @Q + '0001-01-01' + @@ + ')' +
              ', Coalesce(Count(*),0) ' +
              'Into ?, ? , ? From ' + Filename;

Exec SQL Prepare Stmt1 from :ActSQL;
Exec SQL Execute Stmt1 using :MinDate, :MaxDate, :Count;


Rob Berendt