DSXchange

What I am trying to do is effectively a pivot of an unknown number of columns to rows. My input text field contains a number of values, which can be easily extracted with string manipulation. For each value I find, I want to generate an output row. That is, the transformer stage will have more rows ...

It would help if we knew what operating system you are on, plus what databases you connect to and how you connect to them. You may also be better off upgrading to 5.2 if it is available for your platform as it fixes "quite a number of issues" with 5.1, or so Im told. Also note that there is a *large...

Hallo Larry, we have not the problmes like you on HP-UX. We must only kick a littel bit the OCI-PlugIn (manuell correct the permission of the libs and register the PlusIn from Manager). regards Udo "Bos, Larry E" 16.04.02 14:11 Bitte antworten an datastage-users An: "datastage-users@oliver.com" Kopi...

This is a topic for an orphaned message.

Hello Damien, in the readme.txt are some remarks. Also make a test of the software. There are some Bugs in DataStage 5.1A (HP-UX). Regards Udo Neumann Kavney Damien 16.04.02 01:17 Bitte antworten an datastage-users An: "Datastage-Users (E-mail)" Kopie: Thema: Tips for Upgrading to Datastage 5.1 Hi, ...

ill see what i can piece together for you -----Original Message----- From: Marzio Rotondo [mailto:ce101882@tlsoft.it] Sent: Tuesday, April 16, 2002 9:36 AM To: datastage-users@oliver.com Subject: Re: Complex Examples on DataStage use How can I see these (or other) examples?? Marzio Rotondo ----- Ori...

Thanks a lot!! Marzio Rotondo ----- Original Message ----- From: "Himanshu Patel" To: Sent: Tuesday, April 16, 2002 3:45 PM Subject: RE: Complex Examples on DataStage use > ill see what i can piece together for you > > -----Original Message----- > From: Marzio Rotondo [mailto:ce101882@tlsoft.it] > S...

These are examples of our current production jobs. also have other jobs that auto FTP out text files and then have control jobs that access the ftp site and rename the text files etc.. -----Original Message----- From: Marzio Rotondo [mailto:ce101882@tlsoft.it] Sent: Tuesday, April 16, 2002 9:28 AM T...

How can I see these (or other) examples?? Marzio Rotondo ----- Original Message ----- From: "Himanshu Patel" To: Sent: Tuesday, April 16, 2002 3:38 PM Subject: RE: Complex Examples on DataStage use > These are examples of our current production jobs. > also have other jobs that auto FTP out text fil...

Hi, Ok for the examples you are listing. Could you tell me where I can find these?? Furthermore, do you know (or you have) about study cases on (quite) real datawarehouse problems?? Thanks for your help. Marzio Rotondo ----- Original Message ----- From: "Himanshu Patel" To: Sent: Tuesday, April 16, ...

I did try that, but couldnt get it to work. I kept getting "ORA-00911: invalid character" error. -----Original Message----- From: Bos, Larry E [mailto:lebos@sandia.gov] Sent: 15 April 2002 22:24 To: datastage-users@oliver.com Subject: RE: Defining Oracle Rollback segments Why couldnt you let DataSta...

Damien, We did the same upgrade (on HPUX 11) two weeks ago and have had two problems: 1. Unable to connect to the DataStage engine from any client. Turned out that with the current code in ds.rc, your dsenv file must have execute permission set. 2. Unable to add a project from the Administrator (del...

whats kinds of examples would you like ? ODBC to ODBC & Sequential hashed / sequential to odbc and then pole for another value from another server before continuing etc.... -----Original Message----- From: Marzio Rotondo [mailto:ce101882@tlsoft.it] Sent: Tuesday, April 16, 2002 6:05 AM To: datastage...

Hi Everybody, theres anybody that can tell me about a repository of examples of DataStage use that are more complex than the tutorial given by the product? In order to better understand the behaviour of DataStage on problems more complex than the sequential-->transformer-->sequential job. Thanks, Ma...

Its version 5.1.0 on AIX. Ive also put a call in to Ascential and am waiting for an answer. Regu -----Original Message----- From: David Barham [mailto:david@barham.hm] Sent: 15 April 2002 21:54 To: datastage-users@oliver.com Subject: RE: Defining Oracle Rollback segments Regu, I dont have the answer...