DSXchange

Indexes on the repository table might be off. Thats one of the reasons you dont see routines and jobs in the repository. Search the forum for "REINDEX.ALL". Also learn when to run this command and what are the pre-requisites. Make sure you have the project backup. Search and learn.

Did you even save the routine. Create another routine with the name test. See if it allows you to do that, if it doesnt, then that means it exists and you just cant see it (indexing issue). Try creating one with different names and see if you can see any of them.

Try refreshing it. Also, is this happening only with this particular routine, or you cannot see any routines?

Inside the job, make sure you the column that your running this routine on, is defined as varchar and you trim the column before passing it in.

I dont think orchbutil needs those extra priveliges. Its just the Enterprise stage. You can import with just access to that schema.

Do you get any error messages in the log? Did you test the routine via the test button while creating it?

Range lookups are not present even in server jobs. What you are referring to is doing range lookup against a database table. That is possible anywhere you can run a sql query. Hence it is possible in px as well. As noted, in 8.0, there is a seperate stage to do that, even when the data is not in a d...

The OPEN and CLOSE commands are similar to the before/after sql. Read about them in DataStage help.

Welcome Aboard
Do an exact search on "BCIPut call to SQLExecute failed". A lot of such issues have been covered before. Also try resetting the job for additional messages that might help in the diagnosis.

Ray is right, Welcome Aboard Rahul.....
Anyways, we need a spambot proof interview forum, so that we can point fingers and go ha ha ha, in that forum, freely Does my sentence make sense

May be thats the next datastage version to be released in 2020

It would be nice to know what solved your problem. Its one of the things we do here, share solutions.

DRS stage is a Dynamic Relational Stage. You have the option of using the ODBC connection or Sybase native drive inside the stage. And whats wrong with the Sybase API again???

Whatever works in your favourite sql tool, will work in odbc.

At the unix level (command line) you can use dsjob -report to get the job status as well.