Copy book import into Complex flat file stage

[skp]

Hi,

I have copy book in my Unix system and would like to import the specification into datastage using Complex file stage.

Kindly let me know the process.

Thanks

[FranklinE]

Use the Table Definition import wizard. If you have specific problems with it, post the details.

[skp]

Hi,

While importing i am getting error message like,
"File contains no table definition(01 level record not found)"

Below is my cobol book,
01 ACCOUNT-IDENTIFICATION.
02 RECID PIC X(2).
02 COUNTID PIC S9(5).

Thanks.

[suryadev]

I received the same message earlier. see if you have more than one 01's in your copybook?

[skp]

No. I have only one 01. Below is the exact specification,

01 ACCOUNT-IDENTIFICATION.
02 RECID PIC X(2).
02 COUNTID PIC S9(5).

[chulett]

Guessing they're not starting in the correct column number for COBOL metadata, which is what.... 7? 10?

(think I've lost most of those brain cells)

[FranklinE]

Here's the required formatting for Cobol FD files, set by Cobol compiler requirements:

Code: Select all

Pos 1-6 skipped for syntax check. May contain labels or line numbers.

Pos 7 must be blank for active lines, contain '*' for comment lines. No other characters permitted.

Pos 8 is the first position for each line.

We indent for each higher level number for ease of reading. It's not required.

[FranklinE]

(think I've lost most of those brain cells)

Franklin's Law of Child Development and Parents' Ages:

1) Children learn by osmosis. They suck the brain cells from their parents' brains.

2) Predicted age of onset of senility is the sum of the parent's age and the ages of his or her children. No experiments or surveys have been done to determine if there is a plateau age for the children, after which the addition is no longer valid.

[chulett]

[skp]

Thanks Franklin. As you mentioned, I gave from 8th position and worked for me.