DSXchange

Have you tried creating a Transform ? That is reusable too.

#1 You have to first generate the .sk file with initial value - you can do this with row generator ----> surrogate key generator stage row generator:- 1 row column- seq data type- integer initial vlue=0 Surrogate key stage:- input column name- seq action- Create and Update Source name- /<full path>...

row generator 2 | | | | | V row generator 1 ------> transformer 1 --------> join --------> transformer 2 ----------> peek row generator join..

Try this.... . row generator 2 . | . | . | . | . V row generator 1 ------> transformer 1 --------> join --------> transformer 2 ----------> peek row generator 1: one row with one column name "text", varchar datatype, value: "1 sam,alex,george,danny,mark" transformer 1: 3 columns ...

What is the content of your default.apt default configuration file?
Try using the same fastname as given in default.apt file.

In Properties tab, define your properties with Coversion as "Value Only"

Thanks Craig.

I established from your first reply itself that it's not possible to attach the same job. I was just trying any slightest hope to get it work as that will save lot of extra work for me.

Anyways, I'll go with Job Control or Sequencer Job.

Thanks once again.

Thanks Craig and ArndW. ArndW, My jobname is "Test1" and I have added following code to my routine. IF DSGetJobInfo(DSJ.ME,DS.JOBNAME)= 'MyJobName' THEN JobHandle = DSJ.ME ELSE JobHandle = DSAttachJob('Test1',DSJ.ERRNONE) It still gets stuck for 1800 seconds before aborting. Is there somet...

Hi, Requirement: Before job subroutine (BASIC) to provide value (come from a shell script) to the Job Parameter of the same Job. Job Parameter <-- Before Job Subroutine <-- Shell script Solution so far: I can call the shell script and get its output value in a variable. Call DSExecute("Unix&quo...

Does the datastage user have permission to access the library directories ? Yes, dsadm user belongs to dstage group for datastage and oinstall group for oracle access. I did not use dba group because oracle client was installed using oinstall group and hence the oracle libraries are owned by oracle...

As I mentioned earlier, it didn't work.

Thanks for your quick reply though.

DataStage 8.1 Redhat Linux 5 Oracle 10g Client dsenv content: ORACLE_HOME=/home/oracle/oracle/product/10.2.0/db_1; export ORACLE_HOME LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$APT_ORCHHOME/lib; export LD_LIBRARY_PATH LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib32:$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib...

If you are refering "the queue" to Websphere MQ and your Datasatge job gets triggered by the MQ message on the stack, I suggest you design your Datastage job as multi-instance.
Note:Assumption is that there is no dependency between messages on MQ

Hari, even if you have correct version of C++ compiler your parallel jobs won't run on Datastage 7.5.2 version. As rightly said by ArndW, the datastage version that works on windows in 7.x series is 7.5x2. You need to get the right installable along with the right compiler to get it working.

Why you need root priviledge to find and see a file? Locating a file through a FIND command is easier with ROOT login as it does not give you error on Directories that you don't have access to, while searching the file with your user login. Comment was more specific on searching and locating the fi...