Our super-COBOL-expert people said we'd have to write custom COBOL to do each query, since the VSAM's are indexed only on the "primary key," like DB_File's, and we need to query against any "key" in the table.

We did look into doing a retrieval by FTP but ran into the asynch notify "problem," which we "solved" (on paper) by passing a "job completed code" to the COBOL driver when we began the query, and have it "hit" a TCP port back on our side with this code to indicate completion.


Unix: EBCDIC structured data
  JOB-ID PIC     XXXXXXXXXXXXXXXX
  SUB-DATE-TIME  9999999999999999
   SUB-DATE      99999999
    SUB-DATE-YR  9999
    SUB-DATE-MO      99
    SUB-DATE-DY        99
   SUB-TIME              99999999
    SUB-TIME-H           99
    SUB-TIME-M             99
    SUB-TIME-S               99
    SUB-TIME-CS                99
  REPLY-IP       99999999999999999
  REPLY-IP-H1    999
  REPLY-IP-H2       999
  REPLY-IP-H3          999
  REPLY-IP-H4             999
  REPLY-IP-PORT              99999
  QUERY-1ST-COL  999
  QUERY-LAST-COL 999
   ... yadda, yadda ...

[download]

Really interesting trying to express TCP streams in fixed-length fields like this. Very similar concepts to C's "union"s or "struct"s; but no binary data, because (many/most) interfaces will mangle anything outside of the basic EBCDIC printable character-set. (We had to use "special" functions just to preserve lowercase letters. God only knows what happens to Iñigo and Réné as they go through the mangler...

Unfortunately, the contract was yanked at the last minute by the agency offering it. Apparently they thought this entire project would take 900 man-hours to complete and were a mite surprised at a 7-digit bid.

Thanks to everyone for your contributions, though!

In reply to Re: Re: Giant proxy DBD for multiple databases by baku
in thread Giant proxy DBD for multiple databases by baku

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.