DSXchange

Hi there, Since Datastage 6.0, the GUI version sequencer job is created to control ETL job run. The question here is: is there any benefit to use Unix shell scripts to control the job run, rather than the job sequencer. Especially, from 7.5, Datastage was added more stages to control the job run. To...

Thanks, it works.

Does @INROWNUM or @OUTROWNUM work in parallel jobs? Because if more than one processes read or write concurrently from the same source or target, is @INROWNUM or @OUTROWNUM count all processes or just the process iteslf. Thanks, [quote="ArndW"]Rachel, try writing a job that reads a sequent...

Thanks, it works.

Director job logs can only be browsed for the first page, even there are hundreds of thousand items in it. It would be nice all items can be browsed, not just the first page.

If User defined Environment variables can be exported and then imported into another project, that would make parameter management much easier, especially there is one more cloumn "Help Text", and define more data type, like them in Job parameter in Designer. See http://www.dsxchange.com/v...

Hi there, Job parameters can be defined in Datastage Administrator with Project Properties\Environment Variables and used as job parameters in Datastage Designer. My problem is when these parameters are defined in a Datastage project, can they exported and imported into another project? Such as from...

No matter it has ';' at the end or not, and the sql is perfect from any other clients or environments, the error is the same from routine. Sometime this illegel, another run another illegal.

Certainly, you can say more with checkpoint: What does it mean? How does it work? ... And, most importantly, show you couple of examples how to use the checkpoint in a project.

Ray, Oh, Very good documented routine, indeed, thanks very much. But when I invoke the routine, the error is: t..Trans (bciExecuteDML): SQL Statement = select count(*) from EDWAPP.T_PARTY_ADDRESS; t..Trans (bciExecuteDML): SQL Error: SQL State = 37000, DBMS code = -104 [DataStage][SQL Client][ODBC][...

Hi there, What can I do with Datastage checkpoints? Is it just check the "check box" beside of "Add checkpoints so sequence is restartable on failure" within the job properties of a sequnce job? And its function is only when it fails, you can rerun it from the failed point. Is th...

Any one does BCI ODBC programming there?

Thanks,

The data you suggested is one of the two in my solution. Another one is read from database. Then compare them to see if they are equal. I had a case, they were different. That cased big problem.

Thanks,

We own other your own ODBC drivers. The reason for BCI ODBC is to build the auto-balancing table. You get the number of records from Datastage and Database, then check these two to see if they are the same. Once we ran across case these two were different in production. If you use BCI ODBC, one simp...

Hi every body, A ODBC data source is set up and an entry is added into uvodbc.config. How to write the code to access the database with BASIC SQL Client Interface? Can some one there provide a sample code? The code does: 1. Set up a connect to a database, 2. query a table (select ... from ...) 3. re...