DSXchange

Assuming the inappropriate ";" was just a typo in the email message and that your job did not change from version 4.0 to 4.2, I suspect you might have run into one of the differences between ORAOCI8 2.3 and 3.0. I would suggest that you contact Ascential about this to see if this might be the case. ...

Dear all, Im trying to connect to a unix (compaq tru64) datastage server. The answer is an error: Failed to connect to host: XX.Y.Z.XX, project: UV (The connection has timed out (81015)) I was able to connect to this server before a firewall was installed to hide my datastage server. Now Im able to ...

David, you might like this idea. Its a bit of a kluge, but could simply handle the trick you need. Your problem is one source row creates an indeterminate number of output rows. If you write a function that accepts as the only argument the entire row of data, that function can parse the row and crea...

Hi All, Today, I upgrade DS 4.0.x to DS4.2.x and OCI Stage 2.3 to 3.0, but I found something wrong in jobs Some Job use OCI Stage with user defined sql. I write P/L Sql eg> begin insert a(a,b,c) values(:1,:2;:3); Exceptions when dup_val_on_index update..... End; Anyways this was working well when da...

Im going to use version 5.1 of DataStage, so I think both solutions should work. Thanks again, Marzio Rotondo ----- Original Message ----- From: "David Barham" To: Sent: Wednesday, April 17, 2002 10:27 AM Subject: RE: Select on OCI8 stage > In fact, you can even put a hint on a generated query by in...

Hello David, weve had a similar problem year ago. We had a sum, a start-date and an end-date and had to divide the sum in monthly parts, one for each month. Sometimes it was only one month, sometimes 50 or more month. We used a routine to calculate the amounts and month. The routine gave back two ve...

In fact, you can even put a hint on a generated query by including the hint (and the first column name) in the derivation of the first column. Maybe a little obscure, but it works (well depending on your DataStage version - in the older versions of the ORAOCI8 plugin, the derivation field didnt work...

Yep, you sure can. No problems. -----Original Message----- From: Marzio Rotondo [mailto:ce101882@tlsoft.it] Sent: Wednesday, 17 April 2002 6:11 PM To: datastage-users@oliver.com Subject: Select on OCI8 stage Hi everybody, theres anybody knows if a user defined sql query on the OCI8 stage could conta...

Thanks, Marzio ----- Original Message ----- From: "David Barham" To: Sent: Wednesday, April 17, 2002 10:17 AM Subject: RE: Select on OCI8 stage > Yep, you sure can. No problems. > > -----Original Message----- > From: Marzio Rotondo [mailto:ce101882@tlsoft.it] > Sent: Wednesday, 17 April 2002 6:11 PM...

Hi everybody,
theres anybody knows if a user defined sql query on the OCI8 stage could contain HINTS?? Thanks, Marzio Rotondo

Maybe someone can solve this mystery for me. Having recently upgraded to 4.2.2 from some ancient version of DataStage (3.5), we thought the new Command Stage seemed just what we needed. We read a list of sites and paths to which we must copy some files and then attempt to execute a CMD file (which a...

Advanced DataStage (DS305) and DataStage Best Practices (DS306) cover detailed topics such as Star Schema loading, Surrogate Keys, SCDs, and Batch/Sequencer logic. Try enrolling in them. Pavan -----Original Message----- From: Marzio Rotondo To: datastage-users@oliver.com Sent: 4/16/2002 9:28 AM Subj...

The following is a possible solution for resolving your dilema. There are other ways, some better, some worse. - Create a routine, argument(s) will be the field(s). The routine will perform the parsing and write the records as needed to a hash (or sequential) file. You could use @FM or any delimter ...

Installation might also be longer if you are installing the Axcel option in DS5.1 -----Original Message----- From: Bos, Larry E To: datastage-users@oliver.com Sent: 4/16/2002 8:11 AM Subject: RE: Tips for Upgrading to Datastage 5.1 Damien, We did the same upgrade (on HPUX 11) two weeks ago and have ...

Thought of a bit more I should add. I do not want to do this to all the input rows, just certain ones that meet certain criteria. Using the "Normalize on" option does not appear to be an option at this stage (although I will investigate further to see if I can process these rows separately, possibly...