DSXchange

paranoid

Could you please tell me how to check repository index are intact and upto date.
I'm using server edition.

Thanks
Laxman

paranoid

ray.wurlod wrote:Something - perhaps invalid indexes - is preventing a SELECT from completing successfully. Check that your repository indexes are intact and up to date.

paranoid

Hi, I'm using datastage server edition 7.5.1. When i click on datastage components under export in datastage manager i get this below error: Error calling subroutine: *Datastage*DSR_SELECT (Action=7);Check Datastage is set up correctly in project dsprod (Subroutine failed to complete successfully (3...

paranoid

anbu wrote:Yes you can do if you have the filename as a job parameter. Then in transformer
Code: Select all
If FILE_NAME='XXX' Then 'String1' Else 'String2'
Here FILE_NAME is a job parameter

paranoid

Hi,

Based on input filenames can we change the value for a column in the transformer stage in datastage server jobs.

Thanks
Laxman

paranoid

Thanks Chulett. It worked.

Belated New year Wishes

paranoid

I created one more look up for not equal to condition and got the desired output. Is there any other way of doing this?

Thanks

Sue

paranoid

Chulett,

Since i am using 7.5.1. version, i don't have lookup stage. I have to use a OCI stage for referencing it to the source table.

Thanks

Sue

paranoid

Hi,

I am trying to create a job where it checks a value against a lookup table,
if the value matches then the job outputs 1 to a data file or else it outputs 0.

But my job is always running fine for equal to condition and it is not working for not equal to condition.

Please advise.

Thanks

Sue

paranoid

That's a good information as well. Thank you for the heads up on hashed files.

Sue

paranoid

Nikhil,

That was really a nice info. Thank you very much.
Hope i did not miss any other things.

Sue

paranoid

Hi, We are planning to migrate all the datastage jobs and databases from the Solaris server to the new AIX server. I am the thinking of the following points to be considered for the successful migration of the DS jobs: 1. Import all the jobs into a .dsx file and export that to new server. 2. Migrate...

paranoid

Chulett,

Even i am doing the same checking...only if the return status of the job is not equal to 1, i am performing job reset.

Thanks

Sue

paranoid

Chulett..You are great...that was the command i disabled..

thanks again..I will be changing the version to UNIX to avoid confusion...

Sue

paranoid

Chulett,

Please ignore this. We are using one more command that resets the job when a warning message pops up. Now i disabled that command and it is working fine..

Sorry for the confusion..

Thanks

Sue

DSXchange

Search found 184 matches

Could you please tell me how to check repository indexes

Unable to export a job getting error 30107 error

Thank you

Based on filename can we change the value for column

Look Up for Not equal to Condition

Migration of DS from one server to another