- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - OpenVMS
- >
- Can we convert RMS indexed files to flat files?
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-14-2018 04:06 AM
тАО08-14-2018 04:06 AM
Can we convert RMS indexed files to flat files?
We have requirement to convert RMS indexed files to normal files. we are planning to convert them using COBOL programs. is it possible to convert them using any COM utilitises (COMMAND PROCEDURE) or FDL?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-14-2018 09:27 AM
тАО08-14-2018 09:27 AM
Re: Can we convert RMS indexed files to flat files?
> We have requirement to convert RMS indexed files to normal
> files. [...]
Define "normal". What's not "normal" about an indexed file?
Portable?
> [...] is it possible to convert them using any COM
> utilitises (COMMAND PROCEDURE) or FDL?
help convert [ file [ /fdl ] ]
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-14-2018 09:40 AM
тАО08-14-2018 09:40 AM
Re: Can we convert RMS indexed files to flat files?
Just about any record-orient program will 'convert' indexed files to flat files
1) type/out=flat.dat indexed.dat
2) search/out=flat.dat indexed.dat "" [/form=xxx]
3) SORT...
The easiest/cleanest is
4) CONVERT/STAT/FDL=NL: indexed.dat flat.dat
You may still need a (Cobol or otherwise) program to convert non-character fields like OpenVMS binary DATEs, Packed-Decimal numbers, Integer numbers, and so on.
You may want to use a professional tool like CONNX or Attunity CONNECT if you have many files, many fields to 'flatten'
Hein
(Attunity.com)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-24-2018 07:01 AM
тАО08-24-2018 07:01 AM
Re: Can we convert RMS indexed files to flat files?
Thanks Hein. we have RMS indexed files with COMP-2 (D-floating) and signed longwords in unreadable format data. we are trying achieve thru COBOL programs. we had issues in converting COMP-2 data to readable data and we have multiple keys (example: we have 3 keys and again each key has multiple columns). in COBOl program file declaration and FD defination, open and read i am facing issues.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-24-2018 12:59 PM
тАО08-24-2018 12:59 PM
Re: Can we convert RMS indexed files to flat files?
There is no standard tool or utility provided with OpenVMS to interpret data in files by datatype.
You'll need to use a programming language or a commercial tool with record-layout and/or data dictionary support
If you have Cobol, just use it. Read 'native' source file; MOVE fields to DISPLAY type target file; using conversion options as needed; write target file.
End user tools like Datatrieve, Powerhouse, ., and such, with CDD support as needed and give you direct access.
Infrastructure tools like CONNX, CONNECT (from Attunity.com, where I work) and many others can give you ODBC and JDBC access to directly pull the data.
I'm sure there are good Freeware tools as well. DIX comes to mind.
SMOP!
Hein