DSXchange

Hi all, unitl I used the following function (1) with DS4.0.2 on WinNT it works fine. Now Im working with DS4.2.1r8 on WinNT and I have this error message (2). Has anyone never had my same problem? Thanks, Alessio -->>(1) ************************************************* $INCLUDE DSINCLUDE JOBCONTROL...

Thanks for your input on the tests Tjomme. We actually did include lookups in the tests using DataStage hashed files though these were not included in the press release. We did this test on the full terabyte of data using in memory hashed file lookups and it added 2.5% to the time of the actual run....

Hi Dharmendra, you can find an ascential example named "UtilityHashLookup" in category "sdk/utility/" (DS4.2). Anyway here is a little example of mine: ********************************************* HashLookUp(HasnFileName, HashKey) ********************************************* common/HashDoc/ CVFlag...

This is a topic for an orphaned message.

tjomme, you row rate does look particularly bad, which probably means that the job might need tweaking. I presume your taking the OC sources into hashfiles? there are many things to check to try and get your row rate up, and yes depending on your machine would depend on what speed you get, but even ...

Tjomme, Are you on a 24 CPU machine with LOTS of grunt and LOTS of memory, all of which would have helped. Also, the benchmark job was doubtless designed to take maximum advantage (a) of DataStage innate parallelism and (b) the Parallel Extender (read the web site). Sure, if you run DataStage jobs o...

Tjomme, Sounds like something needs a little tuning. One of our slowest jobs (in rows per second) does 8 rows per second with 18 lookups to Oracle (which is on a different server) in one transform stage. This is the last transform in the job. Earlier transforms filter out some of the rows. So at the...

This is a topic for an orphaned message.

Looks very nice considering we are now doing an upload of 50.000.000 rows at a speed of 3 .6 rows/sec... At this raid we finish in 5 months... The job contains 6 hash file lookups and 6 SybaseOC lookups. Nothing spectacular, but these things are real life data validations and lookups. They dont test...

David Its easy when you know how. All compiled. Thanks quick response. Adam "David Barham" on 22/02/2002 12:54:58 PM Please respond to datastage-users@oliver.com To: datastage-users@oliver.com cc: (bcc: Adam McGuinness/NSW/QBE/AU) Subject: RE: Transform Function calling Transform Function You need t...

Youre not doing anything wrong, however youre omitting a vital step. You must tell Function2 that Function1 is, in fact, a function using a DEFFUN directive. This alerts the compiler that, when it finds "Function1 (" it is not to assume that it is a reference to a dimensioned matrix but, rather, a f...

You need to "declare" function1 at the start of function2 Deffun Function1(dummy parameter list) Calling "DSU.Function1" The parameter list is just placeholders to let it know how many parameters it has. -----Original Message----- From: amcguinness@qbe.com.au [mailto:amcguinness@qbe.com.au] Sent: Fr...

HI DS People I have written a DS Transform Function (Function1) that does what it is supposed to do in DS3.6. Next I have written another function (Function2) that calls Function1. When I attempt to compile, I get: -------------------------------------------------------------------------------------...

Himanshu, I created a job to test this and, yes, it works. With one caveat; you can not use the default Select List (Select List number 0) because this is used by DataStage. So, your Transformer stage invokes ExecTCL as a before-stage subroutine, and the command is GET.LIST listname TO 9. Your UV st...

here is the situation i am dealing with. I have a tracking file in universe ( hashed file ). This file contains the FileName and Key to various files that have been updated during the day. We are only at UV rel 9.5.1.2 ( mgmnt wont let up upgrade to 10 yet ). Therefore none of my Universe files are ...