Archives of the TeradataForum

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

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

<-- 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>>