Has anyone created user-defined dynamic SQL in routine. I have a lookup table that contains the name of the column I need to update. I want to pass the column name to my update statement.
I want this to be done only using routines
Thanks
Dynamic prepared Sql using routines
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Search the forum for "BCI". The DataStage BASIC SQL Client Interface (BCI) is a set of DataStage functions that mimic the ODBC API functions. You can do whatever you like (in an SQL realm) with these.
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.
-
- Premium Member
- Posts: 66
- Joined: Mon Feb 21, 2005 10:40 am
- Location: Paris
SQL Client Interface Guide
There is an SQL_Client_Interfac_Guide.pdf which may have come with your Datastage documentation on your installation disc. This has an SQL client Interface demonstration program on it which may show you how to do it.