DSXchange

Hi All, While trying to run the server jobs, we are getting an error like this "Could not load drsoci.dll". Source database is SQL server and Target DB is Oracle. When the traget database was SQL Server the job was running fine. We are using the plugin stage "DRS" for the source ...

Hi Vindy,

There will be a master sequencer for running all the staging jobs and master sequencer at the each datamart level for running the respective dimensions & Facts.

Thanks,
Akhil

I don't know what's the actual error is......but you can run the job by giving "array size to 1"

Yes, You can do that using any of the programming languages like PERL, C etc. First export the jobs(only Job Designs) you want to change the descriptions. Then write a PERL script which will take this dsx as the input file and whereever you find the keyword "FullDescription"......give your...

IPC provides a communication channel between DataStage processes running simultaneously in the same job. It allows you to design jobs that run on SMP systems with great performance benefits. One can use them to speed up data transfer between two data sources(eg: a source and target).

Why you need a separete link for clearing the hash file. You can check the "Clear file before writing" option in the hash file.

Thanks,
Akhil

Hi All,

Is it possible to run all the jobs available in a Project from the command prompt?

There is one command to run a single job from the command prompt.
"dsjob -run Project Job". Like this any command to run all the jobs in a project.

Thanks,
Akhil

Thanks Chulett. When i included the hash file after the DRS stage its working fine. Thank you very much.

Yes i want to run this complex query. I cannot do any changes with the tables & the logic. Is it possible to do something with the datastage to avoid this kind of errors.

Dynamic Relational Stage(DRS). It can be configured at runtime to read from or write to a number of different supported relational database management systems using native interfaces.

Thanks,
Akhil

I didn't find any "Pre 4.2 User defined Sql" option. My lookup is a DRS stage.

I cannot change the "where" condition. Is there any other way of solving this issue.

Hi All, I am getting an error like this "ORA-01036 Illegal variable name / number". I have a DRS lookup stage in that i am having an user-defined query like this SELECT A.LM_LRNR_OBJV_ID,A.SRC_SYS_ID,C.LM_PROF_MAP FROM PS_LM_LRNR_OBJV A, PS_LM_OBJV_TBL B, PS_LM_RVW_RTNG_MAP C WHERE A.LM_RE...

Thanks Sreeni, One of the numeric field was getting some carriage return charater or space. The problem was with the source sequential file data.

I am getting an error like ORA-01722: invalid number. I am writing to an ORACLE table. My source is a sequential file.

I checked all the columns and verified that numeric columns are getting only numeric values.

Any suggestions

While running jobs which contains DRS stage , the error which pops up is Client Library property required for stage ( DRS) and the job aborts.
DO any one have a idea why this error pops up??