Page 1 of 1

Implementing SQL Query in Easytrieve

PostPosted: Fri Aug 14, 2009 9:13 pm
by sricsc
Hi,

My easytrieve have singleton " select into "query. so I used the STATIC-ONLY parameter. But i'm getting the following issue...

My Easytrieve Job...
PARM SSID(DB2P) SQLSYNTAX NONE BIND STATIC-ONLY
....
SQL +
SELECT CURRENT_TIMESTAMP FROM SYSIBM.SYSDUMMY1 +
INTO :TO-DAY +
WITH UR
*******B204 SQL - INVALID OR MISSING STATIC COMMAND PROGRAM NAME
.....

Pls tell me how to resolve this.. I need to use static-only parameter. And if i use DYNAMIC parameter, Job is working fine by using CURSOR for query.