Re: *varying vs varchar

He didn't have OPDESC on the prototype, so CEEDOD/CEEGSI aren't going to work.

He could fix it by adding OPDESC and then writing code to get the lengths of everything and coding the routine to make sure it never exceeds that length. But, this seems like a lot more work with no benefit.

Just remove the options(*varsize) it's not doing any good.


On 4/29/2022 1:11 PM, Birgitta Hauser wrote:

I'd also remove all OPTIONS(*VARSIZE) if CONST is specified.

The called procedure has no way to detect the lengths of these fields

For an in/out parameter the called procedure can determine the length of the passed variable with the CEEDOD API (assumed the OPDESC keyword is specified within the Prototype of the called procedure);
https://www.ibm.com/docs/en/i/7.4?topic=ssw_ibm_i_74/apis/CEEDOD.htm

Then you can substring exactly the passed data from the parameter.
When returning data, you also have to return the data in the length of the passed variable (determined with the CEEDOD API).


Mit freundlichen Grüßen / Best regards

Birgitta Hauser
Modernization – Education – Consulting on IBM i