|
|
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
| |