RE: Empty row from fetch in SQLRPGLE

Sure,  you're doing something wrong.

Are you checking SQLSTT and/or SQLCOD after each statement?  What errors
are you seeing?  If you're not checking SQLSTT you should be.

To move beyond that answer, you'd need to post your code.

You may want to post in the RPG-L list as it would seem you basic SQL
syntax is right and the problem relates to having the statement embedded
in RPG.  Thus, RPG-L would be a more appropriate place for this question
than MIDRANGE-L.


HTH,

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx 
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Tomasz Skorza
Sent: Wednesday, August 30, 2006 3:08 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Empty row from fetch in SQLRPGLE

Hi

Do you any idea why during processing select and fetch in 
SQLRPGRPG i get as
a results empty rows? (maaaany empty rows).

When I use the same structure (from cursor definition) in SQL 
session I get
correct results - not empty rows.

Why during program RPG job retrived rows are empty? Do you 
have any idea?

Regards

Tomasz Skorza


-- 
This is the Midrange Systems Technical Discussion 
(MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.