DSXchange

Scenario: Job 'A' is within job 'B'. If we assign some value to a variable or parameter in job 'A',are there any ways of passing this value to outer job 'B' i.e can we refer this variable or parameter in the outer job 'B'.This parameter is environment variable and we want to change its value in inne...

Are there any ways of passing parameters or values across server jobs in datastage.
Scenario:Job 'A' would execute and based on the result of the Job we want either Job 'B' or Job 'C' to execute. Hence the result of Job 'A' would determine the sequence of operation.Job 'A' may be within job 'B'.

The two are independant of each other and do not need to be used as a pair. ... Actually i have a job that has a source as DRS stage with source query as union between two tables.This this stg writes to a table and then to a hash file.The source query takes longer for execution and hence the job.Ar...

Do we have to use link collector and link partitioner in pair or single works fine i.e to use link collector do we need to use link partitioner as well?

Can link collector be used to perform union between two queries used in ODBC stage?

While running a server job it failed with following error:

DSD.UVOpen "PS_JWS_F5800090" is already in your VOC file as a file definition record.
File name =
File not created.

Rerunning the joob resolved the issue but what is VOC file in datastage or what is VOC?

While running a server job it failed with following error:

DSD.UVOpen "PS_JWS_F5800090" is already in your VOC file as a file definition record.
File name =
File not created.

Rerunning the joob resolved the issue but what is VOC file in datastage or what is VOC?

I m getting an error ORA-24334: no descriptor for this position while executing a query.When that query is run through SQL it runs fine but while used as source query in ODBC stage gives the above mentioned error. The error code says : The application is trying to get a descriptor from a handle for ...

Had this worked before and then stopped? Or does it immediately fail? Trying to determine if this is somehow data related or if your reference lookup is not setup correctly. It would help if you detailed your lookup - post the sql, detail how many columns are defined in the stage, their order, key ...

Please give a bit more information, as just the SQL error message doesn't help much. Does the error only occur in one job, or on one particular key? Does ODBC read for that table work (i.e. as a source, not a lookup)? The error is occuring in a job while accessing data from DRS stage and lookup fro...

I am getting following error while runninng job:
DSD.BCIGetByKey call to SQLExecute failed.
This failure is while accessing ODBC driver stage which is used for look up.Please advice why this error and how to remove it.

chulett wrote:An Oracle version change? No, it really shouldn't. Will you be 'upgrading' the Oracle client on the DataStage server to match as well?

To add to my previous reply :
Will this affect for upgrading from 9.2.0.5 to 9.2.0.7 and from 10.2.0.3 to 10.2.0.4 to be specific

An Oracle version change? No, it really shouldn't. Will you be 'upgrading' the Oracle client on the DataStage server to match as well? Actually i want to either upgarde/degrade the oracle version on same release. Eg:upgrade oracle version from 10.2.0.3 to 10.2.0.4 or degrade oracle version from 9.2...

If we want to upgrade/degarde database configeration to/from 9.2.0.7
does this change in database configeration affect DRS/ODBC stage in server jobs?