John in So Cal
Member
Hello
I'm trying to call X01100 from a DB2 external stored procedure in my C# web app. The X01100 RPG program returns a "9 element array, 40 characters long" as it's second parameter. I successfully call the SP from the C# code.
The #1NBR return field contains a 3 and the 3rd paramater(PS0116) is populated with address info.
The second, array parameter is empty. I'm fairly certain it's just a small data type conversion mess up.
Here's my SP
CREATE PROCEDURE ENDDEVSQL/X01100 ( INOUT DS1100 CHAR ( 256 ), INOUT
AD CHAR ( 360 ), INOUT I0116 CHAR ( 291 )) LANGUAGE RPG
SPECIFIC ENDDEVSQL/X01100
NOT DETERMINISTIC NO SQL EXTERNAL NAME 'JDFOBJ/X01100'
PARAMETER STYLE GENERAL
Any help would be great!!
TIA
I'm trying to call X01100 from a DB2 external stored procedure in my C# web app. The X01100 RPG program returns a "9 element array, 40 characters long" as it's second parameter. I successfully call the SP from the C# code.
The #1NBR return field contains a 3 and the 3rd paramater(PS0116) is populated with address info.
The second, array parameter is empty. I'm fairly certain it's just a small data type conversion mess up.
Here's my SP
CREATE PROCEDURE ENDDEVSQL/X01100 ( INOUT DS1100 CHAR ( 256 ), INOUT
AD CHAR ( 360 ), INOUT I0116 CHAR ( 291 )) LANGUAGE RPG
SPECIFIC ENDDEVSQL/X01100
NOT DETERMINISTIC NO SQL EXTERNAL NAME 'JDFOBJ/X01100'
PARAMETER STYLE GENERAL
Any help would be great!!
TIA