Archives of the TeradataForum

Message Posted: Sat, 19 Oct 2003 @ 02:54:40 GMT

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

Try this....

1) Define the input as character data.

2) on the values clause of the insert DML statement, use the format '999v99S' to tell Teradata it is a zoned-decimal column (account for precision and scale - "S" on the end of the format string denotes zoned decimal).

.LAYOUT LAYOUT1;
.FIELD  IN_COL1 CHAR(5);

.DML MYINSERT;

INSERT INTO MYTABLE (COL1)
VALUES (:IN_COL1 (DECIMAL(5,2),format'999v99S');
/* modify format clause for precision and scale to match data pattern */

Kyle Prescott
UnumProvident - Data Strategies, 3-South

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