NON STOP SQL   

What is the equivalent of Date()-1 using PASS THROUGH queries and NON STOP 
SQL for TANDEM?

Any link to a website that would provide "ODBC/JDBC escape 
sequences and/or functions to support the equivalent of CURRENT_DATE, 
INTERVAL and date arithmetic"?

Thanks

date: Tue, 28 Mar 2006 08:03:01 -0800   author:   TARAJI

RE: NON STOP SQL   

Here is one way to make it work:
Where
a1.TRXN_DATE = {fn convert({fn timestampadd (SQL_TSI_DAY, -1, { fn curdate() 
} )} ,date)}

"TARAJI" wrote:

> What is the equivalent of Date()-1 using PASS THROUGH queries and NON STOP 
> SQL for TANDEM?
> 
> Any link to a website that would provide "ODBC/JDBC escape 
> sequences and/or functions to support the equivalent of CURRENT_DATE, 
> INTERVAL and date arithmetic"?
> 
> Thanks

date: Tue, 28 Mar 2006 12:42:02 -0800   author:   TARAJI