DSXchange

Im new on server jobs, so please bear me for sometime. We used SETNULL() function in parallel what is equivalent in server. I want to pass null to db2 date column. Row is loaded with null but Following warning msg comes : JobLoadFile..Transformer_22: At row 53, link "DSLink24", while proce...

ANY GURU AROUND ?

CFF -> Tx -> Seq. File When extracting cff file it warns with following msg. I tried different NLS mapping but same error. Input file is in CR/LF format. I viewed the data and some rows were having : character in it, i replaced : with blanks but still warning out. Extract702..seqTRANKEY.outTRAN: nls...

Want to make a tab delimited flat file (dos style). What value has to be used in Sequential file settings in FORMAT -> DELIMITER. I tried 011 but it didnt work. Its server job.

CFF -> Transformer -> Seq. file

I used following and it worked:

In a server job, have two columns:
TranDate Decimal(8) values= 20080812
TranTime Decimal(8) values= 00000000

and want to load into db2 timestamp column: TrandtTime Timestamp

Thanks.

Any help on this problem.

I have used CFF in a server job to extract multiformat (copybook) data and loaded in sequential files with FIELD DELIMETER as COMMA. Its defined as follows in copybook: 10 ACT-ANNUALAMT PIC S9(9)V99 COMP-3. in sequential file its defined as: Decimal 11,2 I can see the data is loaded properly in serv...

Decimal 11,2

I have used CFF in a server job to extract multiformat (copybook) data and loaded in sequential files with FIELD DELIMETER as COMMA. and its defined as in copybook: 10 ACT-ANNUALAMT PIC S9(9)V99 COMP-3. When i edit column properties its PACKED property is set to YES. following Import warning is comm...

I want to find and delete orphan and datasets not being used in windows. How can i do that ?

Thanks in advance.

One of my job is running fine and i just removed db2 stage with peek stage to view the data and getting this error:

main_program: Fatal Error: Cannot open sequential archive information return file: /tmp/aptseqarchinfo-486400

any idea what this error is?

Actual problem is to extract the data for different tables. How can i do this.

Any Comments !!

Im using cobol files first time for extraction. I loaded the cobol file definitions with following copybook. How can i read the data for different tables. If i can filter for each record type ? When i tried sequential file there was some binary data comming up but when I tried Peek to see the data t...