Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
substr vs. substring
- Thread starter MSIsam
- Start date
Hi,
I should point out that if are using SQL assistant and you check the BOX
ALLOW ODBC extensions
That under the cover SQL Assistant will convert the ODBC syntax to Teradata Syntax and submit the query using the Teradata Syntax.
Therefore if you take the pre-converted query over to BTEQ, which doesn't do that conversion, your query may not run.
---
I should point out that if are using SQL assistant and you check the BOX
ALLOW ODBC extensions
That under the cover SQL Assistant will convert the ODBC syntax to Teradata Syntax and submit the query using the Teradata Syntax.
Therefore if you take the pre-converted query over to BTEQ, which doesn't do that conversion, your query may not run.
---
- Status