DSXchange

Hi all, We are running DataStage 4.0 on Solaris. I have a simple test script which runs okay from the command prompt: currCnt=1 while [[ "$currCnt" -le "5" ]] do print "Count equal $currCnt" currCnt=$(( $currCnt + 1 )) done When I execute this script from DataStage job, it abends with a message: Can...

Hello group,
We need to read a DBase 4 database for our source of data with Datastage
(either 4.2 or 6.0)? Any information would be helpful.
Thanks,
Doris

Could it be possible that having a tick for "treat erros as non-fatal" in the DB2 stage doing the damage? when we choose "insert or update" action, this tick has been set to ignore any insertion failures! Mani "Craig Hulett" cc: Subject: Re: Insert new rows or update existing rows - Guess a Bug 04-F...

Unfortunately, all that "Validated OK" really means (as best as I can tell) is that the SQL statements are syntactically correct. It apparently doesnt attempt to actually verify that (for example) columns names actually exist, steps like this wait until your first job run, which is unfortunate. Now ...

>From your message I understand that your client wants advice on the merits and otherwise of running two projects at the same time. One project is to standardise data (in operational, legacy and data warehouse environments). The other project is an enterprise-wide data warehouse, so I assume that th...

Unless there is a bug, "Validated OK" means that DataStage was able to establish a connection to the database and believes that the SQL statement was properly prepared by the database server. That is, the result received by DataStage executing SQLPrepare() (or its equivalent) was "success". Can you ...

Hi Guru Today, I meet more stratigical problem then DataStage Job Implementation and I am not a expert in this point. So I need help about this problem. My latent client consder 2 project. One is Data Stadardzation Project Including Legacy and DW (They already have previouse implented DW). Another i...

This is a topic for an orphaned message.

This is a topic for an orphaned message.

Yes. (a) In Generated Sql i have Insert and Update statements with wrong tablename only. (b) After changing the tablename i recompiled the job. Since we are using DataStage 5.2 on unix, i am able to see no of rows processed by the output link (which interact with DB2 Stage) and apart from that, i am...

Did you (a) check the generated SQL and (b) re-compile the job after changing the table name? When you claim that "the job went through this time also" how many rows were processed by the output link to the DB2 stage (theres an "active stage finishing" message in the log with this information, or yo...

Hi All, I am encoutering following problem when using DB2 stage. In DB2 stages updata Action property, i have set "Insert new row or update existing rows". The job went through without any problem. After this, i changed table name property to some wrong table name intentionally and ran the job once ...

A recent project on which I worked uses Version Control in conjunction with a DataStage job that identifies which objects in the DEV project have been modified since a given date (timestamp), so that these can be promoted into the TEST project. Theres still no check-out, check-in in the DEV project,...

Shawn That has worked in older versions. I have not used this code since version 4. You need to try it first. You should be able to shell a check in or out to Harvest or whatever source code tool you are using. Some people use editors on dsx like notepad. Some of these editors truncate lines over 25...

Thanks. So the only thing that you need to do to put them back together is add the header? -----Original Message----- From: Kim Duke [mailto:Kim_G_Duke@Yahoo.com] Sent: Monday, February 03, 2003 1:46 PM To: datastage-users@oliver.com Subject: RE: Version Control Options in DataStage Shawn Here is a ...