ca.portal.admin

encryption in idms

Discussion created by ca.portal.admin on Jan 12, 2006
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.

Outcomes