pointer or parameter error

[Alligator]

this is part of the code. I get "pointer or parameter error" message when the program reaches the second C/EXEC SQL (the one above C+ OPEN SQLECSR). What is the problem, have I missed something?

  *                                                            
C/EXEC SQL                                                    
C+ DECLARE SQLECSR CURSOR FOR                                 
C+ SELECT dcat,idsco,dtopn,dtcls,dsrv,dordq,dshpq,dord,dline  
C+ FROM   cd LEFT JOIN iil04 ON dcat = icat                   
C+ WHERE  (iapp = : p_iapp) and (ifrq = : p_ifrq) and           
C+     (dtopn >= :strdate) and (dtopn < :enddate) and         
C+     (dsrv = 'G' or dsrv = 'B')                             
C+ ORDER BY dtopn                                             
C+ OPTIMIZE FOR 100 ROWS                                      
C+ FOR FETCH ONLY                                             
C/END-EXEC                                                   
  *  
C/EXEC SQL 
C+ OPEN SQLECSR 
C/END-EXEC 

[Mercury]

Re: pointer or parameter error

Hmm... The ' * ' on the program excerpt is not in column 7. The colon ( : ) should be "stuck" to the variable name (not sure of this one).

[Alligator]

Re: pointer or parameter error

the * is just a note line in RPG and the space after the : it's just because it kept turning into a smile because of the p after it.

[jtemple]

Re: pointer or parameter error

Could you post a complete example of the program? I suspect you have an error with a parameter that is passed to the program but I would need to see the entire program to know.