03-25-15, 09:05 #1Registered User
- Join Date
- Jul 2014
Answered: Db2java procedure on ibm Data studio
I am getting some different issue.
I have written a db2java procedure that accepts two input arguments with char(100). The procedure is compiling & when I am able to run the procedure the datatype length is changing.
I have coded this on IBM data studio 4.1 & using Db2 c express on windows.
Below is the code
CREATE PROCEDURE POC12 ( IN userName CHAR(100),
IN password CHAR(100) )
EXTERNAL NAME 'XUV57G.DS_20150325142313:com.Pa588.p9815981i.POC1 2.x_POC12'
PARAMETER STYLE JAVA
This procedure got compiled without any error. When I am trying to call the procedure this is the way how the datatype length is changing.
This is changing from char(100) to char(1) when runtime. kindly let me know what I am missing here
"If the java sproc signature used String as the type of the parameters, you will need to adjust the DDL in DS before saving."
03-25-15, 11:40 #2Registered User
Provided Answers: 17
- Join Date
- Apr 2012
If the java sproc signature used String as the type of the parameters, you will need to adjust the DDL in DS before saving.