DSXchange

U did not ask the question. The second person personal pronoun in English is spelled "you", not "u". Please maintain a professional standard of English on DSXchange, because even good English is difficult enough for non-native speakers, and also because DSXchange is not an SMS-en...

Are all required services running - Information Server, WebSphere Application Server and DataStage Server ?

First point: this is an alert message and your job still finishes successfully. The alert message signals that you may either want to change aggregation method from hash table to sort, or that you may want to tune the buffering used for the hash table. Notice that the message refers to the number of...

Has the total load on the system been increasing commensurately over time with the degradation you have been observing?

Sure, but the rest of the world also likes taking a dig at the Untied States.

The whole world (almost) is ahead of the USA (in so many ways), and most of us can see beyond the borders of that country.

Your post is timed 2:30pm on April 1st in my current time zone.

No. You have the UniVerse SQL Reference Guide. UniVerse/SQL supports compiled UniVerse BASIC expressions on the command line instead. And, by the way, all identifiers are case-sensitive. SELECT EVAL "FIELD('Server|Mainframe|Sequence|Parallel','|',JOBTYPE,1)" AS JOB_TYPE FMT '10L' COL.HDG '...

In general I don't bother, but use the DataStage API to get what I need.

This is even more relevant in version 8, because the metadata delivery service knows where the metadata reside, and I probably don't.

1. Empty is not the same as null or unassigned. What you have is OK for empty, but the function should return null if any of its arguments is null or in an unassigned state. 3. Open your DataStage BASIC manual and search for "truncated". You'll find that this is documented behaviour for ma...

The full structure of DS_JOBS can be had by getting its metadata. Alas you are blocked from importing its table definition into DataStage. The column names can be had with the command LIST.DICT DS_JOBS Note that this is not an SQL statement and so lacks a trailing semi-colon. None of the Repository ...

Has anyone had experience using DataStage to prepare inputs to the Gateway Pack used for loading data into Odyssey Triple'A? The Gateway Pack provides a mechanism for importing data into the Triple'A database from XML data structures, which are comprehensively describled in XSD files provided by Ody...

In Server jobs' Sequential File stage the only options are DOS-style, UNIX-style and None.

In Parallel jobs' Sequential File stage you can change the record delimiter.

1. Any routine you write for others to use should explicitly test for and handle (usually by returning null, maybe throwing a warning) any unassigned or null input arguments - use UnAssigned() and IsNull() functions to test these. 2. There is no need for a DEFFUN declaration since this routine does ...

Armonk, NY: April 1, 2009 IBM (NYSE:IBM) has announced a new Windows-only version of Information Server for the Windows RG operating system. The version number for this release is to be 8.1rg. It was not made clear whether future versions would ship for this operating system without a special versio...

I already have such a routine, called FinalDelimitedSubstring. You get it as a bonus when you download my date routines