DSXchange

Craig,

Very, very cool! Now we can share images with others - I like it!

What Alan and Shawn recommend is {probably} the best practice regarding the usage of CRC32 and SCD processing. You need not be concerned about the liklihood of "collisions" for the reasons that Alan pointed out plus some fairly complex math. The liklihood of a failure to generate the corre...

You need to make sure you are importing the metadata via the manager using the Import>Table Definitions>UniVerse Files I believe you are referring to the left side column numbers. After you check the "Metadata supports Multi-valued fields" you should see two new columns on the columns page...

This feature is found on the table def record in the repository. UniVerse files are positional or the fields are offsets from 0 with 0 being the key. When you create the file (via a DS job) a dictionary will be created that contains the metadata for the file. The key is position 0 and subsequent fie...

Either from the command window in Administrator or TCL you can enter the following command -
Or if you are not sure of the name or want to expand the search you could do -

Remember that as you add additional transformers the performance of your job will decrease. In a perfect world it's better to have as few transformers as possible, but in your case I would suspect that this is not reasonable. As Craig states - there are many variables here that will impact the perfo...

Kim is an IBM_WS_DS Guru!

You might not want to use FileVar, but rather use FilePath (in your DSLogWarn) since FileVar is a handle to the file you just opened.

Arnd,

I only point this out so that we don't get a post one day saying "I used uv to create a new account and now I can't see it from DataStage ...... will someone please help me?????"

If you get asked which flavor, say "no" unless you wish to create a new UniVerse/DataStage account.

I do believe this will create a new (valid) UV account, but I believe there are a few more steps if you want DS to recognize the new account as a valid DS project.

And if you choose to run via a batch job then you can set the warning limit via the api.

Craig, I seem to recall that at a minimum it will display warnings etc.. each time you use them this way. I remember using them @ BellSouth for months without a time limit, but that was 3 years ago and this could have all changed. Most needs that I have seen where people choose to use a routine for ...

If you are referring to a BASIC routine then you would have to connect to Oracle via ODBC if you wanted to do something like return a result set. Ray gave you information on how to define your ODBC in UniVerse and it is correct for DataStage and if you were to use the "CONNECT" command fro...

Please first search the forum as this has been covered. Here is one link -

Here

Kim,

JOBTYPE is a supplied "I" type of value - IF JOBTYPEIND = "" THEN 0 ELSE JOBTYPEIND found in the dict of DS_JOBS