CPF5035 Data mapping error

Hi folks,

I searched the archives and didn't find anything to help me with my error so now that I have figured it out, I thought I would send this in case it might help someone in the future.

I have a DDL-described table, and among other columns, have one defined as follows:
PONUMBERS VARCHAR(760) CCSID 37 NOT NULL

I found that I needed the following control-spec in my rpg module:
h cvtopt(*novarchar)

because without this, the rpg dump listing showed that PONUMBERS was CHAR and not VCHAR.

So even if my getPOs procedure returns varying-length data:
D getPOs PI 760a varying
D orderType 4a const
D orderNumber 17a const

The following statement moves the returned data into a character field, which then causes an error when writing to the database file.
poNumbers = getPOs(orderType: orderNumber);

The control-spec fixed it.

Happy computing.

Glenn Gundermann
Work: 905-501-6596
Cell: 416-317-3144

To learn more about Kuehne + Nagel Ltd, please visit our website at: www.kuehne-nagel.com For the Kuehne + Nagel email disclaimer, visit: http://www.kn-portal.com/material/Electronic_Email_Disclaimer_English_French.pdf



Visitez le site internet de Kuehne + Nagel Lt?e: www.kuehne-nagel.com Notre d?charge de responsabilit? est disponible comme suit: http://www.kn-portal.com/material/Electronic_Email_Disclaimer_English_French.pdf