DSXchange

I'd like to develop a script that gets all the OCI stages of a project and provides the table name, mode (inert/update etc) for input/output stages.

Is it possible to write a query on DS_JOBOBJECTS to do this?

will appreciate any help.

Thanks
Rati

Thank to all of you guys. I truly appreciate your help.

Thanks
Rati

Is there a command to list the current settingg of config parameters i.e T30FILES etc etc which are typically defined in .uvconfig file.

I am not sure whether my changes in the .uvconfig file were applied or not. Hence the reason for asking.

Thanks
Rati

I mostly use Batch wrapper for job sequencing. Given a batch name, is there a way to know the list of jobs that got executed from the batch. Like some system table or some system call. Note: I'd not like to scan the source for DSRunJob etc. Nor I'd like to convert to a JobSequencer. Will appreciate ...

Hi, I use the next sentence in my job : ALTER ROLLBACK SEGMENT RBS31 STORAGE ( OPTIMAL 4000M); SET TRANSACTION USE ROLLBACK SEGMENT RBS31; This will set in the tab SQL sub tab Before and work without problems. Now, after the job you must to restore the old rollback settings. I hope this help. Looks...

Maybe you can look into the following command: set transaction use rollback segment but it has its contraints and limitations. Thanks to all of you for your suggestions. The before/sql soes not handle the pl/sql driectives. I've tried it before. It works only well for simple SQL statements like del...

Is it possible to set a specifc rollback segment for a OCI stage?If not possible at the stage level, is there any other way to set the rollback segement for the Oracle transactions?

Thanks
Rati

ray.wurlod wrote:At the TCL prompt, type HELP BCI.

You can download the BASIC SQL Client Interface manual from IBM.

You have been of great help Ray. Thanks a lot.

The "lib" routines are those in the DataStage BASIC SQL Client Interface (BCI). They mimic programming using the ODBC API. Search the Forum for BCI. To use these requires that you have a licensed ODBC driver for connecting to your Oracle (or other) database. The drivers shipped with DataS...

tonystark622 wrote:Why don't you just do it in a DataStage job?

Tony

I can. But it is messy. Like use OCI/ODBC to get the thing into a file. Then read the file to get the values into varaiables. Would like to do it directly in the batch/subroutine so the code would be lot cleaner/reusuable.

How would you access oracle DB from a DS subroutine/batch . I need to log onto oracle and execute a select statement and get the records using a loop, then write out the records to a sequential file. Need to do all this in the Batch job. Note: I dont want to use shell exits. Would like to use some l...