DSXchange

We're all dating ourselves here. Aren't too many of us around who can still "read" hex, let alone do calculations on it or immediately recognize a zone decimal from a packed decimal from an integer... (and so on)... :) Sigh. A lost art. Ernie Take heart, Ernie. My IT education sources (he...

In the old days of assmebler dumps, we mainframers would flinch every time we saw a SOC7 error, which usually happens when our code tries to divide by zero (It's not my fault! It's the data!) I coworker just this morning told the story of when he asked "What's a SOC4?" His mentor didn't mi...

In your file stage, the link properties Format tab (whether Input or Output): clear all attributes, right click on "Record level", open the "Format as" sub-menu and click on "Mainframe (COBOL)". The common default format properties for an EBCDIC flat file will be filled...

In my case, because DataStage is one of about 6 different code execution platforms that have to run in a unified schedule. We have batch schedules that run from z/OS to Unix and back, Unix to Windows and back, etc. It's easy to train an operator in Control-M and be done with it. It's much more diffi...

Hi Ernie. Before I forget again, thank you very much for your input on this. We have a fairly well-defined division of work here. Our business clients are all internal, and we have an organized (always use that word carefully) liaison for requirements and testing called the business system analyst (...

Hi Franklin... It would be interesting to know your site's goals. Is it for inter-dependencies between the offerings? Parsing of actual source code? Or just identification of it? The lazy answer is all-of-the-above. Our shop covers so much it would take me another 30 mintues to list everything. The...

A DSXchange file upload was just brought to my attention: http://www.dsxchange.net/uploads/Impact_Analysis_for_DataStage_by_SMART_TS.pdf We are preparing to migrate to 8.5 from 7.5, and 8x has a "new" format called ISX. I don't know anything about it personally, but I've been prompted to a...

The one concept not mentioned yet is reusability. I have a small app (that will quadruple in size by the time we're done) that has the identical initial input stage for every job. It's paramaterized according to the source data configuration (z/OS mainframe datasets generated by Cobol modules). Afte...

Being a bit better rested, and paying close attention to the use of the "reply to topic" button :wink: I must point out that my PIC reference was an example, not the only possible PIC. I think we'd all be busy doing extra coding if PD fields only held four-digit integers. I've been doing m...

I'm sorry, I wasn't paying attention to your name. Of course we had the previous conversation. I'm tired. :? I wonder if the mainframe OS might have something to do with this. There are as many "flavors" of EBCDIC as there are ASCII, and more than one way to store data. The one thing I'm s...

ray.wurlod wrote:Once you get to version 8, such tools are directly available in DataStage.

That's good to know. The part I didn't tell you is that our shop wants a one-stop place for all of our code, mainframe, browser, various flavors of SQL and DataStage.

...but when I look at mainframe, negative values show "D" in last nibble which is good but positive values show "C" and I want "F" at the end to match current process. Any suggestion what changes do i have to make to ge desired output? A review of the current process i...

We are going to do an evaluation of this tool, briefly and rather inadequately described at http://www.in-com.com/Products/tabid/62/Default.aspx . IN-COM claims built-in support for DS code. I request opinions about this tool from any source and any level of exposure to it, even rumors if you have t...

http://publibfp.boulder.ibm.com/epubs/pdf/c1899472.pdf Gregg, thanks for posting that link. Question for which I'm looking for the briefest answer (I'll do my own detail work): I began using the XML stages under 7.5.2 recently. Is there a highest-level view of changes from that to 8.5? My shop is n...

You're welcome. I try to keep aware that people from many different cultures read here. I think your understanding is correct. I just want to be sure of one thing for you: your char(5) values will display as decimal(6,0) out of the packed decimal attribute. You should not have to do any zero-padding...