Please help me working with CFF stage

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
sgunda
Premium Member
Premium Member
Posts: 1
Joined: Thu Apr 20, 2006 12:11 pm

Please help me working with CFF stage

Post by sgunda »

Hello,

I am trying to extract the data from a file ftp-ed from mainframes onto Unix in binary format through CFF satge.I have selected 'DATA FORMAT" as EBCDIC and record style as 'binary' in CFF stage.
I am getting the junk data when i click view data in CFF stage in the fields which are defined as a characters.
Surprisingly Comp3 packed decimal fields appear to be ok. Do I need to perform any pre-processing on this file before CFF stage??
Thanks for the help

Here is the cobol copy for this file.
01 WS-INPUT-FILE.
05 WS-COMPANY-CODE PIC X(02) VALUE SPACES.
05 WS-RECORD-TYPE PIC X(02) VALUE SPACES.
05 WS-COVERAGE PIC X(02) VALUE SPACES.
05 WS-RISK-ST PIC X(02).
05 WS-ACCIDENT-YEAR PIC X(04) VALUE SPACES.
05 WS-EFFEC-DATE PIC X(06) VALUE SPACES.
05 WS-DAC-CODE PIC X(01) VALUE SPACES.
05 WS-FEIN-CODE PIC X(10) VALUE SPACES.
05 WS-PREM-WRITTEN PIC S9(11)V99 COMP-3 VALUE ZERO.
05 WS-PREM-DEFERRED PIC S9(11)V99 COMP-3 VALUE ZERO.
05 WS-PREM-BILLED PIC S9(11)V99 COMP-3 VALUE ZERO.
05 WS-PREM-UNCOLLECTED PIC S9(11)V99 COMP-3 VALUE ZERO.
05 WS-SERV-FEE-COMM-WRIT PIC S9(11)V99 COMP-3 VALUE ZERO.
05 WS-SERV-FEE-COMM-DEF PIC S9(11)V99 COMP-3 VALUE ZERO.
05 WS-SERVICE-COMM PIC S9(11)V99 COMP-3 VALUE ZERO.
05 WS-OTHER-COMM PIC S9(11)V99 COMP-3 VALUE ZERO.
05 WS-SERV-FEE-COMM-BILL PIC S9(11)V99 COMP-3 VALUE ZERO.
05 WS-UNCOLLECTED-COMM PIC S9(11)V99 COMP-3 VALUE ZERO.
05 WS-OTHER-CHARGES PIC S9(11)V99 COMP-3 VALUE ZERO.
05 WS-UNEARNED-PREM PIC S9(11)V99 COMP-3 VALUE ZERO.
05 WS-PAID-LOSSES PIC S9(11)V99 COMP-3 VALUE ZERO.
05 WS-PAID-ALAE PIC S9(11)V99 COMP-3 VALUE ZERO.
05 WS-PAID-ALAE-REIMB PIC S9(11)V99 COMP-3 VALUE ZERO.
05 WS-PAID-ALAE-NONREIMB PIC S9(11)V99 COMP-3 VALUE ZERO.
05 WS-SAL-SUB PIC S9(11)V99 COMP-3 VALUE ZERO.
05 WS-SAL-SUB-RESV PIC S9(11)V99 COMP-3 VALUE ZERO.
05 WS-CASE-LOSS-RESV PIC S9(11)V99 COMP-3 VALUE ZERO.
05 WS-CASE-ALAE-RESV PIC S9(11)V99 COMP-3 VALUE ZERO.
05 WS-ALAE-RESV-REIMB PIC S9(11)V99 COMP-3 VALUE ZERO.
05 WS-ALAE-RESV-NONREIMB PIC S9(11)V99 COMP-3 VALUE ZERO.
05 WS-IBNR-LOSS-RESV PIC S9(11)V99 COMP-3 VALUE ZERO.
05 WS-IBNR-ALAE-RESV PIC S9(11)V99 COMP-3 VALUE ZERO.
05 EMPTY-FILLER PIC X(10) VALUE SPACES.


Thanks
Suresh.[/img][/code]
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

What values are you seeing for the text columns defined as value spaces? Are they all the same character and if so, which one? Have you checked to make 100% certain that your file on the UNIX box is actually still in EBCDIC and not in ASCII (this would explain a binary transfer with COMP-3 columns being correct)
Post Reply