DSXchange

Sunshine2323 You have made my day. Excellent technique, but please consider the partitioning required on a multi-node cluster to keep grouped rows together. Otherwise, the "last" aggregate solution doesn't require the final row output fix. Excellent. The same solution would work with Server by chang...

Batch files--> .bat extension files used by DOS and Windoze systems to automate operating system commands

Batch jobs--> DS Server based jobs consisting purely of DS BASIC logic, often used to call DS job control APIs.

It's fast as long on you don't mind table level locking.

Thanks for the kudos. One correction, we're Premium Posters because we are sponsors, supporters, collaborators, and/or partners together with Strategies and provide our time answering questions as part of that arrangement. We have nice blue shirts and a booth at IBMs annual trade show.

There are no shell commands for designing jobs. There is a requirement for knowledge of your operating system and the methods for interacting with that environment. Moving, copying, searching, and profiling files are knowledge requirements for you as a developer. Knowing how to count a file for the ...

Use the appropriate method to accomplish your goals. If the easist way to rename a file is thru a shell command, it's silly to write a DataStage job to read the entire file and then write it under a new name. There are reasons to do things in a shell or SQL script, just like there are reasons to use...

Smita, the indicated post shows how to use stage variables. You must sort the data by the grouping keys and partition by them so that they stay together on the same node. The only issue is the last group won't output without some help. The "trigger" event on the stage variables is to only output the...

Here's a quick test. If you can't see the following message, then something is wrong. There's nothing to do, all content shows without restriction. If you're not premium, you couldn't be reading this at all.




WOW! Premium content is sure awesome.

Honestly I don't know the nitty-gritty details, but my impression is that the SQL just becomes a "LIST ditem1, ditem2, ditem3, ditem4, etc." type statement with headings and paging suppressed. This appears to be the case because changing the dictionary items information (width, justification, data o...

Make sure which account the jobs are using, as that's the dictionary you need to verify. An I-descriptor is basically a compiled function that represents a column, which means you need to read the code and see what it's doing.

The dictionary is what is used. Dictionaries can contain correlatives that point to other files. This is why Universe and Unidata are so complicated. If the dictionaries are not pure A or S types, then you can get into all kinds of trouble. If there are F, T, or I correlatives/descriptors then your ...

There is no conversion, DS Server doesn't care. Just map it to the target column. Now, in the reverse direction, you need to make sure if the ultimate target is a database that you conform the data to the type, length, and scale.

Ray, rather than obseving my reply if you could reply on the problem it would be better. Maybe after you've posted 1000 responses you might be qualified to judge the appropriateness of Ray's commentaries on this forum. In the meantime, remember who Ray is and the obvious time he devotes to making t...

Your original question regards comparing two rows and if they are different acting on that change. A trigger is anathema to ETL, in that you are embedding transformation and loading logic within a database, removing it from the visibility of the ETL framework. Consider the various techniques found o...

dsenv file