ca.portal.admin

[IDMS-L] Simple Question

Discussion created by ca.portal.admin on Feb 11, 2005
What is the Latest/Last service pack for IDMS/DB, rel. 14.1?

Thanks!
Mary Benson
Tufts. Univ.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Simple Question
"What is the Latest/Last service pack for IDMS/DB, rel. 14.1?

Thanks!
Mary Benson
Tufts. Univ.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: [IDMSVENDOR-L] Database Compare Utilities - Help
"then how about looking at the journal files?


Chris Hoelscher
IDMS & DB2 Database Administrator
Humana Inc
502-580-2538
choelscher@humana.com





The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: [IDMSVENDOR-L] Database Compare Utilities - Help
"Chris,

Thanks, as always. Unfortunately, these are big, complex databases, so we
need something more focused on only what has changed. Trawling a whole
database would take too long.

Linda

-----Original Message-----
From: IDMS Public Discussion Forum [mailTo:IDMS-L@LISTSERV.IUASSN.COM] On
Behalf Of Chris Hoelscher
Sent: Thursday, February 10, 2005 10:17 AM
To: IDMS-L@LISTSERV.IUASSN.COM
Subject: Re: [IDMSVENDOR-L] Database Compare Utilities - Help

Q. We have an urgent need for a database compare utility that can analyze
the
differences between databases after online and batch updates. Does anyone
know of anything?

A. this may be over-simple - but write a culprit to walk whatever path and
dump the data to a flat file - run before and after the updates, and then
write another culprir or use super-compare to compare the results.

not glamorous, but it would get the job done



Chris Hoelscher
IDMS & DB2 Database Administrator
Humana Inc
502-580-2538
choelscher@humana.com





The information transmitted is intended only for the person or entity to
which it is addressed and may contain CONFIDENTIAL material. If you receive
this material/information in error, please contact the sender and delete or
destroy the material/information.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Changing binary zeroes to comp-3 on database record
"I disagree. The most efficient method would be a database procedure to
be called at restructure time mentioned in an earlier post. The DB
procedure program could check for the ""bad"" data and only change ""bad""
to ""good"". The database procedure should be written in assembler but if
you insist on writing it in COBOL make sure to link it with the RTERUES
option set in the IGYOPT macro (this applies only to COBOL II, I don't
know how LE COBOL works). You need to use this option with COBOL
database procedures, otherwise COBOL will try to initialize the COBOL
environment every time it is called. If anyone needs the macro syntax,
reply to me directly and I will be happy to send it to you.

Another option to consider is my favorite program DEMI/DB from ISP,
which allows you to extract, update or import data into and out of IDMS
databases.


Dan Miley
Dan.l.miley@lmco.com
Lockheed Martin

Outcomes