DSXchange

Not wanting to hijack the thread this came from, I've started another. "UniVerse" will be going away as the repository database in the next release. Though I'm sure IBM would be happy to sell you a copy of UniVerse when that happens. Ok... I understand things like Oracle will replace Universe as the...

One answer would be - why? Jobs should run with zero errors or warnings, setting it to unlimited is just asking for trouble.

Use two different links.

Yes, it should work just fine. Perhaps there is a fundamental mismatch of parameter types at work here... as noted, please post the exact 'syntax complaint' you are getting, that and the parameter types involved should help figure out what is going on.

A UNIX sort is a string sort by default. Look on the man page for the use of the -n option for the numeric keys.

That's correct.

If I sort again in the aggregator stage, then the output seems to flow little faster This is a common misunderstanding. You are not "sorting again" - you are asserting the already sorted order of the incoming data. If it has no clue about the incoming data it will take the time to 'sort' it again t...

Search the forum. From what I recall, the DB2 stage seems to want dates in internal format rather than the traditional external format you are using.

Well, at least you were able to answer it... thanks for posting it back here.

Been noted here a number of times. You have to be careful on 64-bit systems and make sure you include the 32-bit libraries in your paths. It's interesting the different ways it manifests itself on different systems...

You are getting the system date successfully, as is obvious from your error message. What you're not doing is handling it correctly. Need more information about what you are doing to provide specific help. What target database, target field, stage used, target datatype, etc. You'll more than likely ...

PS. This did work, by the way. :D

It does help tremendously, however, if when you set NLS_LANG in your dsenv file that you also export it properly. Exporting NSL_LANG made it seem like it wasn't going to work until I finally noticed the typo. Duh.

In.

ArndW wrote:@NULL will always return the same series.

Hmmm... not according to the manual. Unless you mean it will always return the same series when started at the exact same time. As you noted, adding something like the pid on top of that will make it as unique as you can get.

From the BASIC pdf manual: Use the RANDOMIZE statement with an expression to make the RND function generate the same sequence of random numbers each time the program is run. If no expression is supplied, or if expression evaluates to the null value, the internal time of day is used (the null value i...

Yes, as already noted there are definite limits to what can be brought in via the Folder stage. Don't forget that it reads in each file as a record, with the filename going in the first field and the entire contents of the file going into the second field, which is then parsed by the XML Input stage...