I'm pretty new to BTEQ script. I was trying to load a table which has a date column but it's not being inserted properly.
I'm using the below code, this loads the data but the date column loads a s a float and not as a date field.
I've tried changing the date field to varchar and date format both in the script and table but it doesn't load it.
Can anyone tell me where I'm doing wrong?
--For creating table--
DROP TABLE play_pen.Stock_Clearance;
CREATE MULTISET TABLE play_pen.Stock_Clearance ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
.IMPORT VARTEXT ',' FILE = 'D:\Displaced_Lines.txt'
.REPEAT * PACK 5000;
INSERT INTO play_pen.Stock_Clearance
( RETAIL_OUTLET_NUMBER ,
- when you define VARTEXT all fields must be defined as VARCHAR in USING
- a FLOAT is a FLOAT and not a DATE