Re: Field shows as packed and zoned

[Brian Parkins <parkib@xxxxxxxxxx>]

>tried that, didn't work: the database field itself is zoned, so if I 
>define the DS field like the database field, it automagically also 
becomes 
>zoned.

Sorry Peter, I've gotten confused. 

I thought you said the File Defn was 2P0 - but that the SQLRPGLE program 
had mysteriously re-defined as 2S0.

>>We have a file, in which a certain field is defined as 2 packed with 
zero 
>>decimals.  In all dependant logicals, the field is also 2P0, as can be 
>>seen in QADBIFLD.

>>In one program, however - an SQLRPGLE - this field shows as 2 ZONED with 

>>zero decimals.

Can you post some small code fragments for us to see?

Brian Parkins