SQLRPGLE program to execute SQL statement on remote DB

[dhanuxp]

Hello All,

I want to connect to another ISeries DB2 database using SQLRPGLE program to do some calculation on it. What I did shows bellow, but I can?t compile this code & thoughts something very wrong in my code.
Is it possible? Any idea please..

/free                                                           
   *Inlr = *On;                                                 
   Exec SQL SET OPTION                                          
               Naming    = *Sys,                                
               Commit    = *None,                               
               UsrPrf    = *User,                               
               DynUsrPrf = *User,                               
               Datfmt    = *iso,                                
               CloSqlCsr = *EndMod;                             
                                                                
   Exec SQL  CONNECT TO LIVEDB USER myname USING 'mypass';  
                                                                
   Exec SQL DECLARE CSR1 CURSOR FOR                             
            SELECT * FROM myLib/myFILE1;                       
                                                                
   Exec SQL OPEN CSR1;        
?..
??
?? 
   Exec SQL CLOSE CSR1;      
                          
   Exec DISCONNECT LIVEDB;

SQL0084  30      17  Position 36 SQL statement not allowed.

Thanks
dhanuxp

[tomholden]

Re: SQLRPGLE program to execute SQL statement on remote DB

nice...now which line of code is line 17? i'm guessing it's the CONNECT statement. IIRC the user and password must be host variables, not strings...

[dhanuxp]

Re: SQLRPGLE program to execute SQL statement on remote DB

nice...now which line of code is line 17? i'm guessing it's the CONNECT statement. IIRC the user and password must be host variables, not strings...

Thanks Tom gr8!!!

Yes, it was a problem of CONNECT statement & i change it to;

Exec SQL CONNECT TO :RDBAX USER :USERX USING :PASSX;

Thanks again tom !!

dhanuxp