DSXchange

You can always read a sequential file by defining its "records" (lines) as a single string (VarChar data type). But you will need to know the metadata before you can do anything sensible such as parse the line into individual columns. Were you using a parallel job the metadata can be dynam...

Yes, depending in the job type you have missed RT_BPnnn, RT_BPnnn.O, RT_BPnnn.L, RT_SCnnn (and a couple of others if you use mainframe jobs). But it's not enough simply to delete these components from the operating system. References to them must be removed from the project's vocabulary (VOC) and, p...

Well why didn't you say so?

Read Craig's post carefully. There's no simple view of "the status of all jobs" on the server. You would need to script something to obtain a list of all jobs then loop through these obtaining the status of each. It's easily doable, but no single view exists.

The sequence job properties include four compilation options. One is the ability to add checkpoints so that the sequence can automatically restart from the point of failure. All you need to do is select this option and re-compile. Incidentally, a Sequencer is a component that you can use in a Sequen...

SK1 and ROWGEN start at the same time. SK2 can't start till the first buffer of rows arrives from ROWGEN. Not a coincidence at all.

Pre-extract a list of just the key values from the target table into a Lookup File Set or Data Set, and perform Lookups against that.

Probably easiest to do in Director client (Project > Print > Print to File) with display of categories suppressed. That information is also contained in DS_JOBS and DS_JOBOBJECTS tables; you could create your report from those. SELECT DS_JOBS."NAME", DS_JOBOBJECTS."DESC" FROM DS_...

pavankvk wrote:Any ideas?

See above.

Corporate discounts are available, but the model is for multiple individual memberships from that company's email domain. From memory the discounts kick in at five users.

But even without the discount it's less than 30c (Rs12) per day. A week on DSXchange costs less than a cup of coffee!

Open Director client in Status view. Optionally sort by status. Disable display of Category. Produce a report via Project > Print then choosing Print To File option.

My pet question is the one about strategies for eliminating warnings from job logs. A good answer is to analyse the warning and code to prevent it, for example by explicitly handling data type conversion. A bad answer is to suppress/demote the warnings using message handlers. A more open-ended quest...

Hashed files are not changed in version 8.5. (They carry the same internal version number as in 8.1, which tells us that they are unchanged.)

No and no. For the latter you might build in your own rules and reporting to the job design.

Without it, DSXchange would cease to exist.

Premium memberships are used to fund the hosting and bandwidth charges incurred by DSXchange. Notice the absence of ads? Notice the good signal to noise ratio?

If any warnings/errors are recorded in &PH& they are transferred to the job log as part of finishing the job. If the job aborts, then resetting the job (at least for server jobs and sequences) will move the warnings/errors into the job log. Parallel jobs use a different logging mechanism (th...