Implementing SQL Query in Easytrieve



Unicenter CA-Easytrieve Plus Report Generator: CA's information retrieval and data management tool

Implementing SQL Query in Easytrieve

Postby sricsc » Fri Aug 14, 2009 9:13 pm

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.
Thanks,
Sri
sricsc
 
Posts: 13
Joined: Sat Aug 08, 2009 7:07 am
Has thanked: 0 time
Been thanked: 0 time

Return to CA-Easytrieve

 


  • Related topics
    Replies
    Views
    Last post