Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Teradata/cobol
 
From:   sreya malladi

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016