Server Routine - Custom Build

Raftsman · Post by **Raftsman** » Mon Jun 06, 2005 1:41 pm

Is it possible to code the SELECT statement in the code routine? The help documentation is very limited in this area.

Thanks

kcbland · Post by **kcbland** » Mon Jun 06, 2005 2:21 pm

What are you talking about?

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Mon Jun 06, 2005 2:32 pm

You neede BCI routines.

Or you can perform shell calls.

But why do you need to perform a 'SELECT' from a routine?

ArndW · Post by **ArndW** » Tue Jun 07, 2005 12:37 am

Do you mean a "SELECT" to a remoted database (ODBC, or direct DB connect) or to a Hash file?

Since routines tend to get called often, quite frequently once per row of data, doing any type of a SELECT will be extremely slow - considering the enormous overhead involved in connecting and opening up a DB connection.

WoMaWil · Post by **WoMaWil** » Tue Jun 07, 2005 2:20 am

And since DataStage Version 5.x the ODBC coming with DataStage cannot be called by a routine any more. You need to have an own ODBC driver.