 |
 |
Archives of the TeradataForum
Message Posted: Thu, 21 Nov 2002 @ 19:09:43 GMT
| Subj: | | Re: Continuations in FastLoad |
| |
| From: | | Geoffrey Rommel |
| | Could you define it as two fields of 40 chars each and concatenate them? | |
| | I realise this a bit cumbersome. | |
Good idea ... but alas, no.
,IN_STR_ADR_LN_1 (CHAR(40),NULLIF=
'0000000000000000000000000000000000000000'XC||
'0000000000000000000000000000000000000000'XC )
,IN_STR_ADR_LN_2 (CHAR(40),
NULLIF='00000000000000000000000000000000000000000000000000000000000000000000'XC)
,IN_CITY (CHAR(20),
NULLIF='0000000000000000000000000000000000000000'XC
,IN_ST_CD (CHAR(02),NULLIF='0000'XC)
,IN_ALPHA_CNTRY_CD (CHAR(03),NULLIF='000000'XC)
DDNAME = INFILE;
**** 14:00:53 DEFINE Syntax Error
**** 14:00:53 Missing ')' in definition for column: IN_STR_ADR_LN_1
| |
