Journal extracts to flat files

[ca.portal.admin]

Our satellite systems groups are interested in obtaining extracts from
the IDMS database of added/changed/deleted data to apply to their
relational databases. We have explored several commercial solutions
most of which rely on extracting the IDMS journals.

They now want to inquire whether it is possible to roll our own, and
extract the journals ourselves. I understand the complexity of this
operation. Has anybody already built such a beast, and if so, would you
be willing to share your solution? (No need for the commercial vendors
to reply - we have probably already talked to you.)

Thanks,

Jim Ritterbusch Mail:
GE Capital Solutions 10 Riverview Dr.
101 East Ridge Danbury, CT 06811

T 203.749.3585 F 203.749.4016
D 8*662.3585 E [e-mail]
http://www.ge.com/capitalsolutions/
"
IDMS Public Discussion Forum
[e-mail]
SMTP
[e-mail]
[e-mail]
SMTP








Normal

Normal
Obtain within area for records stored as direct
"How does the IDMS algorithm work when you want to do an area sweep on a
direct record. This is the only record in the area and is stored as direct.

The logic I am using is

obtain first
process
erase record
obtain first
process
erase record
....

Is there a better way to do this?

Thanks
Chander.
"
IDMS Public Discussion Forum
[e-mail]
SMTP
[e-mail]
[e-mail]
SMTP








Normal

Normal
Re: [IDMSVENDOR-L] Reminder: IUA Board of Directors - Elections
"Bob,
i cannot speak for anyone else, but when I sign in to IUASSN.ORG i do not
see a members-only area ... since I was a full member prior to Jan 1 2006,
should I have been rolled in as a full member when the web site was updated
to no longer require dues?




We are in the process  of changing the website, and will announce at a later date when you will be
able to register for 2006 membership

this is from a nov 2005 NEWS item on IUASSN.ORG ...






This is Chris Hoelscher and I approved this message!

Chris Hoelscher
Senior IDMS & DB2 Database Administrator
Humana Inc
502-476-2538
[e-mail]



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
[e-mail]
SMTP
[e-mail]
[e-mail]
SMTP








Normal

Normal
Re: Obtain within area for records stored as direct
"What your logic is doing is always start with the first page of the area and read every page until it finds a record. You're not taking advantage of Area Currency. Keep the first OBTAIN FIRST to establish currency in the area and then loop through doing OBTAIN NEXT IN AREA.

Bob Wiklund
Tiburon Technologies
623 594-6022

________________________________

From: IDMS 3rd-party providers forum on behalf of Natarajan, Chander [IDR]
Sent: Mon 4/9/2007 9:56 AM
To: [e-mail]
Subject: Obtain within area for records stored as direct



How does the IDMS algorithm work when you want to do an area sweep on a
direct record. This is the only record in the area and is stored as direct.

The logic I am using is

obtain first
process
erase record
obtain first
process
erase record
....

Is there a better way to do this?

Thanks
Chander.

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
"
IDMS Public Discussion Forum
[e-mail]
SMTP
[e-mail]
[e-mail]
SMTP








Normal

Normal
Re: Reminder: IUA Board of Directors - Elections
"Because of the outage we had with the website, we were not able to make the membership changes to take out the dues check. We're working on that now. I modified your membership so you should get the members only page now.

If anyone else is having this problem, please contact [e-mail]

Bob Wiklund
Tiburon Technologies
623 594-6022

________________________________

From: IDMS 3rd-party providers forum on behalf of Chris Hoelscher
Sent: Mon 4/9/2007 10:59 AM
To: [e-mail]
Subject: Re: Reminder: IUA Board of Directors - Elections



Bob,
i cannot speak for anyone else, but when I sign in to IUASSN.ORG i do not
see a members-only area ... since I was a full member prior to Jan 1 2006=
,
should I have been rolled in as a full member when the web site was updat=
ed
to no longer require dues?
=20
=20
=20
=20
We are in the process=A0 of changing the website, and will announce at a=
later date when you will be
able to register for 2006 membership =20
=20
this is from a nov 2005 NEWS item on IUASSN.ORG ... =20
=20
=20




This is Chris Hoelscher and I approved this message!

Chris Hoelscher
Senior IDMS & DB2 Database Administrator
Humana Inc
502-476-2538
[e-mail]



The information transmitted is intended only for the person or entity to =
which it is addressed and may contain CONFIDENTIAL material. If you rece=
ive this material/information in error, please contact the sender and del=
ete or destroy the material/information.

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
"
IDMS Public Discussion Forum
[e-mail]
SMTP
[e-mail]
[e-mail]
SMTP








Normal

Normal
Re: Obtain within area for records stored as direct
"As far as I know an Area sweep is an Area sweep regardless of how the
records were stored. I believe IDMS maintains area currency after the
erase.

You should :
Obtain first
Process
Erase
Obtain next
Process
Erase

Obtaining first each time will cause you to do an exponential number of
reads since it will cause IDMS to read starting at the first page every
time. The Obtain first/obtain next will read each page only once.