Re: MIDRANGE-L Digest, Vol 9, Issue 456

No Luis - and don't know what does it mean "post FETCH"

Pozdrawiam

---------------------------------------------------------
Tomasz SkorÅa
IT Manager
mobile: +48 606 815 067
deskphone: +48 61 665 79 67

Agri Plus Sp. z o.o.
ul. MarceliÅska 92/94
60-324 PoznaÅ
phone: +48 61 665 79 60
fax: +48 61 665 79 61
Numer KRS 0000113478
SÄd Rejonowy w Poznaniu, XXI WydziaÅ Gospodarczy Krajowego Rejestru SÄdowego

KapitaÅ zakÅadowy 235 900 000,00 zÅ

---------------------
Please consider the environment before printing this email.


W dniu 2010-03-12 15:19, midrange-l-request@xxxxxxxxxxxx pisze:

message: 8 date: Fri, 12 Mar 2010 09:49:18 -0430 from: Luis Rodriguez <luisro58@xxxxxxxxx> subject: Re: Why I get diffrent result for SQL Tomek, Could you post your FETCH sentence? Regards, Luis Rodriguez IBM Certified Systems Expert ? eServer i5 iSeries 2010/3/12 Tomasz Skor?a <t.skorza@xxxxxxxxxxx>

> Hi
>
> I have following query:
>
> SELECT ILITM, ILLITM, ILMCU,
> ILLOTN, ILLOCN, ILDOC, ILDCT, ILDGL,
> D4DATE, D4DAY, D4WEK, D4MTH, D4YER, ILGLPT, ILDOCO,
> ILDCTO, ILTRDJ, D5DATE, D5WEK, D5DAY, D5MTH, D5YER,
> ILTRUM, ILAN8,
> ILTRQT/getumconv(ILITM, ILTRUM, IMUOM1),
> ILPAID/100, IS$FM#
> FROM F4111 LEFT JOIN F57217C
> ON ILDOCO = ISBCT and ILDCTO = 'II'
> LEFT JOIN F55008 on ILDGL=D4DGJ
> LEFT JOIN F55009 on ILTRDJ=D5DGJ
> LEFT JOIN F4101 on ILITM=IMITM
> WHERE
> ILTRQT<>0 AND ILITM<>0 AND ILTRDJ<>0
>
> When I call this statements in interactive SQL session I get correct
> results - means all records which suite me.
>
> But when I try call the same statement in SQLRPG program
>
> DECLARE C1 CURSOR FOR SELECT ILITM, ILLITM, ILMCU,
> ILLOTN, ILLOCN, ILDOC, ILDCT, ILDGL,
> D4DATE, D4DAY, D4WEK, D4MTH, D4YER, ILGLPT, ILDOCO,
> ILDCTO, ILTRDJ, D5DATE, D5WEK, D5DAY, D5MTH, D5YER,
> ILTRUM, ILAN8,
> ILTRQT/getumconv(ILITM, ILTRUM, IMUOM1),
> ILPAID/100, IS$FM#
> FROM F4111 LEFT JOIN F57217C
> ON ILDOCO = ISBCT and ILDCTO = 'II'
> LEFT JOIN F55008 on ILDGL=D4DGJ
> LEFT JOIN F55009 on ILTRDJ=D5DGJ
> LEFT JOIN F4101 on ILITM=IMITM
> WHERE
> ILTRQT<>0 AND ILITM<>0 AND ILTRDJ<>0
>
> I get only this rows where ILDCTO is equal "II"?
>
> WHY? What is wrong? Hwo to get all rows in second issue?
>
> Regards
>
> Tomek
> --
> 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
> athttp://archive.midrange.com/midrange-l.
>
>