I have two embedded sql in my rpgle program. The first one is a DECLARE/CURSOR/OPEN/FETCH/CLOSE METHOD. The second on is the Select into method.
Would my second select turn on end of file in my first sql?
For some reason SQLCOD = 100 when I go back to my loop to read the next record after I perform my second SQL.
I ran on the sql command line my first sql to see how many record it should read before it give me end of file and it should be two records but it is only reading one.
Thank you in advance.
Would my second select turn on end of file in my first sql?
For some reason SQLCOD = 100 when I go back to my loop to read the next record after I perform my second SQL.
I ran on the sql command line my first sql to see how many record it should read before it give me end of file and it should be two records but it is only reading one.
Thank you in advance.
Comment