Home · Articles · Downloads · Hobby Wear · Forums · Web Links · News CategoriesWednesday, January 23, 2019
Navigation
Home
Articles
Downloads
Hobby Wear
FAQ
Forums
Web Links
News Categories
Contact Us
Photo Gallery
OpenVMS Bigot
Search
Users Online
Guests Online: 4
No Members Online

Registered Members: 7,250
Newest Member: decourl
Sponsors
Island Computer
View Thread
OpenVMS Hobbyist Program | VAX Systems Forums | VAX Software Forum
Author Removing data from ISAM file sin bulk
steg0010
Member

Posts: 2
Joined: 29.11.12
Posted on November 29 2012 01:57
Hi,

What I'm wanting to do is append multiple ISAM files together, but I'm only interested in certain fields. Together the files consist of about 10,000,000 records so I'd prefer it if I didn't have to perform a whole load of IO if possible.

I'd like the output to consist of particular fields from each ISAM, along with the directory the original ISAM came from.

Basically wondering if there's a nice little tool to use to do this quickly that doesn't use too much disk space, as that is fairly limited.

Any Ideas would be great.

Cheers,
Ste
Author RE: Removing data from ISAM file sin bulk
somersdave
Member

Posts: 63
Location: bristol,UK
Joined: 23.03.07
Posted on November 30 2012 08:35
About 10 years since I did anything with ISAM files but I don't think the DCL utility 'APPEND' will be of much use because you want to select certain fields.

Perhaps C or C++ have similar file handling facilities but DEC Fortran was the language of choice (people might disagree) that 'went with' with VMS from the early days - so I'd write a Fortran Program, opening the 'INDEXED' Input files 'READONLY' and the output file with the 'APPEND' attribute, reading the input records and writing out the new data records. (the language user and reference manuals are online and there are probably some example programs)

It would probably wise to make data backups (somewhere) before starting.

Sorry to be a bit vague but I'd need try 'things' to re-familiarize.
Author RE: Removing data from ISAM file sin bulk
steg0010
Member

Posts: 2
Joined: 29.11.12
Posted on December 01 2012 10:11
Hi somersdave,

Thank you for your reply. This project has been moved to somebody else now as I have other more urgent tasks to be getting on with; however, I will inform my colleagues of your advice. If I have any follow up questions I will be sure to return and if we happen to find a solution that I feel would be useful to anybody attempting a similar task I will post it on here.

Thanks again,
Ste
Author RE: Removing data from ISAM file sin bulk
Bruce Claremont
Member

Posts: 508
Joined: 07.01.10
Posted on December 01 2012 17:43
Suggest you hire Hein van den Huevel. He'll write you something clever in Perl.
Jump to Forum:
Login
Username

Password



Not a member yet?
Click here to register.

Forgotten your password?
Request a new one here.
Member Poll
Are you going to OpenVMS Boot Camp 2016?

Yes

No

You must login to vote.
Shoutbox
You must login to post a message.

jiml
November 09 2018
Thank you , Malmberg ! Exactly what I was hoping for . Reset key & all is well . JImL

malmberg
November 09 2018
Eisner was upgraded to the current Multinet Release. As part of that a new host key was generated. The old key was incompatible with newer Linux.

jiml
November 02 2018
ssh to eisner is now giving (on linux) "WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED!" , Has the server key in fact changed ?

malmberg
June 26 2018
https://www.openvmshobbyi
st.com/forum/viewthread.p
hp?forum_id=10&thread_id=
2363


bhamakripa
June 24 2018
I am trying OpenVMS via SIMH. Need to get OS binaries for v7.3. Registered here but don't have any membership number yet which is needed to get license. Pls suggest what to do. I hardly know anyth

basilh
June 05 2018
Any other forum members in Perth, Australia?

LouF91
April 05 2018
ah maybe they love that!

malmberg
March 24 2018
Probably. More people hang out on the comp.os.vms newsgroup.

vaxpert
March 23 2018
I have a PE42A and other Alpha system stuff for sale. I'm in So California. Any interest out there?

goodbyespy
February 27 2018
To Prohorenko. Please, visit group OpenVMS in the ok.ru

peteherrera
February 24 2018
How much does it cost to buy a complete OpenVMS hardcopy documentation set of the latest version

prohorenko
February 17 2018
Please help to obtain the license on OpenVMS

malmberg
December 12 2017
HPE only makes the most current version of OpenVMS Alpha / IA64 /VAX available to hobbyists. When I had access to the Alliance 1 program it was the same. No public downloads are allowed by HPE.

nmbonao
December 08 2017
Is anybody knows OpenVMS 8.2 version downloadable version? or CD copy? Thank you very much

aarommes
December 02 2017
Bitcoin and Blockchain enthusiasts ( plus distributed computing ) please connec / reply: http://www.openvmshobbyis
t.com/forum/viewthread.ph
p?forum_id=130&thread_id=
2991


Shoutbox Archive