RE: Shifting Data in Return SQL Statement

Then forgive me...it's Monday. LOL 


Thanks,
Tommy Holden


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Tyler, Matt
Sent: Monday, January 30, 2006 2:57 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Shifting Data in Return SQL Statement

Sorry, Tommy but I have to protest.  I created a test RPG and DSPF with
output only and one with input only and the programs compiles and runs.

Thank you,
Matt Tyler
WinCo Foods, LLC


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Holden Tommy
Sent: Monday, January 30, 2006 1:54 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Shifting Data in Return SQL Statement

Just for the sake of checking...

Create work fields to use as host variables & see if you get the correct
results.  If so then most likely it's a buffering issue.  As I stated
earlier the precompiler *normally* will fail to compile when using
output only variables as host variables & *could* potentially be your
problem. 


Thanks,
Tommy Holden


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Brian Piotrowski
Sent: Monday, January 30, 2006 2:38 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Shifting Data in Return SQL Statement

Thanks, Tommy.

Most of these variables you see here are not redefined in any way - the
value is passed from the SQL Interpreter to the field name.  The only
fields that are refined are PQDATEIN and PQDATEOUT and PQSTATUSD (none
of these fields are experiencing the data shift).

To be sure, I went back and had a look at all of my code, and this is
indeed the case.

Thanks, 

Brian.

-----Original Message-----
From: Holden Tommy [mailto:Tommy.Holden@xxxxxxxxxxxxxxxxx] 
Sent: Monday, January 30, 2006 3:09 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Shifting Data in Return SQL Statement

Ok first off...SQL normally doesn't like output only variables for host
variables.

     A            PARTNO    R        O 10  4
     A            PARTCL    R        O 10 23
     A            SERIALNO  R        O 10 35
     A            PQTY      R        O 10 54EDTCDE(3)
     A            PQDATEIN  R        O 10 61
     A            PQDATEOUT R        O 10 70
     A            PQSTATUSD     12A  O 11  4

Unless they are refined for input somewhere I'm surprised it passed the
precompiler check.  If they ARE in fact redefined somewhere in the
program can you show us that as well??

Thanks,
Tommy Holden