DSXchange

Your steps 1 through 3 can be summarised as "get ALL the records".

Use Administrator client. On the General tab of project properties there's an "Environment..." button. Go there.

I don't think that's a very good value for the transport default block size. I counsel further research before embarking upon this change.

Someone may have been "tidying up" your resource disks, or you have a permissions problem.

No idea, because I have no idea what demands your particular jobs place on the server(s). You can measure this. I cannot.

What are you supposed to get from these inputs? On what base date are your allegedly Julian dates based? On what base date is the Julian day used by DataStage based (it's in the manual)? I suspect yours is different.

Step 1 is very straightforward. Generate the current date (CurrentDate() function) in a single generated row and use user-defined SQL to invoke the NEXTVAL property of the sequence. Step 2 is likewise very simple; use that SQL to retrieve the CURRVAL property and park it somewhere (a file or the job...

If there were, they'd be posted.

There is no logical limitation on the number of different invocation IDs.

Obviously there is a physical limitation deriving from the capacity of the server(s) on which they are running.

Column names are link properties and so exist in records in DS_JOBOBJECTS whose DSRID value is of the form J\xxx\VnSmPk. These records are differently structured, depending on what kind of stage they are attached to. But you could construct a query constrained on WHERE EVAL "@RECORD" LIKE ...

Try qualifying the table name with its schema (owner) name.

The Format properties of the Sequential File stage is where you specify a fixed width file format. The easiest way to learn what to do is to import the "table definition" for a fixed-width file, and look at what gets stored. Clicking the "Sync parallel" button before you inspect ...

The Format properties of the Sequential File stage is where you specify a fixed width file format.

Whatever your job puts into the user status area.

Not this side of November 2011.

Not this side of November 2011.