Hi
While using function like trim,substr in the sql for progress database it is working fine.But while using the same query in the ODBC stage and run it is giving syntex error.Any idea why?
Select substr(company_name,1,5) from company works fine in the progress database.
But the same query giving error in ODBC stage.
Thanks in advance.
getting syntex error for progress database
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
ODBC has its own protocols and rules. The name of the function may be SUBSTRING rather than SUBSTR. You have to use the name that is specified in the ODBC grammar specification.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.