All Forums Tools
giri 24 posts Joined 11/05
17 Jul 2006
MLOAD VARTEXT FORMAT

HAI

I am new to mload. will vartext file format support integer and date format.

Thank u.

ANGEL 20 posts Joined 02/05
18 Jul 2006

Hi,
No i dont think so it will support. You can use integer format

Thanks
Angel

Fred 415 posts Joined 08/04
18 Jul 2006

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).

giri 24 posts Joined 11/05
18 Jul 2006

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

Fred 415 posts Joined 08/04
19 Jul 2006

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.

giri 24 posts Joined 11/05
21 Jul 2006

Thank u.

Now I have have got a better idea.

You must sign in to leave a comment.