DSXchange

Last question first: a copybook is just the COBOL version of a schema. It's programming code, specifically names of fields and their attributes. The character set is not relevant at that level. James provided a good answer, and this is my two cents about an additional point specific to DataStage. Ma...

The choice between a stage and Unix script is simple: Do you care that you have to land a file on the DS server before transferring it to the mainframe? In general, I don't want extra files that I have to clean up later. That's part personal and part technical (leaving files can be a security risk)....

If you verify that you have all of the following already, then you have a problem other than packed decimal. Good luck. First and most important step: Import the copybook to the table definitions if you haven't already. If you originally set it up manually, at least save it. Open it via Table Defini...

Here is a sample of what we use in the script called by Control-M. It is taken out of context of the whole script with details replaced: CM Command line: DS_ccc_dsjob_run.ksh -d aaa -e bbb -g ccc -p ddd -j %%JOBNAME # Input Parameters: -d <IT Subdivision name>. Required Argument. # -e <DS Environmen...

ray.wurlod wrote:I don't see any representation of the commas in the FD.

Hah. Good catch from my dropped ball.

Freddie, What is the table definition for your "Field A" in each stage up to and including CFF? Is it numeric, decimal or something else? In general, a PIC 9() field is decimal in DataStage, and if you want to move it as a display field you might be missing a DecimalToString() transform. T...

I might need more details to be sure, but it looks like you need to do a two-part read of the COBOL file. 1) Read it as a single-field variable length record. That you have a record-length field could be part of the problem. Usually, a variable length record does not process the record length as an ...

Another way to look at this is the need to count "business" days between dates. The problem, as Ray points to concerning holidays varying between cultures/countries, is how to adjust your calendar from one year to the next. You have two requirements: count the number of non-weekend days be...

chulett wrote:Follow Ernie's advice instead.

I did exactly that, and I had no difficulty getting it to work.

Hello, Manuel. You seem to be having much fun dealing with your mainframe system. :wink: These separators are not being written in the same way in destination. Can you be more specific? Do the characters get dropped, or are they being written as different characters/hex-values? I should warn you tha...

What sort of Warning messages have you found in the Director output? It may be from our style of error handling but I've sometimes found important information in Info messages near the otherwise ambiguous Warning messages.

You're welcome. It's a JCL function, not Cobol. It only needs to be done once -- big assumption: that you will reuse the same dataset name every cycle -- and you will overwrite it every time. The catalog supplies your data control information (DCB or data control block) when the dataset is reference...

Thanks for your valuable input,Frankline Here I am trying to read the cobol file from the UNIX environment using CFF stage in a parallel job. So mainframe OS option is not available with me. You're welcome. Is it possible that CFF is the problem? I have little experience with it, and I'm wondering ...

Does the destination dataset exist in the catalog when you try to transfer data to it, or are you "creating" a new dataset each time? In my experience, FTP Enterprise is weak when it comes to new datasets, and my solution is to initialize the destination with the correct attributes -- espe...

Anayak, There are two considerations here. One is whether you are confident that CFF can handle the input layout as is. The other is how you intend to use the redefined fields. The first important question: What platform are you reading from with CFF? If it is the usual mainframe OS with filehandlin...