CA IDMS IUA EIUA

encryption in idms

  • 1.  encryption in idms

    Posted 01-12-2006 05:40 AM
    From: ""Asselin, Ray"" <Ray.Asselin@DOWJONES.COM>
    Reply-To: IDMS Public Discussion Forum <IDMS-L@LISTSERV.IUASSN.COM>
    To: IDMS-L@LISTSERV.IUASSN.COM
    Subject: Data Encryption
    Date: Tue, 10 Jan 2006 15:29:22 -0500

    Hello all,

    Can anyone suggest a product or method to encrypt/decrypt data in an
    IDMS db?

    Thanks.
    I can see that this will be the next big thing in databases because of
    HIPPA and SOX. Oracle has recently added encription support in their
    10G release.

    Encription was brought up in this list within the last 3 months. We
    have been using it for over 20 years and after it was brought up on the
    list, I received an email from our original vendor who supplied the
    encription code. We encrypt parts of records and never to keys I
    believe. We don't have the source code which has always been a concern.
    However, the data that is encripted is now old pension systems that is
    read only.

    Lynn Sattler
    Dana Corp

    ************************************************************************
    ********
    This e-mail, and any attachments, is intended solely for use by the
    addressee(s) named above. It may contain the confidential or
    proprietary information of Dana Corporation, its subsidiaries,
    affiliates or business partners. If you are not the intended recipient
    of this e-mail or are an unauthorized recipient of the information, you
    are hereby notified that any dissemination, distribution or copying of
    this e-mail or any attachments, is strictly prohibited. If you have
    received this e-mail in error, please immediately notify the sender by
    reply e-mail and permanently delete the original and any copies or
    printouts.

    Computer viruses can be transmitted via email. The recipient should
    check this e-mail and any attachments for the presence of viruses. Dana
    Corporation accepts no liability for any damage caused by any virus
    transmitted by this e-mail.

    English, Francais, Espanol, Deutsch, Italiano, Portugues:
    http://www.dana.com/overview/EmailDisclaimer.shtm

    ************************************************************************
    ********

    "
    IDMS Public Discussion Forum
    IDMS-L@LISTSERV.IUASSN.COM
    SMTP
    IDMS-L@LISTSERV.IUASSN.COM
    IDMS-L@LISTSERV.IUASSN.COM
    SMTP








    Normal

    Normal
    Re: encryption in idms
    "Thanks to everyone who responded to my inquiry about encryption. The
    help is appreciated.

    Ray Asselin

    "
    IDMS Public Discussion Forum
    IDMS-L@LISTSERV.IUASSN.COM
    SMTP
    IDMS-L@LISTSERV.IUASSN.COM
    IDMS-L@LISTSERV.IUASSN.COM
    SMTP








    Normal

    Normal
    IDMS SQL Command Alert
    "IDMS SQL Users,

    Is this something that a syntax checker could stop, or is there any way to guard against this type of behavior?

    One of our programmers recently issued a SELECT command in OCF with a syntactical error that caused the task to loop. Unfortunately, the command was issued near quitting time, so the programmer closed his Tn3270 session and left for the day. The task finally abended when IDMS was cycled 11 hours later. By that time it had used over 4 hours of CPU time. We have told the application staff to be more careful. But is there anything CA can do, or we can do to prevent this? (Besides take away their OCF access!)


    The intended command was:

    SELECT *
    FROM SCHEMA.OMBASEREC, SCHEMA.OMCUSTREC
    WHERE CUST_OM_SEC_CODE = 'DD'
    AND ""OMBASE-CUST""

    The errant command left off the ""AND OMBASE-CUST"" extension.


    The set is defined as:

    SET NAME IS OMBASE-CUST
    ORDER IS SORTED
    MODE IS CHAIN LINKED TO PRIOR
    OWNER IS OMBASEREC
    *+           WITHIN AREA OMBASE-AREA
    NEXT DBKEY POSITION IS 10
    PRIOR DBKEY POSITION IS 11
    MEMBER IS OMCUSTREC
    *+           WITHIN AREA OMINCI-AREA
    NEXT DBKEY POSITION IS 1
    PRIOR DBKEY POSITION IS 2
    LINKED TO OWNER
    OWNER DBKEY POSITION IS 3
    MANDATORY AUTOMATIC
    KEY IS (
    CUST-OM-DATE-GROUP DESCENDING )
    DUPLICATES ARE FIRST
    NATURAL SEQUENCE
    .










    "
    IDMS Public Discussion Forum
    IDMS-L@LISTSERV.IUASSN.COM
    SMTP
    IDMS-L@LISTSERV.IUASSN.COM
    IDMS-L@LISTSERV.IUASSN.COM
    SMTP








    High

    Normal
    Re: IDMS SQL Command Alert
    "Others people have issues with OCF usage also.