Dynamic prepared Sql using routines

Ush · Post by **Ush** » Tue Dec 11, 2007 9:36 am

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

ArndW · Post by **ArndW** » Tue Dec 11, 2007 9:45 am

Posting the same question more than once won't get you any additional or bette ranswers. In fact, chances are that you've lowered your chances.

rodre · Post by **rodre** » Tue Dec 11, 2007 12:21 pm

Do a search using SQLExecDirect or SQLAllocStmt or SQLNumResultCols. It can be done but it is pretty extensive code I found out.

ray.wurlod · Post by **ray.wurlod** » Wed Dec 12, 2007 1:31 am

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.

CharlesNagy · Post by **CharlesNagy** » Thu Dec 13, 2007 7:32 am

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.

DSXchange

Dynamic prepared Sql using routines

Dynamic prepared Sql using routines

SQL Client Interface Guide