DSXchange

Datastage is on Unix server for us. If I put the DSHOME from UNIX, batch script is not recognizing the directory(obviously it shouldn't).

I didn't find a place under C:/IBM folder which can have "dssh" utility.

or may be I am totally missing something.
Thanks
nsm.

Datastage is on Unix server for us. If I put the DSHOME from UNIX, batch script is not recognizing the directory(obviously it shouldn't).

I didn't find a place under C:/IBM folder which can have "dssh" utility.

or may be I am totally missing something.
Thanks
nsm.

Hi, I used below command to get me list of jobs in a particular category in Datastage. SELECT NAME FMT'80L' FROM DS_JOBS WHERE CATEGORY LIKE '\Jobs\KeyGenJobs' What do I do to run it from Windows batch? Once I get it I want to loop through that file and run the command for dsexport so I will have th...

Hi All,

I am using 3 surrogate key generator stages with in a job and job just hangs. I tried running the job using any 2 stages it works fine.

Any limit on the number of Surrogate Key generator stages used in a job?

nsm.

Ray,

I just wanted to say I am stll looking for inputs for the people who check in futuire.
I didn't mean to hurry any one.

nsm.

did any one face this issue before?
any suggestions?

All, I created a state file and used it in some jobs. Now to re run some of jobs I wanted to reset the value in the state file to a value I want. Below is the job design: Seq File--->Transformer stage--->Surrogate Key Gen stage with Update Action. Job ran fine but When I run DS jobs using the State ...

All, Below is the error I am getting and all the rows are getting rejected. tCopy: When checking operator: When binding input interface field "field1" to field "Tgt_field": Implicit conversion from source type "uint32" to result type "int32": Possible range li...

can anybody help on how to get started with the script?

oo ok..I got it now.
FTP doesn't work as all the FTP Ports are blocked on my machine..

nsm.

Kandyshandy,

Please read my question properly.

nsm.

Hi , My job is like Src sage-->Transformer Stage-->Target Stage-->Rejects Src and Target are databases. One of the columns is not nullable and it has nulls coming in, I was hoping it goes in to Rejects but Transformer stage is dropping them making the job fail. Is there a way to capture those in Rej...

simply use:- sort -n -u test|wc -l
and do result-1 as your file ist line is column names.

yes..Using PSFTP I can put the file on to Datastage server.

Chulett,

ftp://servername has to be part of URI path in version8.

I tried reading the file from path which has no spaces , didn't work.
Not sure what's happening.

Thanks
nsm.