Teradata Forums / Teradata / Teradata Tools and Utilities / FastExport script and output delimiters / Latest Posts

RE: FastExport script and output delimiters

AndrewLivingston — Fri, 01 Aug 2008 09:48:39 GMT

Sushant!Arguably a better approach, as this would give you absolute control over the placement not only of delimiters, but of the actual data as well. Using this FE script would help write the FastLoad script.Thanks!Andrew

RE: FastExport script and output delimiters

sp230071 — Fri, 01 Aug 2008 09:44:28 GMT

select CAST(first_col AS CHAR(N)) || ';' || CAST (second_col AS CHAR(N)) || etc... from my_tableWe can also do like thisselect CAST(first_col AS CHAR(N)) ,cast(';' as char(1)) ,CAST (second_col AS CHAR(N)) , etc... from my_table

RE: FastExport script and output delimiters

AndrewLivingston — Thu, 20 Sep 2007 09:41:06 GMT

Fabio,

Excellent! I don't think I would ever have even thought of that. Looking at the code, yes, that would work a treat.

Many thanks for your suggestion!

Andrew

RE: FastExport script and output delimiters

Fabio — Thu, 20 Sep 2007 08:42:13 GMT

I typically do the following, in order to eliminate the TABs:

select CAST(first_col AS CHAR(N)) || ';' || CAST (second_col AS CHAR(N)) || etc... from my_table

where "||" is the concatenation operator.

RE: FastExport script and output delimiters

AndrewLivingston — Tue, 11 Sep 2007 08:19:19 GMT

Zebulon,

Interestingly enough, that is exactly what one of the DBA suggested.

It is a much simpler method that writing an OUTMOD function. The only drawback I can see is that it still inserts the tab, but as long as the application you are importing to is set to recognise another delimiter it should be fine. Also, depending on the size of the txt file, you can always do a bulk find/replace.

Many thanks for your post!

Andrew

RE: FastExport script and output delimiters

zebulon — Tue, 11 Sep 2007 08:00:10 GMT

Here is what I've done, just add the delimiter in my query, not elegant but it's work!

select first_col(char(0)), ';' (char(1)) etc... from my_table

FastExport script and output delimiters

AndrewLivingston — Mon, 10 Sep 2007 11:15:18 GMT

Howdy folks,

I just had a query from a user where he is using FastExport and wants to state what delimiter the output file should use. I have had a look on-line, consulted the FastExport user guide, and it appears that you cannot specify this, like you can in FastLoad.

Is the only way to achieve this to use an AXSMOD or INMOD procedure?

Many thanks!

Andrew Livingston