Archives of the TeradataForum

Message Posted: Wed, 11 Oct 2006 @ 19:05:59 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Dear Fachtna,

Use the following ====>

     ||'0D'XC||

Where ever you wish to have a CarriageReturn in your record set.

e.g. ==>

     SELECT
       'INSERT INTO NEW_BOX_ROW_COUNT (DB_NAME,TAB_NAME,ROW_COUNT)'
     ||'SELECT '
     || ''''
     || DB_NAME
     || ''''
     || ','
     || ''''
     || trim(TAB_NAME)
     || ''''
     ||',COUNT(*) FROM '||DB_NAME||'.'||trim(TAB_NAME)||' GROUP BY
     1,2;'||'0D'XC
     FROM TABLE_DRIVER;

Notice that, just before the 'FROM TABLE_DRIVER' clause, I have appended the ||'0D'XC .

Thanking you,

regards,

Mohan Wagh.

PS:- When you mention that ">> Mainframe only lets us use DML scripts of 80" OR ">> using a fast export the file is about Char(200) in length."

Here do you mean that the LINE-WIDTH allowed in a file is 80 characters?

If that is the case, then is there any way for you to Manipulate the LINE-WIDTH?

	<Prev	Next>		<<First	<Prev	Next>	Last>>