DSXchange

May I know what is the syntax of this.
Is it InputField[Delimiter,Start, End]?

Thanks for you inputs guys. I was extracting from Database, so manage to use database functions.

Hi, Input Data ABC_xxx ABC1_xxx ABC2_xxx yyy_ABC3_xxxx I need to strip out all those characters to the left of _ that were before xxxx. xxxx is just representation of string. So I need to strip out any char '...ABCn_' n may or may not presetn. Some characters before ABC may or may not present. An po...

Hi, Iam getting the following error, "JOB.1872385446.DT.1361242948.TRANS2": Line 158, Nonnumeric data when numeric required. Zero used." I need to check the line 158, to know which logic cause this exception. So I guess, I should look into RT_BPnnn for this line number. May I know how...

Hi, Version 7.0. There is no option in JobProperty to handle the aborted job. So if any of the Child JobSequence aborts, the main Job sequence does not getting aborted. No Termitator stage as well. May I know, how to abort the mail sequence. Right now Iam using a separate routine to abort by extendi...

mentioned ellipsis mentioned is not available in Trigger Expression. Iam using version 7.0, is that a reason?

This this helps.
One short question. How to get the Job name automatically (or by any click event). I copied the name of the JobActivity or typed the name of the JobActivity name manually in JobA.$JobStatus.

Hi, I have three job activity connected to a Sequencer and another jobactivity following that. I need to make the sequence to wait for all the jobs to finish either OK or with Warnings. Then I need to trigger the next job. I can give All as condition. What should I give in Trigger condition in 3 job...

Congratz Kumar!!!!
Reached 3000 post. Good Job.

Kindly let me know the Port no used by Datastage. I could not get the correct search context to pick up the correct one?

Thanks Craig.

This post is in reference to the other post that was wrongly created in TX forum. My support team able install the OCI9i stage into an existing project by executing some executables available under DSEngine and passing some required project paths as parameter. I could not contact Support team, So Ma...

May I know the syntax for fnuxi to export and import?

So the recomended option is to Install datastage, and export the whole Universe using fnuxi and import into new server. Will this be only one import/export across all project?

We can install a new copy and import export all the projects.
But I just want to know, If the migration includes, both Project installatins and the Project directorys as it is to the same directory, will it work. Which will reduce the migration time.