|
|
Archives of the TeradataForum
Message Posted: Wed, 31 May 2000 @ 19:48:01 GMT
Subj: | | Loading Packed data to A Date column |
|
From: | | Gloria Branham |
Problem : Input data is Julian date format packed format is (YYDDD)
Teradata column define as decimal leading zeros are
dropped.
Solution : Recreate table with column define as date. Date Format 'YYDDD'
New problem: Using fastload receiving error on define
---+----1----+----2----+----3----+----4----+----5----+----6-
0003 DEFINE
DIV (CHAR(01))
,PLANT (CHAR(02))
,TRANCODE (CHAR(02))
,TRANDATE (INTEGER(03))
,TRANTIME (CHAR(05))
,ITEMNUM (CHAR(15))
,FILLER1 (CHAR(08))
,ACTVDATE (CHAR(05))
**** 15:41:40 DEFINE Syntax Error
**** 15:41:40 Missing ')' in definition for column: TRANDATE
--------------------------------------------------------------------
What is the best format for loading this data?
Regards
Gloria Branham
Finance Systems - FPC
iTEK -W2B174
| |