DSXchange

If I don't have the select privilege, the DRS stage won't work.

I asked whether you had SELECT privilege to the system tables, not to the data tables.
It is the system tables that must be interrogated to return a list of table names, where it appears your problem is occurring.

I agree with Kim, it can be done and is useful for the kind of thing envisaged.

System and File DSNs are preferred. You don't always run jobs under the same ID as the one who created the DSN, so avoid User DSNs.

The maximum hashed file cache size is 1GB (though the GUI's spin button control limits you to 999MB). See dsdskche.pdf. It can not be changed "on the fly" as you seek to do. It's a configuration parameter of the engine itself, as Kim advised. Your only "solution" is to set cache to maximum. Smaller ...

AFAIK there never was an ODBC driver supplied to talk to UniVerse, because DataStage could use BCI/UCI and not need a driver.

IBM do not market a UNIX-based ODBC driver for UniVerse but there are third-party ones out there.

Inspect the JOBCONTROL.H file (in dsinclude directory on server) to learn what the code -8 means with respect to DSGetLinkInfo. (I don't have access to DataStage this week, so can't do it for you.)

I recommend Craig's option 3. It's more cumbersome to code, but makes it totally obvious what's intended, especially if the links are meaningfully captioned. Note that OK, Warning and Failed links all have different colours. OK Job1 ---------> Sequencer -----> NextActivity ---------> (Any) |...

Welcome aboard! :D Hashed file can not be used for BETWEEN or any other kind of lookup apart from key = value. End of story. Search the forum for BETWEEN to see what I mean. The reason is the way hashed files work. The record is found by applying a function to the key value returning the address of ...

To add to Arnd's solution: Modify your jobs so that they extract just one key, whose value is supplied as a job parameter. For example WHERE key = '#keyvalue#' Construct a new job that extracts all the key values, calling UtilityRunJob to run the job sequence containing the original jobs, passing th...

Isn't there a "lite" version of Meta Architect for free? Alas I'm not in a position to check at the moment.

User-defined Environment variables set in Administator are stored in a file called DSParams in the project directory on the server.

Attending the training class will help you a great deal. MetaStage is a sufficiently complex product that a competently guided introduction to it is almost essential.

Over simplified, but close enough for most purposes.

Try not to have the target file in the same folder as the source files.

Or simply speccify type c:\merge\*.txt as the filter in a Sequential File stage.

Provided you've loaded the file's definition from the Repository in all cases (all jobs), you can select the Table Definition in Manager and perform a Usage Analysis there.