 |
 |
Archives of the TeradataForum
Message Posted: Thu, 28 Apr 2005 @ 14:44:10 GMT
| Subj: | | Re: SQL using Ltrim function |
| |
| From: | | Victor Sokovin |
| | The above SQL runs fine on SQL assistant 6.1 but does not run when i submit it from mainframe through BTEQ v08.02.01.00. | |
Try TRIM instead of LTRIM.
| | Is there a configuration in SQL assistant that controls this(or probably an ODBC feature) because of which this SQL runs
fine? | |
It must be an ODBC function. There is a possibility in the SQLA options to disable ODBC extensions.
| | Is there a way to make this work on BTEQ without changing the code? | |
No, because LTRIM is not a TD function and Bteq does not use ODBC.
Regards,
Victor
| |
