DSXchange

You havent mentioned what sort of stage you are using to access the view? Is it ORAOCI8? If it is be aware that by default, DataStage 4.1 comes with ORAOCI8 version 2.3, where as DataStage 4.1 comes with ORAOCI8 version 3. There are some significant differences (and bugs) between these, especially i...

Hi, I am having datastage version 4.1 on development and vers ion 4.2 on production.I have a job which deletes the records from a view which is based on 2 tables.The job is working fine on Version 4.1 ie it is deleting the records from the view.The same job if I execute it on version 4.2 it is not d...

Im trying to execute a DS job from a UNIX shell script using the Command Line interface. This works fine except all the parameters( including userid, password in my case) are exposed on the command line if someone runs a ps command from a UNIX session. Has anyone worked out a way to pass these param...

We are fairly new users of DataStage 4.1.1B on HPUX 11.00. Yesterday, when trying to access an OCI stage, I received the following message: ds_loadlibrary: error in dlopen - Dynamic Error. While working with Ascential support, we unregistered, deleted and re-installed the ORAOCI8 plug-in. When attem...

> Last week, the node upon which DataStage is installed > ran out of filespace unexpectedly (a couple hundred GB > of data were moved to the wrong file system). Since that > point, DS has gotten increasingly slower, locking up more > and more frequently, to the point where now we cannot even > open ...

We have DataStage 4.2.1 running on both HP UX 11 and Sun Solaris 8 here.

Ed

>>> ray.wurlod@Informix.Com 10/04/2001 6:45:38 PM >>> Check the BASIC manual that installs under your DataStage clients. OpenPath has the same syntax as Open, except that you specify a full pathname rather than a table (file) name. For example, if you want to open /tmp and process each filename in i...

We realize that this is most likely a server/OS/installation problem, but in case anyone out there has gone through something similar and has some suggestions, we would appreciate your feedback: Last week, the node upon which DataStage is installed ran out of filespace unexpectedly (a couple hundred...

Hi John, A functioning CFF plugin can found in DataStage 4.2.1. I could not get the one on Version 4.1 to work correctly either but when I design my CFF job with DataStage 4.2.1, it works alright. regards, Constance -----Original Message----- From: john Billy [mailto:jbilly70@hotmail.com] Sent: Tues...

Hello everyone! I use DataStage V4.1. I seem to have a problem with the CFF plugin. In Complex Flat File dialog box, I have 2 main pages (Stage and Outputs), which is OK. According to the online help documentation I should get 4 Tabs (General, Selection, Constraint and Columns), but I only get 3 Tab...

Without seeing the actual error message it is not possible to diagnose. Certainly your constraint expression appears to be valid. Beware of calling a zero length string "null", though - in other DBMSs the terms are quite distinct. -----Original Message----- From: John Thomas [mailto:datastagehelp@ya...

Use the ISNULL function, as documented in the Start Button --> Ardent DataStage --> Online Manuals --> Universe Documentation. You cant use a straight comparison with a NULL value! You should realize that SQL has a function dedicated to the NULL value, which is different than a BLANK value. DataStag...

Hi all, This is my first posting to the list. Pardon me if this has been discussed. I am loading the target table with one main source table and few reference lookups. I am looking for a surrugate key in one of the lookup table that can give me null values. I am defining my constraint so that if the...

Peter, Please confirm my advice with the Vendor. We currently use DataStage 4.1.1. When we installed 10 months ago we did so under Solaris 8. We never got it to work and had to change back to Solaris 7. This was under Vendor advice as they said that the product was not certified Solaris 8. They said...

Has anyone been developing/executing DataStage 4.x on a Sun server running Solaris 8 ? We plan to deploy on a Sun 280R in the next month.

regards,
Peter