DSXchange

DataStage reports all messages generated by database servers. DataStage is not geared to work to non-transactional databases (except UniVerse and UniData), so it sends a COMMIT. Or more than one. IDS responds to COMMIT on a non-logging database with the indicated message. Can you suggest a generic s...

Since you're in the beginning of your project, can I also recommend that you plan what things ought to be parameterized? Job parameters offer insurance against values that may change over time, and values that may be different in development, testing and production environments. For example: authent...

Over the years I have created a number of these. Essentially they are a five-column table. There is one row for each table.column in the target (for example the tables in the star schema in a data warehouse). The first two columns are the table name and column name from the target. The next two colu...

Stephan is correct.
The list of DSNs you see in the ODBC stage is obtained from the uvodbc.config file in the project directory on the server. This can be edited manually, but is populated when you import an ODBC table definition.

I think Stephan's is the wisest course. You can create a UniVerse table with an automatic key as follows (edit the DDL in the UV stage to add the DEFAULT clause on the pkey column): CREATE TABLE tablename ( pkey INTEGER NOT NULL DEFAULT NEXT AVAILABLE, col1 VARCHAR, col2 VARCHAR, col3 INTEGER, c...

No and no. What you might be able to do is to intercept all traffic between your Manager client and server while you're exporting one component. Do this by enabling server-side tracing before opening Manager. Then you could follow the calls to helper subroutines and replicate this in a DataStage BAS...

Well, since we're sharing, here's how Red Brick Warehouse does it. The WHEN clause is used to restrict rows based on display functions such as RANK, NTILE, CUME, MOVINGAVG, MOVINGSUM, RATIOTOREPORT and so on. <pre>SELECT col1, col2, col3 FROM table WHERE any_other_conditions WHEN RANK(expression) <=...

In a server job open the Job Properties window. You can do this in Designer or Manager. On the General tab is a check box labelled Allow Multiple Instance. Check this, then the invocation ID expression will become enabled for that job once it has been re-compiled.

Alas (for your wish), the eight character limit comes from INTEGRITY (and, presumably, from the fact that that product also has to execute on OS/390, where file name components have an eight character limit). It's a given. Remember that there are ex-Vality customers out there, who only use INTEGRITY...

Here's Teej's special server routine. Use the test grid! FUNCTION Teej(Arg1) * Arg1 is ignored. Cmd = "SELECT @ID FROM VOC WHERE TYPE = 'K' AND OP.CODE = 16 FIRST 1 COL.SUP COUNT.SUP;" Call DSExecute("UV", Cmd, Output, Code) Ans = Field(Trim(Trim(Outpu...

The politics at that site may have something to say about "unsupported"!

(This is the way things are in real life folks. DS390 is easy till you need to get authority to compile and run on the mainframe machine!)

Today's word is "exposition", and you've just had an excellent exposition of the issues. It is defintely possible to have DataStage do all these things, but it must be done in a way so that the records are kept in persistent storage (text files or database tables, it doesn't matter).

Since I'd been at Neil's site recently I knew what he wanted, and he expressed it accurately: 4.2 and 6.x. The answer is still NO.
None of this "if you have 7.x" caveat!
Their upgrade from 4.2 is hindered by their running on an old HP machine that - iirc - maxes out at HP-UX 8 or thereabouts.

That's a good answer. As it's a slightly customized approach to what DataStage job sequences do, you may be better off creating custom job control code, in the Job Control tab of a (controlling) job's job parameter window. Use even more parameters. Parameterise the start date (default 1 Jan) and the...

Most vendors' SQL has a pseudo-column for returning the row number. Red Brick Warehouse even has a RANK display function, which would be even easier. Assuming you haven't got Red Brick Warehouse, you can use something like: SELECT col1, col2, col3 FROM (SELECT col1, col2, col3 FROM table ORDER B...