DSXchange

Or youre on vacation. "Ray Wurlod" 11/19/2002 02:08 PM Please respond to datastage-users To: datastage-users@oliver.com cc: Subject: RE: records count Yep, that would work. Theres usually about five ways to accomplish anything in DataStage - if you cant find three youre not thinking hard enough! ---...

Yep, that would work. Theres usually about five ways to accomplish anything in DataStage - if you cant find three youre not thinking hard enough! ----- Original Message ----- From: YN Date: Tue, 19 Nov 2002 07:24:18 -0800 (PST) To: datastage-users@oliver.com Subject: RE: records count > Just an anot...

Just an another suggestion.... how about putting the @OUTROWNUM to the hash file stage with a constant key, say the table name. Then read that hash file and write it to the oracle table... and if you have to do this for multiple tables too then again just one hash file would suffice... YN --- Ray Wu...

This is a topic for an orphaned message.

I think it is workable but what should we do about the record type...there are various record type, I think eight to be exact. Thanks -----Original Message----- From: Rea, Alejandro [mailto:alejandro.rea@experian.com] Sent: Monday, November 18, 2002 7:26 PM To: datastage-users@oliver.com Subject: RE...

Hi Thomas, did you check the configuration of the Process Metabroker? The PM must publish these runs to the Listener. Please check the logfiles that the connection between PM and Listener will be okay. Regards, Udo Thomas Richard Nel 19.11.02 12:22 Bitte antworten an datastage-users An: "datastage-u...

Hi Guys, Im currently running DSXE 6.0 on a Win2K machine and Ive ran into some problems with the process metadata. The problem is that the events are being recorded, as I can see them in the "Events" folder under the Process MetaBrokers directory, but it is not being recorded into MetaStage. Ive re...

Average. Its the Num Rows column divided by Elapsed time. It seems to be rounded low (eg 25.95 => 25 ) Erwan ________________________________________________________ PS & FYI: A french speaking list, similar to this one, is available at m You might want to use it. >>> katarzyna.lewicka@cgey.com 11/1...

IIRC, We had a similar problem when migrating from 4.0 to 5.2 ( NT): The new OCI stage has some different behaviours. One of them is that it doesnt accept multiple rows returned from a lookup, as it used to. It now complains and finally aborts. We thought the key we were looking up on was unique. It...

hi all,

In the DataStage Monitor there is a colun rows/sec : at the end of the job,
the value is an average value of number of rows/secs processed in the whole
process, or just a view of the "speed" at the end of the job?

Kasia

DataStage does have a MATCHES operator (not function). You can therefore use this in a constraint expression, for example: (empno MATCHES "567...") This operator uses quite idiosyncratic, and quite powerful, pattern matching capabilities. The pattern can be made up of as many as necessary of the fol...

More questions... What is the content of the "phantom" message? Are there any residual files left in &PH& (in the project directory) that have useful information? To allay you concerns about bugs, we use DataStage 5.2.1 extensively with Oracle and do not have the type of error you describe. So, I th...

We saw that same issue here, but I wouldnt say we saw it for every lookup. For us, it seemed to be related to either the size of the table the lookup was being done against (as in large tables) or when a large number of rows were processed thru the lookup. In either case, large was a million plus. W...

Are you sure the OCI plugin was installed when DataStage was upgraded? What version of the Oracle client are you using? -----Original Message----- From: Sylvain Guilbault [mailto:sylvain.guilbault@cognicase.com] Sent: Tuesday, 19 November 2002 10:57 AM To: datastage-users@oliver.com Subject: OCI err...

Hi everyone, When migrating jobs from DataStage 4 to 5 every lookup directly connected to an OCI stage doesnt work anymore. The jobs aborts with a phantom and when we try to browse the OCI link we get an error message saying that DataStage is not set up correctly on the server. Forcing the link to f...