Archives of the TeradataForum
Message Posted: Wed, 02 May 2007 @ 19:33:37 GMT
Subj: | | Re: Generated SQLs getting truncated |
|
From: | | Afreen, Sazia |
Thank you very much for your reply. We tried the .set width before the export within the script. Still getting the truncation at the same point
like,
Collect Statistics Using SAMPLE Column ACCOUNT_SID on
DB.S2_ACCT_PROD_SUBSCR
From the error log, we are getting the followings:
.LOGOFF
*** You are now logged off from the DBC.
+---------+---------+---------+---------+---------+
.SET SESSION TRANS BTET
+---------+---------+---------+---------+---------+
.SET FORMAT ON
+---------+---------+---------+---------+---------+
.SET WIDTH 255
+---------+---------+---------+---------+---------+
.TITLEDASHES OFF
+---------+---------+---------+---------+---------+
Are these set commands working?
Thanks
|