DSXchange

I am trying to write an update job that reads from one table (odbc) and updates another table (odbc). I am linking the keys and column that must be updated (in the transformer stage), and it seems to work ok, accept that I get a warning message for every input record that does not link to a matching...

Wondering if anyone can help. I have two basic files which in structure are identical. They only differ by the data they hold. One holds English names and addresses and the other holds French name and addresses containing the usual french accents and special characters. When I run the English file, ...

Hi Direk, Ive worked on environment like yours and I was ran into your same problem. Seems that this is a know problem on DEC where the internal universe licenses are not handled correctly (each active stage will use up a Universe license...). To correct this, the support inform me, that a workaroun...

Hello. When we install DataStage 4.0.3, we cannot use -v option. Is not the option -v available at DataStage 3.x? I wrong? Jang, Jung-Hee. -----Original Message----- From: Ray Wurlod [mailto:ray.wurlod@Informix.Com] Sent: Monday, October 29, 2001 11:11 AM To: datastage-users@oliver.com Subject: RE: ...

Try using the -v option ("verbose") on the install script. You will get more information about why it is waiting for so long. -----Original Message----- From: Jang,JungHee [mailto:jhjang@lexken.co.kr] Sent: Monday, 29 October 2001 12:26 To: datastage-users@oliver.com Subject: DataStage Install ... >...

> Hello, > I tried to install DataStage 4.0.3 at SUN SOLARIS 7. > But I didnt install DataStage 4.0.3. > > I have the process "/bin/sh ./gci.install". > Its child process is "bin/UVwrite VOC CATALOG .GCI verb - Catalog - a > GCI Subroutine CATALOG I B GCI". The child process didnt have any > respons...

The rejected rows link does NOT have a constraint expression. -----Original Message----- From: Li, Xiong (Corporate Manukau) [mailto:Xiong.Li@chh.co.nz] Sent: Monday, 29 October 2001 11:19 To: datastage-users@oliver.com Subject: RE: rejected_code isuue... Hi, Ray I did set Rejected Row = YES for rej...

REJECTEDCODE is any error back from the database on the end of the link. Since you were able to write the rows into the sequential file, the error code back from the "database" (operating system) is 0. You want the REJECTED link variable, not REJECTEDCODE. Read the help on link variables, which expl...

Hi, Ray I did set Rejected Row = YES for reject link in the constraints table, as well set its constraint = staging_insert.REJECTED. Since rows were rejected according to the constraints, why is the REJECTEDCODE = 0? In addition, because of the cause, no rejected information were recorded. Xiong > -...

You only get a warning if you use the rejected=YES in the constraints table. You do not get it if the rejected link has its own constraint expression. You could follow up in code by testing the value of the links row count (use the DSGetLinkInfo() function) and handling the case where this is non-ze...

Hi, all I have a very simple job for making a staging table in Universe. I defined constraint for staging table, so that rows coming through dont match the constrain would be rejected. the rejected link constrain is "staing_insert.rejected". This job works fine, two rows rejected, but no warning mes...

Nowell, I am definitely not an authority, but I would expect the hash files would be somewhat slower. First of all, the hash file is keyed (obviously) and having to write that key will take some processing time. This would not affect your job, but would cause the previous job (ie. the one that popul...

I have a datastage architecture question: Is there any benefit to using a hash file as a DRIVER in a job design? For example: Scenario 1: You have a sequential file driver with 6 million rows. This sequential file goes into a transform stage, and joins to 3 smaller hash files. Scenario 2: Instead of...

Im experiencing the same problem over here, and I also do what Doris suggested - "select... clear job status for that particular job and then recompile it" This morning I ran a job that seemed to get stuck. I reset the job and ran it again, and it ran without any problems the 2nd time - strange. We ...

Have you tried looking in the work files in &PH& to see if there are any further clues or error messages? -----Original Message----- From: Direk Phaisitwanitkul [mailto:DirekP@dtac.co.th] Sent: Friday, 26 October 2001 1:03 PM To: datastage-users@oliver.com Subject: Job abort afer system was rebooted...