Home · Articles · Downloads · Hobby Wear · Forums · Web Links · News CategoriesThursday, March 28, 2024
Navigation
Home
Articles
Downloads
Hobby Wear
FAQ
Forums
Web Links
News Categories
Contact Us
Photo Gallery
OpenVMS Bigot
Search
Users Online
Guests Online: 6
No Members Online

Registered Members: 7,708
Newest Member: nifseg
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: 67
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: 623
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.

malmberg
August 04 2022
No more VAX hobbyist licenses. Community licenses for Alpha/IA64/X86_64 VMS Software Inc. Commercial VMS software licenses for VAX available from HPE.

ozboomer
July 20 2022
Just re-visiting.. No more hobbyist licenses? Is that from vmssoftware.com, no 'community' licenses?

valdirfranco
July 01 2022
No more hobbyist license...sad

mister_wavey
February 12 2022
I recall that the disks failed on the public access VMS systems that included Fafner

parwezw
January 03 2022
Anyone know what happened to FAFNER.DYNDS.ORG? I had a hobbyist account here but can longer access the site.

gtackett
October 27 2021
Make that DECdfs _2.1A_ for Vax

gtackett
October 27 2021
I'm looking for DECdfs V2.4A kit for VAX. Asking here just in case anyone is still listening.

MarkRLV
September 17 2021
At one time, didn't this web site have a job board? I would love to use my legacy skills one last time in my career.

malmberg
January 18 2021
New Hobbyist PAKs for VAX/VMS are no longer available according to reports. Only commercial licenses are reported to be for sale from HPE

dfilip
January 16 2021
Can someone please point me to hobbyist license pak? I'm looking for VAX/VMS 7.1, DECnet Phase IV, and UCX/TCPIP ... have the 7.1 media, need the license paks ... thanks!

Bart
October 16 2020
OpenVMS, and this website!

malmberg
September 05 2020
VSI community non-commercial licenses for AXP/IA64 are available now.

malmberg
September 05 2020
See the forum about licensing. Don't know if HPE hobby licenses still being issued. Commercial licenses still being sold.

silfox70
September 01 2020
I need the license for OpenVMS7.3. Where can I find them?

malmberg
August 29 2020
Eisner, which is currently being moved, got an SSH update and the keys were updated to more modern encryption standards.

Shoutbox Archive