DSXchange

DESIGN suggestion-

You can write a DS job which would poll the source table which is expecting a change. This DS job would be polling at a periodic interval
with the help of a sequencer. Once a change occurs a set of jobs can be run. This way you can simulate a trigger.


Regards
Sreeni

The error message shows that it is a LOGON error and GATEWAY error.

Both are related to network issues.

Try connecting to SAP and ORACLE from outside of Datastage environment in offshore. If you get the same problem then its a network issue not a datastage issue.

Regards
Sreeni

HI Aparna, We had a similar problem of unix box not returning the return code to datastage sequencers. But we could not diagnose whether really the Unix OS was not sending the message or Datastage Sequencers were not able to read it. We made a trick in the unix script. We kept is send return codes a...

HI.

As far my experience goes you cannot access the windows environment variables from Datastage Administrator.

Regards
Sreenivasulu

Hi reddy,

If you have Asential Meta Stage you can use it to get detailed information about the count, records,jobname etc...

Regards
Sreeni

HI akarmarkar,

Its not at all a issue if you have two jobs with the same name in different
projects in a single datastage server.

The message saying that the object already exists could be for some other reason

Regards
Sreeni

Hi,

It is useful if you take the large number as characters and then manipulate it.

Regards
Sreeni

Hi

Space problem in mounts other than the mount where datastage is installed causes problems in the functioning of the tool.

The operating system becomes ustable if any mount has less free space.

Regards
Sreeni

HI, Wonder if this would help. RowRunningTotal which holds the cumulative values of the job. I remember using a datastage provided routine for this purpose. Will get back on this soon. Regards Sreeni Hi All, My requirement is like below I have a input file which is having 10 records in trnaformer ia...

HI.. Please search the forum before posting the question. This has been answered many times before Regards Sreenivasulu guys i need to extract in the input stage, a date field,decimal field,and a longVarchar field.with a where condition as date field = (a prompt of string datatype for system date)

HI, Just a suggestion Using the DB2 enterprise stage would be much faster. Regards Sreeni I am trying to set up ODBC DB2 connection by adding the following to odbc.ini file: [xxerdb] Driver=/appl/Ascential/DataStage/branded_odbc/lib/VMdb220.so Description=DataDirect 5.00 DB2 Wire Protocol Driver Add...

HI, Came back after a long Vacation...... There is a specific audit tool provided by datastage called AUDIT STAGE. It has does 5 levels of checking from Level0 to Level 4. Record count can be found using level1 jobname can be found using the DSJobName function targetname would also most likely have ...

Hi, Regarding question 2 If you are using different references then splitting the job would not help much. I have a job having 9 lookups and 9 transformers in a single job Regards Sreeni Hi, I have a few questions with respect to references in Server jobs. 1. Is there any limit to the number to hash...

HI,

Use the for loop in the shell scripting language.

In a windows BAT file there could be a similar functionality

Regards
Sreeni

Hi,

This could be of help:

One lookup each for satisfying each join condition.
There for suppose if you have 3 sources then you need to do use 2 lookups and 1 source. 2 lookups can be done using one transformer or
2 transformer depending on the logic.

Regards
Sreeni