column names

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
tostay2003
Participant
Posts: 97
Joined: Tue Feb 21, 2006 6:45 am

column names

Post by tostay2003 »

i dont know where this question fits. Sorry to post it over here, if i posted it wrongly.

i need to find out the column names from cobol copy book from a spreadsheet..

can you help me how to find out that..

I need to prepare the column list from the spread sheet.

few samples from spread sheet.

Tif Ident SP (key) Ident label Tif Data Area

CONS-TRANS-DOC 00*HEADER *HEADER
CONS-TRANS-DOC 00AAA AAA POSTED-REACT WRD
CONS-TRANS-DOC 00ABA ABA ARRS-BD ADJ 4/88
CONS-TRANS-DOC 00ADJ ADJ ADJ LOAN BAL
CONS-TRANS-DOC 00APP APP LOAN APPL
tostay2003
Participant
Posts: 97
Joined: Tue Feb 21, 2006 6:45 am

Re: column names

Post by tostay2003 »

Doing a bit of indenting. Ray pls try to help
----------------------------------------

Tif Ident SP (key) Ident label Tif Data Area

CONS-TRANS-DOC 00*HEADER *HEADER
CONS-TRANS-DOC 00AAA AAA POSTED-REACT WRD
CONS-TRANS-DOC 00ABA ABA ARRS-BD ADJ 4/88
CONS-TRANS-DOC 00ADJ ADJ ADJ LOAN BAL
CONS-TRANS-DOC 00APP APP LOAN APPL
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Wrap your "code" in Code tags, use Preview to get the indenting right.
It's not easy to get a table definition from a spreadsheet; it would be way easier if you could dump it as a tab-delimited file.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply