DSXchange

Then you need to start your processing by scanning the job log of the master job sequence, then for each "job run requested" follow its tree of control. You can do this iteratively (which I'd recommend) or recursively.

Very few UNIX machines still have that limit these days, unless the Sys Admin chooses not to enable large file support. A Data Set or File Set can employ multiple physical files per processing node, so even a 2GB file size limit is not an obstacle. The largest (theoretical) File Set can have 10,000 ...

Yeah? Well THOSE data (that you posted) certainly aren't fixed width.

Can be done without a routine. Convert(@FM,",",Fmts(Convert(",",@FM,InLink.TheString),"5'#'R")) This converted the comma-delimited string to a dynamic array, applied the Fmts() function to the dynamic array element-by-element, then converted the ...

On the other hand, Data Sets store numbers in binary format, which can be much more compact than storing them as text.

How long is a piece of string?

Complex Flat File stage

Make very sure that the inputs are identically key-partitioned and sorted.

No. View Data always opens with all columns displayed. You can select them after that, but not prior to opening.

For the server Aggregator stage you can form the min and max of character data.

Do you mean dependent at design time (all the jobs that might be run from a job sequence) or dependent at run time (all the jobs that were actually run by the job sequence, depending upon its internal logic)?

I disagree that it has to be done in job control code. You can use DS_JOBS as source (use a Selection to eliminate control records - those that have "/" or "\" as their first character) and create routines to extract the relevant information. Much more GUI.

Is the input date a date or a string? If it's a string, and the parameter is a string, you can compare them directly. If one is a date and the other is a string, then you need to convert one or the other so that the data types are compatible for comparison.

Somewhere between zero and infinity. How long it will take really depends on the results of column analysis, especially the frequency distributions. In practice expect hours rather than seconds with this many tables.

Welcome aboard.

This particular forum is for suggestions about the DSXchange site itself. Can you please find a more appropriate forum for your question (use General if nothing else).

During a job run the job status is always Running. In an after-job subroutine you can interrogate the "interim status" - the status with which the job will finish if the after-job subroutine returns normally.