 |
 |
Archives of the TeradataForum
Message Posted: Mon, 12 Jul 2004 @ 13:26:41 GMT
| Subj: | | Re: Windows-based Fast Export Script |
| |
| From: | | Geoffrey Rommel |
| | I need to get rid of the 'Small Square followed by space' from the beginning and end of every field. | |
Your query includes character literals as separate fields. These are varchar and therefore preceded by smallint length fields, which are
the odd characters you have noticed. For instance:
SEL NPANXXX (FORMAT '9999999999') (CHAR(10))
, ','
, OWNER_MARKET_ID (FORMAT '9999999999') (CHAR(10))
In the query above, the comma (varchar) will be preceded by a binary length of 1 (x'0001' or x'0100', depending on the platform). Others
have already suggested ways around this problem.
| |
