Not able to resolve the error -104 in Eazytrieve



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

Not able to resolve the error -104 in Eazytrieve

Postby chavinash2004 » Wed Apr 12, 2023 7:46 pm

Hi Team,

I have written below code in parm card and when we execute the job i'm getting below error. I checked all the syntax but no luck. Can someone please help me on this.


90 SQL SELECT  EMP_ID                          +
              ,ABA_NO                                   +
              ,ACCT_NO                               +
              ,ACCT_TYP_CODE                              +
              ,BK_ACCT_NM1                         +
              ,BK_ACCT_NM2                          +
 INTO :WS-EMP-ID                       +
    ,:WS-ABA-NO                                +
    ,:WS-ACCT-NO                            +
    ,:WS-ACCT-TYP-CODE                           +
    ,:WS-BK-ACCT-NM1                       +
    ,:WS-BK-ACCT-NM2
FROM TABLE_A                  
  WHERE EMP_ID = :DI-EMP-ID
WITH UR;                                                            +
*******B204 SQL - SQL ERROR, SQLCODE IS -104                            
*******B204 SQL - DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL "?". SOME SYMBOLS THAT MIGHT BE LEGAL
*******B204 SQL -          ARE: <IDENTIFIER> :                          
*******B204 SQL - DSNT418I SQLSTATE   = 42601 SQLSTATE RETURN CODE      
*******B204 SQL - "SELECT INTO" IS VALID ONLY FOR SQLSYNTAX OF NONE AND SQLSYNTAX OF NONE AND STATIC-ONLY BIND

CASE SQLCODE
     WHEN 0
        CONTINUE
 
chavinash2004
 
Posts: 4
Joined: Tue Apr 26, 2011 1:46 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Not able to resolve the error -104 in Eazytrieve

Postby chavinash2004 » Wed Apr 12, 2023 9:33 pm

I’m able to resolve it by changing simple select with cursor. I’m not sure if there is any better way.

Thanks a lot in advance.
chavinash2004
 
Posts: 4
Joined: Tue Apr 26, 2011 1:46 pm
Has thanked: 0 time
Been thanked: 0 time


Return to CA-Easytrieve

 


  • Related topics
    Replies
    Views
    Last post