DSXchange

This is even cleaner. It uses a mask in the Fmt function to insert the colon characters.

The file dictionary (metadata) for a hashed file is stored in its "file dictionary". You get at this by preceding the hashed file name by the DICT keyword in a query; without the keyword you see the actual data. In UniVerse SQL: SELECT "FIELD", "FIELD.TYPE", "FIELD.DEF"...

With no size, DataStage is trying to get at NUMBER(0) items. If they're integers, Oracle requires NUMBER(38) - not NUMBER(40). Try it with 38 instead of 40.

If you think about it, you cannot calculate median without sorting the data set. You also need the total row count (let's call it N) so that you can determine the (N/2)th position. Slight variations depend on whether N is odd or even, but you can use Int(N/2+1) with no loss of generality. A DataStag...

At a pinch you could enrol on IBM's UniVerse Database Programming class; however only about 60% of that is relevant to DataStage, the remainder dealing with terminal I/O and other user interactions.
But it is scheduled more regularly than Ascential's.

What are reported in the following situations?

(a) importing the table definition through the OCI plug-in, what data types are reported?

(b) do you get the same message from Oracle when using something else such as sqlplus or TOAD?

It now remains only to allocate blame!

When in Designer or Manager invoke Help. Select the topic BASIC Tasks . Drill down from there: Data Formatting Oconv (read it all) (at this point you will have all the codes - follow the hyperlink to each for detailed explanation and examples) In the DataStage BASIC manual read the appendix called "...

Yes there is, though it has no client interface. The name of the table is DS_AUDIT, and it records creation, modification and deletion. I have posted the column names for this table before; search for them. The two you're particularly interested in are PREVDTD and PREVDELETOR. Of course, only the mo...

DSSendMail is merely an interlude to sendmail(), an extremely basic mail client. I believe, to make use of extended functionality, you will need to use a more capable mail client. You are trying to get DataStage functions (and the UNIX function) to perform a task that was not within their design spe...

DS.REINDEX rebuilds secondary key indexes on the Repository tables. It also reports what it has done. You can examine the paragraph using the following command LIST.ITEM VOC 'DS.REINDEX' in which you will see that it's a series of recursive calls each of which builds the indexes on a specific table....

Welcome aboard! :D Can you export the project (or even some of it) from the Manager client? If not, you will begin to suspect that indexing in the DataStage repository has somehow gone awry, and you probably need to fix it. There are two ways: from the Administrator client Command window, execute th...

Ascential have on the books, but not scheduled, a class called Programming with DataStage BASIC . It can be offered on demand, as far as I know. It was most recently revised for version 4.x, but the language hasn't changed that much. UniVerse manuals can be downloaded for no charge from IBM website ...

Welcome aboard! :D In your design, have you changed the name of a link but not changed a derivation that is based on a column from that link? Otherwise, try using Save As to save the job under a different name, and compiling the new version. Any routine with a "DSD." prefix is used internally by Dat...

Try coding without using DATA as a variable name. DATA is a reserved word in DataStage BASIC.