|
|
|
Forum Member
 
Group: Forum Members
Last Login: 9/28/2006 5:14:00 AM
Posts: 26,
Visits: 1
|
|
HAI
I am new to mload. will vartext file format support integer and date format.
Thank u.
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 7/3/2008 11:03:47 PM
Posts: 41,
Visits: 5
|
|
Hi,
No i dont think so it will support. You can use integer format
Thanks
Angel
|
|
|
|
|
Supreme Being
Group: PAC and SFT Members
Last Login: Yesterday @ 4:20:22 PM
Posts: 327,
Visits: 504
|
|
VARTEXT says the input file is delimited text. The input fields can then be converted/CAST to Teradata datatypes using standard SQL expressions or in some cases will be implicitly CAST by Teradata if you supply the FORMAT description.
Whether or not that allows your data to be loaded easily will depend on how the text is formatted. For example, Teradata date formats require the month and day components to be two digits (leading zero if less than 10).
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 9/28/2006 5:14:00 AM
Posts: 26,
Visits: 1
|
|
Hi,
Thank u for the Suggestions . Now if I use FORMAT (TEXT or UNFORMAT)in multiload how will I specify the Delimiters and EOF condition.
Thank U.
Giri
|
|
|
|
|
Supreme Being
Group: PAC and SFT Members
Last Login: Yesterday @ 4:20:22 PM
Posts: 327,
Visits: 504
|
|
TEXT or UNFORMAT don't recognize field delimiters, they are fixed format. If there are delimiters in exactly the same column position in every record, you could ignore them - either using explicit starting column position for the FIELDs or using FILLERs for relative column positioning.
TEXT expects a newline as the record delimiter. UNFORMAT expects no record delimiter; if there is one you can define it as FILLER so it is ignored.
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 9/28/2006 5:14:00 AM
Posts: 26,
Visits: 1
|
|
Thank u.
Now I have have got a better idea.
|
|
|
|