DSXchange

Please find the fields below defined in sequential file.All the fields are set as null. 020500 10 X56216-INTEREST-DAILY-FACTOR PIC -9(02).9(07). defined as decimal(9,7) with field width=9 and Null field value=' ' nine spaces 020600 10 X56216-INTEREST-DAILY-CHARGE PIC -9(05).9(06). defined as decimal...

Chulett

I have already defined a new 10 fields in job and new fields appends at the end of file.

i am using the sequential file stage to read the fixed width file and here is the format Record Level Record Delimiter=UNIXLINE RecordLenth=fixed FieldDefaults Delimiter=none Quote=none i am defining the fixed width of each field and i am familiar with Cobol datatypes. For Ex for ILP-LOAN-NUMBER i a...

Hi chullet here is the copybook 001100* BASIC LOAN INFO 001200 10 X56216-ILP-LOAN-NUMBER PIC X(11). 001300 10 X56216-LOAN-STATUS PIC X(03). 001400 10 X56216-LOAN-TYPE PIC X(03). 001500 10 X56216-LOAN-PURPOSE PIC X(03). 001600 10 X56216-LOAN-SUB-PURPOSE PIC X(02). 001700 10 X56216-ORIGINAL-TERM PIC 9...

hi chullet

The loan number is "20005199394" and the STATUS is "C-O" this is correct .

hi, i tried to read the fixed width but getting the below error ##I IIS-DSEE-TFSC-00001 14:05:18(013) <main_program> APT configuration file: /opt/IBM/InformationServer/Server/Configurations/default.apt >##E IIS-DSEE-TOIX-00158 14:05:19(000) <sf_CONSUMER_LOAN_DAILY_ACCOUNT,0> Error reading on import....

thanks for reply chullet where i have to escape the quotes form the query . i tried by another way by checking the proper spaces among the concatenation of the fields.The query given below i used below for same on column taking two times one with space and one without . After removing the space amon...

hi, i am getting error while fetching the query .i ran the same query in Data studio against the DB2 tables and ran fine however while using the same in DB2 stage getting the below error. EDWSTG1_ORBIT_MASTER: DB2 reported: SQLSTATE = 42603: Native Error Code = -10: Msg = [IBM][CLI Driver][DB2/LINUX...

thanks it works

hello, i am tried to do conversion from military format to standard format. the job design is db2 stage...........xfm..................oracle The source column datatype is char and want to load according to standard time format. The target column datatype is varchar. the current format is 22.48.51 b...

i am able to figure it out and found break in the definitions.
Thanks for help.

NO there are no stage variables.i am using the derivations for HEADER column created. i have compiled the job by removing header to check whether job is compiling or not and job compile fine but after using the HEADER column again and give the derivation same error occur while compiling.There is no ...

i am defining header as request in the transformer stage follwed bu XML output stage and WEbservice and give the values above however i corrected the header part given below but giving the same compiling error. Any advice on this. '<soapenv:Header xmlns:soapenv="http://schemas.xmlsoap.org/soap/...

Hi, i am getting the error while compiling the job. In the transformer stage i am declaring the header in transformer stage . '<soapenv:Header xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">' : '<wsse:Security xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-...

hi, i am extarcting the date from comma delimiter file and using the XML output stage to create the XML but i am getting the following errors. xmlo_Generate_Request,0: Caught unknown exception from runLocally(). xmlo_Generate_Request,0: The runLocally() of the operator failed. xmlo_Generate_Request,...