RE: No records in SQLRPG

Hi Johan,

I may have missed some posts but the first thing that comes to mind to me
is if the table in question is in your library list.

Also, are there any previous messages in the joblog?

Glenn Gundermann
ggundermann@xxxxxx
(647) 272-3295

P.S. I assume you are not on V5R4 yet, based on all the /EXEC SQL and
/END-EXEC statements.

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Johan Vangilbergen
Sent: Tuesday, October 23, 2007 6:02 AM
To: RPG programming on the AS400 / iSeries
Subject: No records in SQLRPG

Dear list,

I'm having a SQLRPG program with the following structure :

/EXEC SQL
Declare A Cursor For Select ......
/END-EXEC

/EXEC SQL
Open A
/END-EXEC

/EXEC SQL
Fetch next from A into .....
/END-EXEC

Dow Sqlstt = '00000'
Do some stuff ...
/EXEC SQL
Fetch next from A into ....
/END-EXEC

Enddo

When I debug this program, I always get Sqlstt = '02000' and SQLCOD =
100, which means no records. However, if I run my select statement in
interactive SQL (via STRSQL) I do get some records.

Can anyone tell me what I'm doing wrong in my SQLRPG ?

Johan Vangilbergen

YUSE
Phone : +32 16 74 50 80
Fax : +32 16 74 50 89
Email : jvg@xxxxxxx <mailto:jvg@xxxxxxx>
Web : WWW.Yuse.be <http://www.Yuse.be>
Address : Bondgenotenlaan 138, B-3000 Leuven, Belgium