Archives of the TeradataForum

Message Posted: Thu, 29 May 2003 @ 20:08:11 GMT

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

I think you can do it by declaring fields in the layout that don't get used in DML statements. Just like this that declares IN_EOL to mark the position of the new line character.

.LAYOUT INPUTLAYOUT;
      .FIELD IN_num_invoice                              * CHAR( 14);
      .FIELD IN_Id_Day                                  * CHAR( 8);
      .FIELD IN_EOL             * CHAR( 1);

The DML only uses :IN_num_invoice and :IN_Id_Day.

If you had one space between the num_invoice and id_day fields, I think you could use

.LAYOUT INPUTLAYOUT;
      .FIELD IN_num_invoice                              * CHAR( 14);
      .FIELD IN_SEP1                              * CHAR( 1);
      .FIELD IN_Id_Day                                  * CHAR( 8);
      .FIELD IN_EOL             * CHAR( 1);

Regards,

Adriano.

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