DSXchange

Hi Rochelyn, To subscribe to the list, send an empty message to datastage-users-subscribe@oliver.com. More details on m Also if you are considering upgrading you may wish to take a look at our latest-and-greatest release - 5.1, as announced on November 5th. Im not sure of the availability HP-UX thou...

Hmmm ... do you use the ORAOCI8 plugin? This could have a bearing on the answer. -----Original Message----- From: Rochelyn Gamao [mailto:rochelyn@summit.com.sg] Sent: Monday, 15 April 2002 4:17 PM To: datastage-users@oliver.com Subject: DataStage query We are planning to upgrade our DataStage 4.0 to...

Ive seen this when upgrading versions as the FTP plugin password is encrypted and it can get clobbered, but it doesnt sound like that is your problem if you are still running 3.1.1r3! Some questions: How are you passing the password to the stage? Keyed into the stage or passed as a job parameter? Do...

Giovanni, We had that same problem in production when we first migrated (no response to run command, except as root). The problem for us turned out to be the permissions on a parent directory to ardents home directory. In our case Ardents home was /export/apps/Ardent/uv, but the permissions on /expo...

Hey Dirk, I have been out so I wasnt able to reply sooner. You need to make sure you have a valid path for the control file directory (as well as data file, log file, and discard file directories). Even though you are not creating the table, the redbrick pluggin creates the sql to do so in the sql f...

I found this: m -----Original Message----- From: Asimkumar A. Munshi. [mailto:masi@sonata-software.com] Sent: Monday, November 12, 2001 3:48 AM To: datastage-users@oliver.com Subject: Soundex() logic Dear all Can any one enlighten me about the logic used by Soundex() function for generating the code...

Were running DataStage 3.1.1r3 (yes I know, old and unsupported) on a Windows NT 4.0 server. We retrieve data all the time from an IBM mainframe via FTP with no problem. Were now trying to retrieve data from a DEC Alpha. Its a simple .dat file were after. If I use the standard FTP commands from our ...

Asim, Keep in mind that Soundex does not and is not intended to generate unique keys. In fact, its intention is quite the reverse. The purpose of Soundex is to generate a common code for names that sound similar. Normally, you would present this list to a user, so that they can choose a name from a ...

Hi Asim I use the Soundex function to conform the data to a standard code and name. The business I work for has several systems. Each system has a different code for the same business unit, as well as, a slightly different name. Soundex has worked well because it has eliminated "pain in the neck" ma...

Dear all Can any one enlighten me about the logic used by Soundex() function for generating the codes? Regards > Asim Munshi > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Consultant - Business Intelligence, > Sonata Software Limited, > 193, R V Road > Basavangudi, Bangalore - 560004. > * 91-80-6567492...

thanks a lot!

how can i check it out?

Hi Pedro, If at all try to avoid doing straight lookups through either an ODBC or OCI source. You can improve the performance by loading the data into a hashed file and doing a lookup from the hashed file. Pavan -----Original Message----- From: pedro santos [mailto:pedro_f_santos@hotmail.com] Sent: ...

Hi there, Im running in a problem trying to execute job with DS 4.0 on IBM/AIX. Since 2 days try to start manually or scheduling the job, nothing happen (ON PRODUCTION ENVIRONMENT (((( . Ive checked the space on all the files system on server and everything is OK. Does anybody run in such problem? A...

Hi, I use DS, running in Windows NT and am trying to extract data from Lotus Notes application, which is running in Unix Server. ODBC driver is used to connect to Lotus Notes database and LotusNotesSQL client was installed in ETL server in order to connect to LotusNotes database and I could create/a...

Nope, this one also doesnt work, but thank you for trying - I appreciate it. I changed the setting, and also stopped and restarted the Redbrick service, but I still got the "precomputed view set invalid" messages. Dirk -----Original Message----- From: Ray Wurlod [mailto:ray.wurlod@Informix.Com] Sent...