DSXchange

Hello,
I have used the &PH& directory to try and troubleshoot jobs that have been aborting with the abnormal termination warnings. I was wondering exactly is the &COMO& directory and would this be useful also to check when jobs are failing with these warnings Stashima

Hi, I am very much interested. Pls let me know the duration of the project. I am currently in Singapore. Regards Saravanan "Hendrik Kotze" cc: Subject: RE: We need outsourcing 26-Sep-2001 02:28 Please respond to datastage-users Sender Info: No Sender Info found in the address Book Hi We need some mo...

Hi We need some more information. How long will the initial project be. It is possible to get some interest from South Africa. -----Original Message----- From: Kittisak Puengpunyadee [mailto:KittisaP@dtac.co.th] Sent: Wednesday, September 26, 2001 7:09 AM To: datastage-users@oliver.com Subject: We n...

Hi folks, My company, TAC telco company in Thailand, is gonna have an ETL project using DS in UNIX environment. My boss prefers oversea outsourcing who can work in Thailand. If anyone is interested, please reply me asap for talking in more details. Sorry if it sounds like spam mail for you guys. --K...

It has been brought to my attention that, and I quote, "there has been much work in DS 5 to correct previous problems [in dsjob]". I felt that its only fair to let you know. I have not yet had a chance to play with it.

Hi all, This is a very trivial one for most of you. I am trying to import the Metadata from the Manager using the DB2 plug-in. But it gives me a not so friendly error message "Unable to obtain list of available tables in server DW0001". But when I try to access the table from Designer it shows the d...

Hello The client have DataStage 4.2.1r2 (64 bits) on a server HP-UX 11.00 PA 2.0 Risc with drivers CDSK 2.50.HC2 provided by Informix to connect to Informix. When they try to open the DataStage designer, it gives this error "Error calling subroutine *Datastage*DSR.ADMIN (Action=2); ..... (Subroutine...

Greg, the overhead is minor compared to an ETL architecture approach that doesnt use bulk-loading. As far as caching is concerned, the function is declared in the beginning of the DataStage job code and cached in memory. You incur the overhead of BASIC calling this function externally to the code, a...

Does anyone know (for certain) whether the call overhead for a Routine is
incurred once (and cached), or once per row?

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

I place a higher priority on modularity, reusability, and test-ability. The Transform is a snippet of code included at compile time. Any changes to this transform require a recompile of all jobs that use it. In addition, you do not have the "Test" button as you do in a routine. If you seek to learn ...

As I understand it, a Transform becomes in-line code when the Transformer stage is compiled, whereas a Routine maintains a separate existence, complete with call overhead. Therefore, maintaining a library of Transforms (where possible) and Routines (where not) would be better value than maintaining ...

Theres an expression out there: Theres a million ways to skin a consultant. Any way you choose to do it, the underlying necessity of a library of routines still exists. This thread started as a request for help in BASIC. My recommendation is to develop this library, and code it per the business rule...

Ken, I admit it, but then I always use Ans=Not(Not(Len(Arg1))) as my Exists function. Put the rest down to carelessness. In fact, just Ans=Len(Arg1) would do, since 0 and "" are regarded as false, and any other non-null value is regarded as true in a Boolean context by DataStage. By the way, have yo...

Hi, If the problem persists after a client reboot, and jobs not using R/3 plugin are affected, it might be that your existing stagetype records (on the server) have been corrupted somehow. Do they show up correctly on the Manager screen? Worth a call to tech support. Regards - Chris Thornton -----Or...

I have DataStage 4.1 running on Sun Solaris 8. Since root must install DataStage, many files are owned by root with other as the group. My users are in a group DBA. Many files in the project directory and ardent home have the world writable bit on. This is driving my security team nuts. Can I change...