DSXchange

The closest thing DataStage BASIC has is MATPARSE. The target of MATPARSE is a dimensioned array, but this can subsequently be converted into a dynamic array or a space separated array using MATBUILD or ordinary code. For example: Dimension Tokens(1000,2) MAT Tokens = "" ; * initialize Delimiters = ...

Check with Ascential. We are on 4.2 and had raised it as an issue with them and they mentioned the CRC32 function. Until we upgrade, we got around the issue by calculating checksums on two halves of the data and concatenating the result (using bit shifting and boolean operators). It is a crude techn...

Hello All, Is there a predefined function in DS Basic that would help me get the different words contained in a string that are separated by any character contained in a list of characters? Here is an example in Perl of what Im trying to accomplish: my @words = split /[] ~`!@#$%^&*()_-+={}[|:;,.?/"]...

Hello All, Is there a predefined function in DS Basic that would help me get the different words contained in a string that are separated by any character contained in a list of characters? Here is an example in Perl of what Im trying to accomplish: my @words = split /[] ~`!@#$%^&*()_-+={}[|:;,.?/"]...

I am using DSv5.1 . It appears to use the 16 bit checksum as the checksum value always has 5 digits. Which version uses the CRC32 ??? Can the function be imported ??? Cheers, Andy. -----Original Message----- From: Galemmo,Nicholas,GLENDALE,IS [mailto:nicholas.galemmo@us.nestle.com] Sent: 31 October ...

If you want to keep it in DataStage, create a job that loads an empty sequential file to the Oracle table and set the OCI stage to either clear or truncate if you have the permissions. No rows will be processed, but the first thing that will happen is the table will be emptied. Or use any other kind...

I echo Alans comments. Which version of DataStage are you using? The 4.x checksum function returns a 16 bit value. This is not really suitable for data warehouse applications because there is a 1 in 64K chance of receiving a false positive (matching checksum values when the data is actually differen...

Hello Group, We have a daily job that writes data each night with the insert rows without clearing command to an Oracle table. At months end processing we would like to process the data that has accumulated and then clear the table to prepare for that nights scheduled daily run. Any suggestions on h...

Andy, You may want to store the source row checksum as a column in your Oracle table, then retrieve it when you look for deltas. You may want to look into a CRC routine for your checksums. Regards, Alan Williams > > From: Andy Burnage > Date: 2002/10/31 Thu AM 06:13:21 EST > To: datastage-users@oliv...

Folks, To check for deltas, I am using the checksum function on the source row, and comparing to the checksum on the row looked up from the target. This works OK. Does anyone know of a checksum function or source code for Oracle, so rather than return all the columns from the target row and do the c...

You can read the following information from the error messages. DataStage was executing its DSR.MetaGeta function (a function involved in retrieving metadata), attempting to return a list of table names in the database (GET.TABLES argument) calling the SQLTables ODBC function. This function is a BAS...

This is a topic for an orphaned message.

There is a header file called FILENAMES.H in UNIVERSE.INCLUDE in which most of the useful pathnames, etc., have been built. UNIVERSE.INCLUDE is in the DataStage server engine directory but is accessible from any project. The variable UV.BIN contains the pathname of the DataStage binaries directory, ...

On what basis do you make the claim that DataStage ignores the hash lookup? If the "active stage finishing" entry in the log reports that zero rows were passed along the reference input link, this means that no lookup was successful; not that the link was ignored. Inspect the code produced by the Tr...

Hi Folks, My datastage job ignores the Hash look up as the hash file has 8 million rows(4 columns; 2 keys and 2 lookup values). Wanted to find out why this happens. Did anyone face this? Thanks Gopal Ganesan =========================================================================== IMPORTANT NOTICE...