DSXchange

Craig, Thank you for the hint. By default it is giving the syntax as below in the STP stage. BEGIN :3 := exch_test(:1, :2); END; It had the Generate Procedure Call tab checked which is by default. When I uncheck it and modify the syntax as below it worked like a charm. BEGIN :3 := exch_test(:1, :1);...

Hi Craig, When I split the Input column with a different name and pass it to the STP stage, the function works fine(So essentially I would be duplicating the input column with a different name). Since the column names are different the function in the STP stage is accepting the parameters. The issue...

Hi All, We are using a STP stage to call a pl/sql function which requires multiple input parameters. My requirement is to pass same input column to two of the parameters in the function. But when I map same column in the STP stage to those two parameters the job fails with error message "Stored...

Hi all,
Thanks for your replies.Yes as you suggest it is going to be very difficult in dealing with the packed decimal through datastage alone.I tried different options in using datastage sdk routine transformations as Mike suggested but not much of the result could be seen.
Thank you all
vijay

Hi , i am just transforming the data from ascii to ebcdic formats using the ebcdic conversion dsfunction.other than that i am not using anyother specific routines.the conversion looks ok for all the char,varchar2 fields except for the packed decimal fields.The datatype for these fields is numeric.Fo...

Hi ALL, I am converting data from ascii format to ebcdic format.My source is oracle table and i am loading the ebcdic data into a sequential file so that the file can be ftp'ed to AS/400 system.The problem is that for some of the fields in the target AS/400 the datatypes are packed.So when the file ...