IDMS

Re:RE: Computed DBKEY from a SQL Table Procedure

  • 1.  Re:RE: Computed DBKEY from a SQL Table Procedure

    Posted Jun 27, 2007 05:58 AM
    Linda,

    Thanks for your TRUNC(BIN) suggestion, it work liked a charm. Did the CA
    folks come up with that one? I would be interested in seeing your
    alternate algorithm. We just subtracted the computed line number from
    1000 and that seemed to be correct for all values. What has made this
    issue doubly frustrating is we were never able to produce the dump my
    tech support wanted and he wasn't aware of known problems with Table
    Procedures.

    Thanks again,

    Joe S Cates, Database Analyst II
    Information and Organizational Systems
    Database Management/Unix Administration
    Montgomery County Public Schools
    Rockville, MD 20850
    301-279-3697
    joe_cates@mcpsmd.org