AW: SQL Issue

Hi,

this is not a problem of embedded SQL or a bug.
It's the normal behaviour like the RPG compiler handels numeric fields.

Zoned (data type S) and binary (data type B) stand alone fields get
converted into packed fields.
They were even converted if use the LIKE keyword in the D-Specs or *LIKE
DEFINE in the C-Specs.

If those fields are defined or used as data structure subfields they get not
converted.
The data structures can be defined internally or externally.

If fields are defined somewhere else, i.e. in files in the F-Specs and put
into datastructures without specifying a data type, packed numeric fields
get coverted into zoned.

Integer fields (data types I and U) get not converted into packed fields,
even if they are defined as stand alone.

Mit freundlichen Gru?en / Best regards

Birgitta

"Shoot for the moon, even if you miss, you'll land among the stars."
(Les Brown)

-----Ursprungliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]Im Auftrag von Bruce Collins
Gesendet: Dienstag, 16. Mai 2006 15:49
An: RPG programming on the AS400 / iSeries
Betreff: SQL Issue


Have any of you Embedded SQL people ever run into this issue. I can
define in the D specs a variable we will call counter as 3p 0 and
counter1 as 3s 0.
When I compile the programs the xref shows both fields as 3, 0 Packed.
Both fields are stand alone. If I create a data structure and define
them within it the fields come out as defined.

Any thoughts on this problem?

I am on V5R3 Cume 6045

Thanks

Bruce "Hoss" Collins
IBM Certified Specialist - eServer i5 iSeries System Administrator V5R3
Cisco Certified Network Associate
AAA Cooper Transportation
Dothan, AL 36303
(334)793-2284 x2434


--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.