Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Mload of signed decimal input data
 
From:   Prescott, Kyle R

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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023