DSXchange

I assume a ".so" file would be needed to read an excel in UNIX.


Regards
Sreeni

I faced this issue once. What i did was that i assigned the logic to the particular column instead of putting it as a stage vairable/constraint. It worked...

U can use the REPLACE function of Datastage to do this.

All the DX servers i have worked are in UNIX(where BAT would not work). I am surprised to see a windows server.

Regards
Sreeni

Generally writing BASIC commands is an iterative process.
Whatever u require...u can search from the BASIC.PDF and use it.


Regards
Sreenivasulu

You can control the order of input links
as well as the order of output links.


Regards
Sreeniv

HI All, We are Measuring performance using the following ways 1. Suppose the target is a database. Convert the database stage to a sequential file and see whther it takes the same time. This would give us a knowhow whter the database connection to the target (generally remote connections) is slow or...

Sorry Peter !!!

There is no setting for warnings in Administrator.

I got confused with the purging of job log.

Regards
Sreenivasulu

I just found that the header of my message say datastage7.

The issue is in datastage 5.2.2

Sorry for this .

Ray, I may not be clear in my question. The before job routine is calling a shell script. The shell script in turn calls a stored procedure. The paths are parameterized and when the shell script does not find the path of the storedprocedure it does not generate the log and the datstage job gets exec...

Use "first" in Aggregrator stage to get the frist duplicate record
or "last" to get the last duplicate record

Regards
Sreenviasulu

Hi Guys,


Is there any option for the Datastage job to Fail if the Before Job-Routine
Fails ?


Regards
Sreenivasulu

The seeting done at the administrator overrided whatever setting done in director.

But once the setting is changed in administrator you need to restart datastage

Regards
Sreenivasulu

You can try 2 options

1. Check whether data loaded is really numeric
Redirect the data to a file instead of a table

2. Check with debug option in datastage

Regards
Sreeni

When the jobs were corrupted. We rebuilt the indexes then it worked fine.

Hope the same could work for hash file corruption