DSXchange

I think that is what is happening in the dsjob command; you will have to use the DS/BASIC calls (or their c equivalents) or some other method in order to retrieve this information.

A Search would have shown a couple of threads that answer this question, including this one.

Edit your IPC stage and increase the buffer size to hold at least one full record.

sendmkpk wrote:... It did not recognize the record

What does that mean?

If you take a server job and run "dsjob -report" on it do you get all the desired values - my point is that since the dsjob command preceded parallel jobs it might not have been retrofitted to retrieve all the information or parallel jobs.

There are so many books out there that you have a large choice. What book to start with depends upon your general IT knowledge and how you prefer to learn. UNIX for Dummies isn't all that bad to get an overview and a start; but if you really wish to understand UNIX I would recommend a more formal ap...

DSN is enough for Excel access.

I don't understand what you mean by it returning a space. You don't need a trim, just try COUNT(r command could be written as:

On your windows platform, quite easily using ODBC and defining a system DSN on your server.

I wonder if the column start and end just point to the expected positions in the cobol copybook. Normally, your start column should be 8 and end column 72 (1-6 for line numbers, column 7 denotes a comment line, 73-80 used for line numbers and the rest can contain FD data. Usually groups start at col...

As Ray said - you are basically correct that the datasets cannot be easily copied. If your APT_CONFIG file settings point to the same absolute paths on both servers then you could copy the data files and the descriptor file across machines. But it is better to dump the dataset into a sequential file...

Have you tried this command on a server job to see if that works - it might be that this is a limitation of the dsjob command line options. Another option might be to use the DS/BASIC functions directly - DSAttachJob(), DSGetJobInfo(), DSGetStageInfo() and DSGetLinkInfo().

Do you still have APT_DISABLE_COMBINATION set to "True"? If that isn't giving you the stage, then you need to make a test copy of the job and remove stages until the error goes away. Perhaps you have a transform stage and are using COL1 in the constraints or stage variable derivations?

Yes, this is probably the reason. I don't have DS available here, but seem to remember that a copy stage doesn't allow renaming columns between input and output. How do you link the two column with different names in the copy stage?

Umm, I would guess you should remove your fixed width setting.