Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sun, 23 Apr 2006 @ 10:55:00 GMT


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


Subj:   Creating copybook corresponding to Teradata Field layout
 
From:   Anomy Anom

<-- Anonymously Posted: Sunday, April 23, 2006 05:40 -->

Hi All,

I am trying to create a copybook corresponds to Teradata Field layout. But most of my fields are like DECIMAL(13,2), INTEGER, SMALLINTetc So for DECIMAL fields i have declared as 9(11)v99 COMP-3. But it has populated nulls for that field instead of values. So i have changed to S9(11)V99 COMP-3.So it worked fine. Is it necessary to mention S for COMP-3 fields. Could any one please tell me for what fields we have to declare COMP and What is the COBOL equivalent picture clause for INTEGER and SMALLINT.


Thanks



     
  <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