Mainframes, MVS, zOS and Related Languages Support Forums Help & Support Forum for and by Mainframe Users 2013-08-03T08:56:18+00:00 2013-08-03T08:56:18+00:00 2013-08-03T08:56:18+00:00 <![CDATA[Other Databases on zOS. • Re: How can we suppress leading zeroes using NATURAL?]]> Statistics: Posted by Anuj Dhawan — Sat Aug 03, 2013 8:56 am

2013-08-03T04:32:45+00:00 2013-08-03T04:32:45+00:00 <![CDATA[Other Databases on zOS. • Re: How can we suppress leading zeroes using NATURAL?]]> Statistics: Posted by AD991 — Sat Aug 03, 2013 4:32 am

2013-08-01T05:47:48+00:00 2013-08-01T05:47:48+00:00 <![CDATA[Other Databases on zOS. • Re: IDMS Simulator on Windows?]]>
Good Luck! :)

Statistics: Posted by Anuj Dhawan — Thu Aug 01, 2013 5:47 am

2013-07-27T12:59:19+00:00 2013-07-27T12:59:19+00:00 <![CDATA[Other Databases on zOS. • Re: How can we suppress leading zeroes using NATURAL?]]> Statistics: Posted by Anuj Dhawan — Sat Jul 27, 2013 12:59 pm

2013-07-27T10:56:10+00:00 2013-07-27T10:56:10+00:00 <![CDATA[Other Databases on zOS. • How can we suppress leading zeroes using NATURAL?]]>
In my program, I am in need of writing a record counter, but all the leading zeros should be suppressed. How can I do that. Please help.

Statistics: Posted by AD991 — Sat Jul 27, 2013 10:56 am

2013-07-27T06:46:23+00:00 2013-07-27T06:46:23+00:00 <![CDATA[Other Databases on zOS. • Re: IDMS Simulator on Windows?]]> Statistics: Posted by RyanFox — Sat Jul 27, 2013 6:46 am

2013-07-26T12:53:02+00:00 2013-07-26T12:53:02+00:00 <![CDATA[Other Databases on zOS. • Re: We made a Century!!]]> Making Century is a history now -- We made Much More than a Double Century!

Most users ever online was 250 on 26 Jul 2013
script 01:01

What are you waiting for -- come get along with this busy community to clear, debate and discuss your doubts on IBM Mainframes, MVS, zOS and related Languages.

Statistics: Posted by Anuj Dhawan — Fri Jul 26, 2013 12:53 pm

2013-07-26T04:48:11+00:00 2013-07-26T04:48:11+00:00 <![CDATA[Other Databases on zOS. • "Report This Post" is activated.]]>
The "Report This Post Button" can be found as the first button with exclamation sign ("!"), at bottom right of any post. The pictorial representation is shown below:

Statistics: Posted by Anuj Dhawan — Fri Jul 26, 2013 4:48 am

2013-07-24T17:27:26+00:00 2013-07-24T17:27:26+00:00 <![CDATA[Other Databases on zOS. • Re: IDMS Simulator on Windows?]]>
It allowed one to right fully functional dialog, including process control functions like LINK and XCTL, and test and complete ADS based application on the PC. Once development was completed, it could stay on the PC or be migrated to the mainframe, generated and put into production.

However, at the moment - I don't have more information about the product - I'll try to find it soon.

Statistics: Posted by Anuj Dhawan — Wed Jul 24, 2013 5:27 pm

2013-07-24T15:31:49+00:00 2013-07-24T15:31:49+00:00 <![CDATA[Other Databases on zOS. • IDMS Simulator on Windows?]]>
I would like to know if there is any IDMS Software Simulator available for Windows?


Statistics: Posted by RyanFox — Wed Jul 24, 2013 3:31 pm

2013-07-19T19:11:01+00:00 2013-07-19T19:11:01+00:00 <![CDATA[Other Databases on zOS. • Re: We made a Century!!]]>
Today it is 165!!!

Statistics: Posted by Anuj Dhawan — Fri Jul 19, 2013 7:11 pm

2013-07-18T05:35:38+00:00 2013-07-18T05:35:38+00:00 <![CDATA[Other Databases on zOS. • We made a Century!!]]>

We got 121 users online Yesterday, on 17 Jul 2013 at 22:54. You can check that at the bottom of Board Index. This will be shown like this: "Most users ever online was 121 on 17 Jul 2013 22:54".

That's a great achievement.

Thanks for Liking and showing the trust in to the Labor we're putting in, much appreciate that,


Statistics: Posted by Anuj Dhawan — Thu Jul 18, 2013 5:35 am

2013-06-17T05:48:23+00:00 2013-06-17T05:48:23+00:00 <![CDATA[Other Databases on zOS. • AJAX Chat is Installed!]]> AJAX Chat is Installed! Using this you can Chat with other registered members while you're logged in -- it's Fun when you don't to post a topic however, still want to convey some message to other user. Below is a handy link to AJAX Chat corner. You can also find it on the "Menu-Bar" adjacent to FAQ.


For the Curious minds: Ajax Chat is a high performance php-based chat server software for a live chat-room or -module on every php-based site.

Statistics: Posted by Anuj Dhawan — Mon Jun 17, 2013 5:48 am

2013-06-16T14:58:13+00:00 2013-06-16T14:58:13+00:00 <![CDATA[Other Databases on zOS. • Arcade Games are Installed!]]> Arcade Games are Installed! So have Fun while You Learn! :)

There are currently 25 games installed. Have a look: Here is a list of Games - click on Arcade below to get started:


And don't Forget to Submit Your highest Score!

Statistics: Posted by Anuj Dhawan — Sun Jun 16, 2013 2:58 pm

2013-06-13T06:20:07+00:00 2013-06-13T06:20:07+00:00 <![CDATA[Other Databases on zOS. • Re: Mobile View.]]>

Statistics: Posted by Admin — Thu Jun 13, 2013 6:20 am

2013-06-08T19:58:59+00:00 2013-06-08T19:58:59+00:00 <![CDATA[Other Databases on zOS. • Mobile View.]]>
Please note that for members who prefer to view our site in 'mobile style' on a computer, we have an option to switch to 'Mobile View' while on computer also. You can find this option at the bottom of the index page just above the donation chest icon.

Please Note - in mobile-view, as of now, "basic blue color scheme" is the only standard theme at the moment - so you might see "green changing to blue" while in 'mobile-view' or seeing the site on a mobile.

Enjoy! :)

Statistics: Posted by Anuj Dhawan — Sat Jun 08, 2013 7:58 pm

2013-05-20T17:52:03+00:00 2013-05-20T17:52:03+00:00 <![CDATA[Other Databases on zOS. • What are Other Databases on zOS?]]>
If you've some other DB-names with you, please take a reference from this sticky and start a thread to list the name. And later we can update this sticky to have comprehensive list.

Datacom: Datacom/DB is a relational database management system for the mainframes. It was originally developed by Insyte Datacom and later acquired by Applied Data Research, however, it is now owned by CA Technologies which renamed it to CA-Datacom/DB and later to CA Datacom/DB.

  • In this Data is stored in the form of databases, which can have one or more keys.
  • Access is through ‘embedded” datacom calls in high level languages, or through "data-query".
  • This is NOT a Relational Database Manager or even a sophisticated database manager
  • This is a filing system, for better organization of data
  • It has the basic features of a filing system - keys, indexes etc.
  • It has locking features, to prevent “lost updates”

IDMS: Integrated Database Management System (IDMS)is primarily a network database management system for mainframes. It was first developed at B.F. Goodrich and later marketed by Cullinane Database Systems (renamed Cullinet in 1983). Since 1989 the product has been owned by Computer Associates (now CA Technologies), who renamed it Advantage CA-IDMS and later simply to CA IDMS.

Adabas: ADABAS, Adaptable DAta BAse System, is Software AG’s primary database management system. Initially released on IBM mainframe systems using DOS/360, OS/MFT or OS/MVT, ADABAS is now available on a range of other systems including OpenVMS, Unix (including Linux and Linux on zSeries), and Microsoft Windows servers. ADABAS has maintained its position as one of the world's fastest OLTP databases. Historically, ADABAS was used in conjunction with Software AG's programming language NATURAL, so that many legacy applications that use ADABAS as a database on the back-end are also developed with NATURAL as well.

Oracle: An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management. In general, a server reliably manages a large amount of data in a multiuser environment so that many users can concurrently access the same data. All this is accomplished while delivering high performance. A database server also prevents unauthorized access and provides efficient solutions for failure recovery.

Oracle Database is the first database designed for enterprise grid computing, the most flexible and cost effective way to manage information and applications. Enterprise grid computing creates large pools of industry-standard, modular storage and servers. With this architecture, each new system can be rapidly provisioned from the pool of components. There is no need for peak workloads, because capacity can be easily added or reallocated from the resource pools as needed.

The database has logical structures and physical structures. Because the physical and logical structures are separate, the physical storage of data can be managed without affecting the access to logical storage structures.


NOMAD: Nomad Software is a relational database and fourth-generation language (4GL), originally developed in the 70s by time-sharing vendor National CSS, Inc. While it is still in use today, its widest use was in the 70s and 80s. NOMAD is available for z/OS, OS/390, and z/VM on mainframe machines. When used with Front & Center as a reporting front end with RP/Server, NOMAD is a powerful mainframe server. NOMAD can also participate in IBM's Distributed Relational Database Architecture (DRDA) through DB2 interfaces on the mainframe and Unix platforms.

In addition to data stored in NOMAD databases, you can easily access and combine data from a variety of sources, including leading relational systems such as DB2, as well as IDMS, IDMS/R, VSAM and QSAM files. With its special shared database facility, NOMAD users also have the ability to report from local or remote NOMAD databases on either z/VM or z/OS machines.

NOMAD is designed for maximized efficiency when accessing data in relational engines, including support for static SQL. NOMAD translates its commands into SQL statements and offloads as much work as possible, such as sorting and aggregation, to the SQL engine. Additionally, selective data listing can be performed efficiently through SELECT and LIST WHERE commands, and global data maintenance is handled by passing set calls for CHANGE and DELETE as a single transaction.

SUPRA: SUPRA PDM is Cincom's hierarchical, high performance database management system (PDM) that is available on the IBM mainframe, Open VMS and several major UNIX platforms. SUPRA PDM provides a high degree of control over the storage and navigation of data allowing high-speed, online transaction processing and high scalability.

Here is a link for more details:



Model 204: Model 204 is a flexible, high-performance database with relational capabilities. It is a mature, reliable mainframe product whose performance, functionality and connectivity have been continually enhanced for over 30 years. Model 204 is a robust, reliable and continually evolving mainframe database. Its flexibility, rich functionality and interactive development environment have allowed an integrated application infrastructure to be developed with minimal staff. Model 204 relies on its own type of bitmap index, originally devised by Professor Patrick E. O'Neil, and also combines the use of hash table, B-tree, and record list technologies to optimize speed and efficiency of database access.

Although M204 is a pre-SQL (and pre-relational) database product, it is possible to manually map the files of an M204 database to approximate SQL equivalents and provide some limited SQL functionality using Model 204 SQL Server.

Model 204 is most commonly used in government and military applications. Among other things, it runs Australia's social security system (Centrelink). It is used commercially in the UK by Marks & Spencer.[citation needed] It is also used at the Ventura County Property Tax system in California, the Harris County, Texas, Justice Information Management System, and in the New York City Department of Education's Automate The Schools system. An informal list of past and present Model 204 users, compiled in 2010, identified more than 140 organizations worldwide.

Here is one link having explnation direcly from the Horses' mouth:

SQL/DS: SQL/DS (Structured Query Language/Data System), released in 1981, was IBM's first commercial relational database management system. It implemented the SQL database query language.

SQL/DS ran on the DOS/VSE and VM/CMS operating systems. A little later, IBM also introduced DB2, another SQL-based DBMS, this one for the MVS operating system. The two products have coexisted since then; however, SQL/DS was rebranded as "DB2 for VM and VSE" in the late 1990s.

Statistics: Posted by Anuj Dhawan — Mon May 20, 2013 5:52 pm