DSXchange

It can not be done within the job - you can only set parameter values prior to running the job. Therefore you need to create a job sequence (or job control code, if that's your thing). This can run one job - possibly a server job - to obtain the maximum value and store it somewhere (or load it into ...

Quite a few sites of which I am aware use dscmdexport from a BAT file to take an export of their projects. This can be automated through the AT scheduler.

That's a strange response in the server forum!

Help About in any client. You must have 7.5x2. This is the only version that supports parallel execution. Since you mention 7.5.1, you clearly don't have the correct version for compiling/running parallel jobs on Windows. You can design parallel jobs on Windows at other 7.x releases, but you can no...

This site has an unusually diligent webmaster (Walter Hardeman), who doesn't get nearly as much praise as he deserves.

... but does this user have the requisite SELECT privilege on the system tables that are used to verify that the table and/or column names used in the INSERT statement are correct? It appears, from reading the error message, that it might be the case that the user lacks these privileges. The error m...

There are too many (hardware) variables that would affect such an intepretation. You would be better off compiling the COBOL (DataStage has generated JCL both to compile and to run), and analyzing the number of generated machine instructions using your particular mainframe's tools. Whether you can e...

There are no data types within DataStage server jobs. Therefore, if you have an ISO 8601 timestamp, you can simply take the leftmost 10 characters to yield the date portion: Left(TheTimestamp,10) If you require the DataStage internal format of a date, simply apply an Iconv() function, with seconds a...

AT executed alone will show you the queue. You can redirect this to a file.
In a DOS shell:

You could edit this to chop out everything but the times and commands, resulting in a BAT file (if done right).

Welcome aboard. :D

The answer is no to both questions.

One *could* hack the Repository but, ultimately, this would be self-defeating; the Repository structure is replaced completely in the next ("Hawk") version of DataStage, due out later this year.

Welcome aboard. :D A job sequence is the best way. A StartLoop activity can set up a "list of things" loop based on a regular expression. Pre-loop activity ----> StartLoop ----> Within-loop activities ----> EndLoop ----> Post-loop activity ^ | | | +-------------------------------------------------+

For completeness only, GROUPSTORE and FIELDSTORE are synonyms.

Check that you have write permission in the project directory. DS_METATEMP is a temporary location used during the import metadata process; it is created and deleted automatically. But if you don't have write permission, it can not be created.

Let's wait for the original poster to get back. I have successfully installed DataStage (version 7.5x2) on Windows XP (Professional) sp2, but did not experience this problem. I was logged in as the local Administrator.

Dynamic can be done, through the "indirect call" mechanism that you can find in the DataStage BASIC manuals (the CALL @name syntax). The default, mainly for the reason you wanted to use it, is static. Further, after the first invocation of the function, which loads it into virtual memory, that memor...