DSXchange

hai , my job design is, reading from file using seq.stage - a trans. stage and db2api stage. while running the job it's giving error main_Program:Fatal Error:Shared library(dsdb2.so)failed to load :errno=(2),system message=(no such file or directory) this first job ,we are running after installation

hai

i have a parameter file. i want to pass values in parameter file to Job sequence paramters


eg:


file.txt
--------------------------
username:abc
password:xxx
----------------------------

i want to pass this username and password to job sequence parameters.

hai

i have a parameter file. i want to pass values in parameter file to Job sequence paramters


eg:


file.txt
--------------------------
username:abc
password:xxx
----------------------------

i want to pass this username and password to job sequence parameters.

you can get Parallelism not Partition Parallelism

We didn't Install SAS package at the time of PX Installation.It's possible to install SAS Package Alone.

Hai stefanfrost1 , Thank you for your Reply. We are going to use Only db2 Api Stage. I would also like to inform you that we are having ds 7.5.1a and db2 v9.1 and if we create a job in this environment will this job can be implemented on Ds 7.5.2 with DB2 v8.2. Will there be any discrepancy... We ne...

Hai,

I would Like to know In datastage 7.5.1.A ,whether we can access Db2 UDB 9 Database Table.

My job design is Reading records through db2 api Stage and writing it into a Dataset. while running Job i am getting below error; DB2_UDB_API_14,0: Fatal Error: Fatal: [IBM][CLI Driver] CLI0131E Invalid string or buffer length. SQLSTATE=HY090 SQLTables: Error retrieving system catalog information fo...

check your Scratch disk File type spaces .if your scratch disk free space is less than 20 % of total Space, you will get this error. Make it free ,the job will run..

Hai,

Use below mentioned format ;

destField[:dataType] = handle_null (sourceField,value).

Reprt_Date :string = handule_null (Reprt_Date,"Null")

Modify Stage Has Seperate Orchestrate Functions.we can't use Transformations Stage functions in the modify stage.

Hai,

Use this format

destField[:dataType] = handle_null (sourceField,value).

Reprt_Date :string = handule_null (Reprt_Date,"Null")

Modify Stage Has Seperate Orchestrate Functions.we can;tTransformations Stage functions in modify stage.

there is no such option here

Check The Target has Any Lock.If it so, Remove the locks and run the job.

our job design is reading from table and writing into a hash file.While Last time run in the production job got aborted.i rerun the job ,it ran successfully. could you guide me, what exact problem? XFMSCIApprSecPrevhash.SCI_D_UK_S_EXCRG_LC_20521.LE_APPR_SEC_ID_HSH.To_SNPST_APPR_SEC_SEQ: ds_uvput() -...