DSXchange

Hi, In my Job Sequence, I have : Job 1 -------> Routine1=====> Sequencer1-------> Job 2 Between Routine1 and Sequencer I have put 2 links.. Link1 is Conditional , with Routine1.ReturnValue = 1 (say i.e non zero) and hence It should run Job2 else not Link2 is Otherwise (Coz I am using Automatically H...

kumar_s wrote:If you find your topic is resolved, pls close it. ...

Hey a little more info plz...
where do I find all the commands which can be used from COMMAND option in Administrator and also a manual for those commands....

Regards,
Asit

kumar_s wrote:Well search will give you full details.
From the Command option available in Adminstrator use

Code: Select all

DS.REINDEX ALL

...

Thanks

Protected and Readonly are different parameters. If you have promoted your jobs form Version control as Readonly mode you might get this effect. You can reimport with Non readonly mode. Alternativly you can execute the follwing command in the Command option available in Datastage administrator UPDA...

asorrell wrote:See if you can re-index the VERSION project as well. It may have a corrupted index.

Can u plz suggest how to re-index a project?

Thx,
Asit

Hi,

My project is not read-only (i.e it is unprotected)
and still a job is read-only.

Plz explain how to remove this read-only option.

Thx,
Asit

Hi,

I am using Datastage Version Control.
While Promoting my jobs to another project,
am getting the error message. No Record To Read. Error: 0

Plz explain why this cud be coming??

Regards,
Asit

Hi,

I am new to Datastage Version Control.
Plz advice as to where I may post the queries regarding the same.

Regards,
Asit

Use Float as the data type, instead of decimal.

Go to sequence job properties, under the General tab, check the box that says 'Log Warnings after activities that finish with status other than OK'. This way if any child job finishes with status 2, t ... What is combinational effect of check / Uncheck of the four options on the genral page, viz: 1...

Hi, SEQ_JBS_V02..JobControl (@Coordinator): Summary of sequence run 12:39:41: Sequence started (checkpointing on) 12:39:41: SEQ_SH_V02 (JOB SEQ_SH_V02) started 12:40:07: SEQ_SH_V02 (JOB SEQ_SH_V02) finished, status=1 [Finished OK] 12:40:07: SEQ_SL_V02 (JOB SEQ_SL_V02) started 12:40:47: SEQ_SL_V02 (J...

Hi All,

Is there any identifier (numeric type) which is generated uniquely for each run of the Job?
That is if I run the Job 3 times, one after the other, that Id should be unique for each run.

Thx

Thx a lot...

Ok...
Custom SQL worked, so I was just wondering whether I can parameterize table names from 'SQL Builder' or not....

One More thing, when I click on Help, the Help opens in some language other than English. So u get help in English (am asking only for SQL Builder Help)...

Thx anyways

Hi, I am using 'SQL Builder' from DB2/UDB API stage. But the problem is that I want to change the fully qualified name of the table, to include a Job Parameter. Eg. As of now I am getting SAMPLE.TESTTABLE and I want #$DB_OWNER#TESTTABLE From the 'SQL Builder' editor, I am unable to change the Table ...