Archives of the TeradataForum

Message Posted: Wed, 28 Feb 2007 @ 18:18:19 GMT

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

Hi Michael,

It is really helpful for my code.. thx.

Can u pls check my layout flow..

     .LAYOUT REFARENCE_LAYOUT;
           .FILLER IN_Indicator                           1 VARCHAR(3);
           .FIELD IN_rec_a                             * VARCHAR(1);
           .FIELD IN _cd_a                               * VARCHAR(8);
           .FIELD IN_tm_a                             * VARCHAR(15);

           .FIELD IN_type_b                             * VARCHAR(3);
           .FIELD IN_cd_b                              * VARCHAR(32);
           .FIELD IN_cd_desc_b                         * VARCHAR(80);
           .FIELD IN_grp_cd_b                          * VARCHAR(32);

           .FIELD IN_type_c                        * VARCHAR(10);
           .FIELD IN_cd_c                          * VARCHAR(10);

           .FIELD IN_type_d                        * VARCHAR(2);
           .FIELD IN_type_cd_d                    * VARCHAR(30);
           .FIELD IN_type_desc_d                  * VARCHAR(80);

           .FIELD IN_type_e                        * VARCHAR(1);
           .FIELD IN_cd_e                          * VARCHAR(8);
           .FIELD IN_tm_e                        * VARCHAR(3);
           .FIELD IN_zn_e                            * VARCHAR(18);

And

     .IMPORT INFILE /home/vk9187/tab_BID/tab_BID_data_feed_Reference_20070222201500_1.txt
           LAYOUT REFARENCE_LAYOUT
           FORMAT VARTEXT '|'
           APPLY INS_rgstr_allct WHERE IN_Indicator='R'
           APPLY INS_grp_allct_rec WHERE IN_Indicator='FF'
           APPLY INS_cos WHERE IN_Indicator='CO'
           APPLY INS_type_rec WHERE IN_Indicator='CT'
           APPLY INS_trlr WHERE IN_Indicator='T';

But I'm facing no UTF0805 room space error.. but I have enough space in DB

Regards,

Ramu.

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