DSXchange

Could the host of forum move this post into DataStage PX forum?

Thanks,

Thank you, Craig.

My current approach is to select the results from a DB table and write the results into a file. Then using a function to get the value from the file just saved. Finally pass the parameters into down stream jobs.

Hope this is clear to you.

Thanks for your feedback.

My question is how to assign a values to the parameter which will be used to passed to down stream jobs.


The value is dynamic selected from DB table.
The way I am current used is not good enough, my opinion at least.
So I am looking for the best one.

Thanks

At my job design, I have to assign parameter a values. This value will be passed to the down stream jobs.

What is the best way to do so?

Thanks in advance.

That is great. Thank you a lot.

Hi

I have a similar situation and I woulk like to use loop in Transformer Stage.
Could you send me the details of step of your job?

Thanks,

Hi, I had an error occurring when I load to target tables. The job started to run but with more than 3 minutes no data loaded into table. When actually the data coming in, DB2 connect closed and the job failed. Anyone knows how to fix this issue? Should I change any DB2 connector setting? Or DB2 Dat...

Hi, More info as below: DS Version: 8.5 (EE) Source Stage: Dataset Stage View Source data: Yes. Numbers of Culumns for Look up file: 3 3 columns are used as a key for refference link. Errors: Could not find input field "ID1". Could not find input field "ID2". Could not find input...

Hi All, I have a lookup Stage error like: Could not find input field: ID ID is field of the look up file witch is generated before using it. The PX job run fine before and not able to run now. The only thing I have done to this look up file is modified the column data type and the length at previous...

Hi All,

I am currently install DS Parallel 8.5 client tool on a 64 bit operating sysem, window 7.

Is this any problem for this?

Anyone use 64 bit operating system for DS client tool?

Just wanted make sure before install it.

Thanks in advance.

Hi All,

I have solved this issue by install the patch listing below.

Resolving the problem
Connect IBM InfoSphere Information Server Support to get Repair tool patch_JR38573_client_windows_8500.zip to fix the issue.

Thanks Ray for your replay.

Hi all,

When I opened ODBC Connector, it comes an error:

StageType object(s) could not found for connection type ODBC Connector

Could any of you give me a hand for this error?

Thanks in advance.

Hi all, Thanks all for your inputs. I have installed the CDC components combining with Datastage 8.5. The CDC Plugin Stage has come with Fix Pack 1 or Patch 1 for installation, which does not come with normal installation of IS 8.5. I may have to use the CDC plugin Stage, or middle tables CDC replic...

Thank you for your input, Vince.

The componnents of CDC installed are:

InfoSphere CDC Management Console and InfoSphere CDC Access Server

But I still do not know how CDC could connect to Datastage.

Could you tell me more details about DS<--->CDC?

Appreciate for your help.

It looks that I will use Infosphere CDC and CDD to handle all delta changes and put those into the target. Anyone has experience using CDC and CDD components with Datastage? Give me some suggestions on how to do so if you have done so. I even do not have any manual for those. Not much on the interne...