ca.portal.admin

DB Procedure

Discussion created by ca.portal.admin on Nov 1, 2006
Hello listers.

Does anyone have a sample database procedure that adds a userid and
date/time stamp to a record that you would be willing to share?

Dan Hall
GE
Capital Solutions
Danbury, CT

T 513.217.5060
E dan.hall@ge.com
http://www.ge.com/capitalsolutions/
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
DB Procedure
"Hi Dan,

R16 SP4 adds the User Id to the Journal BEGN records but if this is
for an Audit trail for
Sarbanes-Oxley or just your Auditors, having only the User Id may not
be enough. You
may want additional information such as Terminal Id, etc. which we
capture by adding a
USER record in the Journal with EXIT 14.

Feel free to contact me directly if you would like the EXIT and info
on how we report on it.

John Abell
International Software Products

This email may contain confidential and privileged material for the
sole use of the intended recipient(s). Any review, use, retention,
distribution or disclosure by others is strictly prohibited. If you
are not the intended recipient (or authorized to receive on behalf of
the named recipient), please contact the sender by reply email and
delete all copies of this message. Also, email is susceptible to data
corruption, interception, tampering, unauthorized amendment and
viruses. We only send and receive emails on the basis that we are not
liable for any such corruption, interception, tampering, amendment or
viruses or any consequence thereof.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: DB Procedure
"I would like to thank everyone who replied. Within minutes I had 2
sample programs and offers of others.

The people on this list make it great!

Dan Hall
GE
Capital Solutions
Danbury, CT

T 513.217.5060
E dan.hall@ge.com
http://www.ge.com/capitalsolutions/
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: DB Procedure
"Hall, Dan (GE Comm Fin) wrote:
I would like to thank everyone who replied. Within minutes I had 2
sample programs and offers of others.

The people on this list make it great!

Dan Hall
GE
Capital Solutions
Danbury, CT

T 513.217.5060
E dan.hall@ge.com
http://www.ge.com/capitalsolutions/





Dan,

Can you share those programs?

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








Normal

Normal
Map help text modules
"We have several map help text modules that are currently in use. We've
determined that when we generate a map, the 'last updated' date for the
associated help module 'program' in the IDD gets updated. We recently
did an implementation where several maps were generated. It was later
found that the 'last updated' date on a help module was updated;
however, the map that uses the help module was not one of those
generated. (At least, none of the 'last updated' dates associated with
the map itself changed). I have tried to determine if there are any
other maps that use this help module. I've tried obtaining the
MODULE-067 record for the help module, and walking all of the MODMAP-195
records associated to it to see what MAP-098 records own them, but the
only occurrence was the map that I already know uses it. I also ran
DREPORT 018 to no avail.

Because of SOX constraints, if any entities show up in the IDD after an
implementation with changed 'last updated' dates that were not on our
implementation list, we must investigate. So we'd like to know what was
done to cause this help module to be updated.

Any information, thoughts, or suggestions would be most welcome.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
SP4
"Hi all,

How confident is IDMS 16 SP4 ? Have you already put it in production ?

Many thanks,
Rene.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Bogus User Set Error from DB AUDIT
"We are at release 12.01 (9809) and getting a b
Hail, Listers:

We are at release 12.01 (9809) and getting a bogus user set error in DB AUDIT. The audit shows no pointer errors; but, 1 user set with 70 out of sequence sort keys. I've checked the set in question using DMLO (thankfully, it's quite short) and there is no problem with the sequence. Do you all know of this being a problem with DB AUDIT? Is there something I'm missing that could account for what appears to be a red herring output from the audit?

Thanks,

Roger C. Lawrence
Database Administrator
Seminole Electric Cooperative, Inc.
Tampa, Fl.
813.739.1518

_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

** NOTICE **
This e-mail message, including any attachments, is for the sole use of the intended
recipient(s) and may contain confidential, proprietary and privileged information.
Any un-authorized review, copying, use, disclosure, or distribution is prohibited.
If you are not the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message.
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

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








Normal

Normal
Re: Bogus User Set Error from DB AUDIT
"Roger,
Do you have any FILLER in the sort keys? If so, is it consistent? All
spaces, all low values, etc...? Are you using the exact same
DMCL/SCHEMA/SUBSCHEMA combination in both DB AUDIT and DMLO?

These are the only things I can think of at this time of the morning...


Dan Hall
GE
Capital Solutions
Danbury, CT

T 513.217.5060
E dan.hall@ge.com
http://www.ge.com/capitalsolutions/

Outcomes