DSXchange

Yes and no. Environment variables set in dsenv apply to any DataStage process, and therefore to any project. Within DataStage you can use the TCL command ENV to set the value of an environment variable. Beware that if you open a shell to do this (for example by using ExecSH or DSExecute or the BASIC...

Dynamic hashed files don't resize by doubling, they resize by adding one group (logically - probably about eight group buffers at a time physically). This actually gives you more pain, as you're taking the hit of restructuring every N records loaded, where N is the number of records per group. As Ke...

You should be able to find the answers by searching the Forum. The command used to delete a hashed file depends on the command that was used to create the hashed file, and whether a SETFILE command has been issued since. The command to clear the contents of a hashed file is CLEAR.FILE if issued from...

INTEGRITY began life as a flat-file to flat-file tool. When it became Quality Stage the input and output flat files could be replaced (effectively) by named pipes. This approach might be able to be used for your API too - the Sequential File stage has been able to used named pipes for quite a few ve...

That it gave "some warning" doesn't help to diagnose what happened. If your SETFILE command failed, then you don't have the VOC pointer that RESIZE needs. If you post what the warning message was, we will be able to be more helpful. Given the names of the file system objects that are out there, I ex...

srinivasb wrote:... we tried duplicating code in PL/SQL ...

Since duplicating the Java code is acceptable, what's the difficulty in duplicating it in DataStage?

Indicating on the Input link to the Aggregator that the data are sorted does NOT sort the data! This has caught others in the past. What's happening if you indicate that data are sorted is that you are asserting to the Aggregator stage that the data are indeed already sorted as indicated, allowing i...

If I were selling Oracle licences I'd be encouraging folks to use as many connections as possible! My normal practice is to use as few connections as possible, mainly to preserve licence seats rather than any fear of overwhelming the database server; any serious updating is done via a bulk loader.

I have created rule-based ETL using DataStage, however it's an entirely different model from yours in that mine was table-based rather than object-based. That said, I'm sure it could be done, but not via stored procedures. Instead, you would need a C-callable wrapper to the objects which you would c...

Not unless you provide an expression or a quoted string as the third argument, for example Trim(string, ",", "A"). However, the Trim function can only remove occurrences of one character, to remove six would require six applications of the Trim function. It is not possible to provide a general solut...

Yes, they're on the target side. You can use one stage or two to connect to Oracle. The links are handling disjoint sets of data; rows to be inserted (because they do not yet exist in the target database) on one link, and rows to be updated (because they do already exist in the target database) on t...

What do you mean by "project got corrupted"? This doesn't just happen. How did it happen? Most importantly, what are you doing to prevent it happening again?

The runtime library (ARDTLIB) is installed on your mainframe. It delivers the functions that are called by the DataStage jobs that were created by DS390.

kiran_kom wrote:There is a bug in DS windows that causes it to crash if you are using lots of hash file stages at the same time.

Can you please elaborate, ideally providing a reference to the support case number? Or is it just that you didn't set the T30FILE tunable large enough?

It's all about the code set. In ASCII, "a" > "0", hence lower case alphabetic characters meet your first test. Check out the appendix in the BASIC manual to determine the order of ASCII characters. Craig took a guess at your requirement, which may or not be correct. Can you state your requirement in...