First I want to apologize for my ignorance in RPGLE...we typically don't use this programming language. I've researched this issue for several days now, and cannot find a resolution. I'm currently trying to write a field procedure program. I have taken the IBM RPGLE example (https://www.ibm.com/support/knowledg...yfpexample.htm), and started to modify it to work for us.
This program allows for several SQL types, clob, varchar, char, blob, etc, but I needed to add zoned numeric. So, to begin, I took the layout, and added everywhere necessary for the SQL_TYP_NUMERIC (488), and am now getting the error in the subject. Everything works when I set the fieldproc on a varchar column. I have stepped through the program on both numeric and varchar, and there are no errors, and everything looks like it is working, but when the fieldproc program finishes, I get the error:
Message ID . . . . . . : SQL0685
Date sent . . . . . . : 03/18/20 Time sent . . . . . . : 16:17:04
Message . . . . : Field procedure on column ECNUM has returned invalid data.
Cause . . . . . : Field procedure on column ECNUM has returned invalid data.
Recovery . . . : Change the field procedure to return valid data.
Thank you in advance for any help you can give on this.
This program allows for several SQL types, clob, varchar, char, blob, etc, but I needed to add zoned numeric. So, to begin, I took the layout, and added everywhere necessary for the SQL_TYP_NUMERIC (488), and am now getting the error in the subject. Everything works when I set the fieldproc on a varchar column. I have stepped through the program on both numeric and varchar, and there are no errors, and everything looks like it is working, but when the fieldproc program finishes, I get the error:
Message ID . . . . . . : SQL0685
Date sent . . . . . . : 03/18/20 Time sent . . . . . . : 16:17:04
Message . . . . : Field procedure on column ECNUM has returned invalid data.
Cause . . . . . : Field procedure on column ECNUM has returned invalid data.
Recovery . . . : Change the field procedure to return valid data.
Thank you in advance for any help you can give on this.
Comment