DSXchange

Hello all, We are upgrading the extract Pack for R/3 Plug-in to V3.0 from V2.0 to utilize the IDoc feature. The installation was successful on the server side. But during the installation in the client side it gave an error while doing a version compatible check with Extract Pack for R/3 with a mess...

Im trying to compile some information to help in datastage server sizing... Information Im looking for is what people are doing with what kind of hardware. Im looking for something like: 4 400Mhz CPU NT, 512MB memory, 300 Rows/Second or 2 750 Mhz CPU Sun, 1G memory, 100 Gigabytes in 14 minutes and, ...

If you express it as a single line: Ans = Not(If IsNull(Arg1) Or Trim(Arg1) = "") then it can be put into DS as a Transform rather than a Routine, which is a Good Thing if youre going to use this code in Transformer stages a lot. Avoid that CALL/RETURN overhead where not needed! Cheers.........Len >...

Hey Ray, you just made a big booboo. If you use the code: If variable Then "Exists" Else "Not Exists" You just made the classic mistake of overlooking that the value of ZERO evaluates as not existing. This is WRONG! Also, NULL evaluates as @FALSE only because it is indeterminate. If you code this wa...

Paul, The following might get you started on how to do this. Since there is not a direct way using ICONV / OCONV to generate your end result, a little bit of data massaging has to be done. Here, we have the three strings A, B and C (lines 1 thru 3). Lines 4 thru 6 convert these external format times...

Because of the DataStage environment being free of data types, a simpler test for existence is simply to test the variable. For example: If input1.column2 Then "exists" Else "does not exist" A NULL always takes the ELSE path since we cant assert that its true. If the data item contains a string, the...

I am fairly confident there isnt any. Two reasons. One is that so few people actually understand exactly what DataStage jobs are doing. The other is that the "bottleneck" can rarely be sheeted home to DataStage - almost always in my experience the bottleneck has been outside, perhaps running out of ...

Paul, checkout the BASIC .pdf file that is under the DataStage documentation on your Start button --> Ardent DataStage -->Online Manuals --> Universe documentation. There are two functions called ICONV and OCONV with which you want to become familiar. ICONV can be handed a time and format string and...

This is a topic for an orphaned message.

Hi Ken, Im not saying that DataStage uses multi-threading. It does though support multi-processing. I was just explaining how DataStage works when jobs are designed with independant active stages. Ive seen customers setup their projects so that they have multiple jobs runing in parallel from a contr...

Oconv(string, "MCN") "MCN" is "masked character numeric", which removes all non-numeric characters from the string. -----Original Message----- From: Paul Ko [mailto:PKO@clear.co.nz] Sent: Friday, 21 September 2001 09:02 To: datastage-users@oliver.com Subject: Time conversion Hello, I am not a good u...

Hello, I am not a good universe basic writer but I am just wondering if anybody has developed such a routine before that convert a specific time format into another format. What my requirement is to convert a time format HH:MMam/pm to HHMM. For example, 1) 9:34am to 934 2) 9:34pm to 2134 3) 12:12am ...

Hi, all Some of our DataStage jobs that extract from SAP occasionally would not extract any rows. The DataStage jobs effectively calls an ABAP program in SAP. These jobs just extract all rows from various reference tables in SAP. Therefore, I expect at least the same number of rows as the previous r...

Does anyone know of a profiling tool to help optimize a DataStage job and find where the performance bottlenecks are?

Thanks,

Anthony

Try checking the &PH& log : 1.) before the job abort( if possible) 2.) just after the job aborted (before resetting the job) 3.) after resetting the job Regards, William Tan -------------------- ----- Original Message ----- From: "Hailey, Stashima [SLC]" Date: Tuesday, September 18, 2001 3:55 am Sub...