Page 1 of 1
Server Routine - Custom Build
Posted: Mon Jun 06, 2005 1:41 pm
by Raftsman
Is it possible to code the SELECT statement in the code routine? The help documentation is very limited in this area.
Thanks
Posted: Mon Jun 06, 2005 2:21 pm
by kcbland
What are you talking about?
Posted: Mon Jun 06, 2005 2:32 pm
by Sainath.Srinivasan
You neede BCI routines.
Or you can perform shell calls.
But why do you need to perform a 'SELECT' from a routine?
Posted: Tue Jun 07, 2005 12:37 am
by ArndW
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.
Posted: Tue Jun 07, 2005 2:20 am
by WoMaWil
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.