DSXchange

Thanks Ray. One of our lookups had a very fat key and it exceeded the 255 barrier. 255 bytes is the limit by default. There is a tuneable parameter called MAXKEYSIZE in later releases of DataStage (4.2+ ?) that can be used to increase this. In release 5.2 of DataStage the default for this parameter ...

Does anyone - perhaps one of the Ascential contributors or lurkers - know whether there is an undocumented value that allows DSGetJobInfo() to return the job version number? Or whether there is some other way to retrieve the run-time version number by means that dont rely on unpublished knowledge of...

When you say "in my outfile", to what kind of file are you referring and what are you using to view it? UniVerse internally uses the single byte 0x80 (decimal 128) to represent NULL. Many text file viewers display this character as the Euro character. (The current release of UniVerse has a configura...

Cant reproduce it today. One for Rod Serling! At least I can get on with what I was actually trying to accomplish! >From: "Neil Beckwith" >Reply-To: >To: >Subject: Re: [UV] Inline Prompts in Sub Query >Date: Wed, 28 Aug 2002 16:53:33 +1000 > >Looks like you may have done something strange there Greg...

Brad, Im not posting this to the group as it is just speculation. I have never used 5.1. Refer to my previous post about the connections per link instead of connections per stage. We found in 4.2 (and I believe that 5.x was the same for a time), that DataStage would flood Oracle with connections whe...

Anyone ever run into this? Just started happening to us today. We have Windows NT Advanced Server running DS 5.1A. Were on a new server and connect to a DEC Alpha running Oracle 8.0.5. Several of our lookup jobs, which are OCI8 stages to hashed file stages, have started getting the following on a fe...

Hi All, I have a question on DataStage Basic programming User-defined variables (@USER0, @USER1, ...). Are User-defined variables (@USER0, @USER1, ...) safe to use in a Routine to hold temporory data (like write (Set) & read (Get) approach). The temp data will be written (Set) once in one of the Tra...

In my previous mail mysterious character got changed to EUR due to exchange server processing but that character looks like EURO symbol in notepad. Dinesh -----Original Message----- From: Jain, Dinesh X [mailto:Dinesh.X.Jain@questdiagnostics.com] Sent: Wednesday, August 28, 2002 9:04 AM To: datastag...

When I write data out from Hash file, I am getting a mysterious(EUR) character in output file for every column in a row, whenever column value is NULL. Is there a way to suppress that character, so that output is actual NULL value. In the hash file data looks like: MATTHEW,,BROC,,,U,,,60007 in the o...

Thanks, David. Good input. We have to work out with our LAN folks what the best approach will be to a scheduled run of McAfee VirusScan, when DataStage jobs are not running. The reason were upgrading just to release 5.1A will cause you to roll your eyes. I had every intention of getting up to 5.2r1,...

The SDK routines such as UtilityHashLookup are cataloged with a DSX. prefix (rather than the DSU. that user-written routines get). Try this:- DEFFUN UtilityHashLookup(arg1, arg2, arg3) CALLING "DSX.UTILITYHASHLOOKUP" * NOTE The routines catalog name is in all upper case! ans = UtilityHashLookup(hash...

This is a topic for an orphaned message.

Looks like you may have done something strange there Greg... I tried, and got results as below. Telnet to local DS 5.2r1 on Win2k. >.X 01 SELECT NAME, READONLY, @ID FROM DS_JOBOBJECTS WHERE OBJIDNO = (SELECT JOBNO F ROM DS_JOBS WHERE NAME = ); JOB=BuildFT Object name......... (reserved) DS_JOBOBJECT...

A strange thing happened to me today. Has anyone else encountered anything like it? It occurred in a telnet session in DataStage 5.2; I will be testing it on UniVerse before reporting it to support. The problem is that an inline prompt appeared not to be resolved in a subquery, yet worked fine in th...

255 bytes is the limit by default. There is a tuneable parameter called MAXKEYSIZE in later releases of DataStage (4.2+ ?) that can be used to increase this. In release 5.2 of DataStage the default for this parameter is 768 bytes. Note that the limit is bytes. With non-ASCII character sets (and NLS ...