DSXchange

Posted: **Fri May 09, 2014 7:50 am**

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

Posted: **Fri May 09, 2014 8:07 am**

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

Posted: **Fri May 09, 2014 8:37 am**

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.

Posted: **Fri May 09, 2014 9:10 am**

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

Posted: **Fri May 09, 2014 10:24 am**

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

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

Posted: **Fri May 09, 2014 10:33 am**

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)

Posted: **Fri May 09, 2014 10:42 am**

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.

Posted: **Fri May 09, 2014 10:46 am**

chulett wrote:(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.

Posted: **Fri May 09, 2014 1:10 pm**

Posted: **Mon May 12, 2014 3:55 am**

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

DSXchange

Copy book import into Complex flat file stage

Copy book import into Complex flat file stage