DSXchange

Posted: **Thu Mar 15, 2007 6:00 pm**

When I try to load a table definition in CFF stage, DataStage (currently using DataStage server) crashes. The Cobol copybook has the famous "OCCURS ...DEPENDING ON". Not sure if the crash is related to this.

Have attached the portions of the copybook here. I would appreciate if anyone could help me.

I have only one ODO in this copybook and I tried to flatten the occurs.

Thanks
Raj

Code: Select all

       *
       01 PAID-CLAIM-RECORD. 
       05 HEADER.
          10 FILLER                                         PIC X(2).
          10 SEGMENT-CNT                                    PIC S9(4).
          10 PLAN-CODE                                      PIC X(02).
          10 PLAN-CODE-N REDEFINES PLAN-CODE.
             15 PLAN-CODE-N                                 PIC 9(02).
          10 CLAIM-TYPE                                     PIC X(01).
          10 CLAIM-TYPE-N REDEFINES CLAIM-TYPE.
             15 CLAIM-TYPE-N                                PIC 9(01).
          10 CCN                                            PIC S9(13).

Code: Select all

        5 CLAIM-DETAILS.
          10 DETAIL-SEGMENT-1 OCCURS 0 TO 99 TIMES 
             DEPENDING ON SEGMENT-CNT.
            12 SEGMENT-1                                    PIC X(250).
            
            12 COMPOUND-DRUG-SEGMENT REDEFINES SEGMENT-1.
            
             15 SEGMENT-TYPE-1                              PIC X(01).
             15 FILLER-1                                   PIC X(249).
            12 MAIN-SEGMENT-1 REDEFINES SEGMENT-1          PIC X(250).
            12 MAIN-SEGMENT-1.
             15 SEGMENT-TYPE-M-1                            PIC X(01).
             15 CCN-LINE-NUMBER-1                           PIC 9(02).
             15 DET-MEDI-CAL-AMT-BILLED-1                PIC S9(7)V99.
             15 DET-MEDI-CAL-AMOUNT-PAID-1               PIC S9(7)V99.
             15 MEDICARE-AMOUNT-BILLED-1                 PIC S9(7)V99.
             15 MEDICARE-AMOUNT-PAID-1                   PIC S9(7)V99.
             15 DET-FROM-DATE-OF-SERVICE-1.

Posted: **Thu Mar 15, 2007 7:46 pm**

Welcome! :D

I haven't worked with the CFF stage anytime recently, but do recall that while it supports OCCURS it does not support one with a DEPENDING ON clause. Check the Functionality section of the CFF Stage pdf documenation for more information.

Didn't think it would 'crash' anything, however.

Posted: **Fri Mar 16, 2007 7:42 am**

Is there any limitation on the number of columns DS can support? After flattening the occurs I get around 18918 fields. Will this be the cause for DS to crash?

Also CFF documentation states that it supports "Fixed OCCURS with no DEPENDING ON clause." I did see many previous posts on this and am not sure what the work around would be. So can anyone please let me know if there is a work around for this.

chulett wrote:Welcome! :D

I haven't worked with the CFF stage anytime recently, but do recall that while it supports OCCURS it does not support one with a DEPENDING ON clause. Check the Functionality section of the CFF Stage pdf documenation for more information.

Didn't think it would 'crash' anything, however.

Posted: **Fri Mar 16, 2007 1:29 pm**

The documentation means that DataStage supports OCCURS n TIMES but does not support OCCURS 0 TO n TIMES DEPENDING ON column

While ever you have OCCURS DEPENDING ON in your copybook, the CFF stage is not going to be able to handle it. Prior to version 8.0, anyway.

Posted: **Fri Mar 23, 2007 7:22 am**

I understand that CFF in DataStage server will not be able to handle "OCCURS DEPENDING ON". But even after changing this to fixed OCCURS (there are 100 occurs) DataStage crashes after loading the table definition and flattening the occurs. It does not allow me to select the columns.

I would appreciate if someone could help me here. Copybook can be downloaded from http://www.yousendit.com/download/M3Bre ... NkUwTVE9PQ .

Thanks
Raj

Posted: **Fri Mar 23, 2007 7:33 am**

Seems to me you would be best served by contacting Support for this.

Posted: **Wed Mar 28, 2007 6:08 pm**

Recieved a patch (a new .dll file for the CFF stage) from IBM that resolved the fixed occurs pertaining to this copybook (had 100 occurs).

DSXchange

DataStage Crashes while loading table definintion

DataStage Crashes while loading table definintion