#DateForumTypeThreadPost
916 Feb 2012 @ 10:45 PSTToolsReplyhow can i remove the extra spaces when using bteq to export data into a flat txt file To eliminate the separator strings that BTEQ adds for Field Mode,  you can use... .SET SEPARATOR 0
819 Jan 2012 @ 11:27 PSTToolsReplyFormatting BUG in BTEQ EXPORT of a SHOW Procedure First, BTEQ is using Field Mode to get the DBS' response data whereas SQLA is not. Second, BTEQ is -- by design -- adding the space to ensure acceptable concatenation of the parcels returned...
717 Jan 2012 @ 02:00 PSTToolsReplyBteq - How can I write stuff to my output file besides what is returned from the DB? Also, just a point of clarification... The Teradata SQL statement "ECHO" can be used outside of a macro but can only echo BTEQ commands. To do what you were intending, you co...
617 Jan 2012 @ 01:44 PSTToolsReplyBteq - How can I write stuff to my output file besides what is returned from the DB? Note that you will only get title values in field mode ( aka Report Mode ).
517 Jan 2012 @ 12:14 PSTToolsReplyBteq - How can I write stuff to my output file besides what is returned from the DB? Are you really wanting to use DATA format ( rather than REPORT format ) for the selected time stamps ?
419 Oct 2011 @ 07:23 PDTToolsReplyLast character of the file is not laoding into a table while using bteq script What you've figured out is that to prevent BTEQ from thinking it has reached the end of the file, an EOL sequence must be used on each record. You inserted this sequence when you "hit a...
319 Oct 2011 @ 03:57 PDTToolsReplyLast character of the file is not laoding into a table while using bteq script I'm understanding you to be saying that its just for the last import record that the value for column G is one less character than it should be. Please try SELECTing the data rather...
219 Oct 2011 @ 01:22 PDTToolsReplyLast character of the file is not laoding into a table while using bteq script Please supply more details ... What BTEQ version are you using ? What data format are you using for the IMPORT command ? What does your USING clause look like ?
123 Jul 2010 @ 02:56 PDTToolsReplyFailure 2673 The source parcel length does not match data that was defined.LOBCOLS option needed on the IMPORT statement. The thread continued here... http://developer.teradata.com/applications/articles/large-objects-part-1-loading