Archives of the TeradataForum

Message Posted: Tue, 28 Jan 2003 @ 20:56:50 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

HI,

PLEASE HELP ME ON THE I AM READING TERDATA TABLE BY USING COBOL. I WANT TO WRITE VARIABLE LENGTH RECORD OUTPUT.

I HAVE TABLE EMPLOYE

EMP_NO INTEGER NOT NULL,
EMP_NAME VARCHAR(40),
EMP_AGE INTEGER,
EMP_DOB DATE,
EMP_ADDRES VARCHAR(60),
EMP_STATUS BYTEINT

EMP_NO  EMP_NAME        EMP_AGE EMP_DOB EMP_ADDRES      EMP_STATUS
1001    Jeffrey L. Turner       35      1968-02-10      QQQQQQQQQQQQQQQQ
1
1002    Thomas W. King  40      1963-04-01      WWWW
100     Sam T. Campbel  45              RRRR    0
1       Pete R. North           1954-01-11              2
4       Raja X. Sarker          1970-11-12      S       44

WE WANT THE OUT PUT RECORD SHOULD BE WRITE LIKE THIS IN FILE. THIE PROGRAM WILL BE RUNNING ON MAIN FRAME

file should be like this

1001~Jeffrey L. Turner~35~1968-02-10~QQQQQQQQQQQQQQQQ~1~
1002~Thomas W. King~40~1963-04-01~WWWW~~
100~Sam T. Campbel~45~~RRRR~0~
1~Pete R. North~~1954-01-11~~2
4~Raja X. Sarker~~1970-11-12~S~44~

PLEASE HELP ME ON THIS.

Thanks

Sreya

	<Prev	Next>		<<First	<Prev	Next>	Last>>