ca.portal.admin

Question about IDMS record ids

Discussion created by ca.portal.admin on Mar 20, 2009
Latest reply on Mar 21, 2009 by ca.portal.admin
I am having a problem with record ids not matching from one CV to
another. I have some developers that want to copy a lot of data from
one CV to another and there are a lot of different records involved.
The IDMS record IDS do not match so after they copy the data their
applications are abending. Can I change the record ids to match, even
if they might duplicate another record id on the CV? I seem to remember
years ago running an IDMS job or utility that just printed out the
record name with the record id, but I can't seem to locate it now. =20

TIA,
Colette
"
IDMS 3rd-party providers forum
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP
IDMSVENDOR-L@LISTSERV.IUASSN.COM
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Question about IDMS record ids
"This OLQ snippit should do the trick (make sure you are pointing to the
correct dictionary.)

SELECT 'S-010'.'S-NAM-010' 'SRCD-113'.'SR-ID-113'
'RCDSYN-079'.'RSYN-NAME-0
FROM 'S-010', 'SRCD-113', 'RCDSYN-079' WHERE ('S-SRCD' AND
'RCDSYN-SRCD')
Additional Selection Criteria: (S-010.S-NAM-010 = 'MMVCSCHM') where
MMVCSCHM is your schema name.

Dick

Richard Pierce
(617) 973-8911
richard.pierce@state.ma.us

Outcomes