Datacom IVP: Batch Dataquery SQL (Sample)

Products

• Datacom
• Datacom/DB

Issue/Introduction

This article pertains to Batch Dataquery SQL using Inner Join.

Maybe you have completed your installation of Datacom/DB software, or maybe you just upgraded to the most current version. Now, you want to run some sort of test to make sure the new software works as expected. You can run the supplied Installation Verification Process (IVP) jobs, or you can issue the online DBAC transaction. 

But how do you know that other programs or applications will work? Or do you want to expand your horizons to learn a new programming language?

This article will provide a package that you can download and use to create a similar output of the supplied IVP program, but with the source for another language. The hope is that you can use this to test Datacom functionality with other languages and to have a starting point for developing other applications for your data.

This sample requires database 001 (HUMAN-RESOURCE) to be installed and loaded with the default data.

Environment

z/OS

Datacom/DB

Resolution

Please download the attached file for the Batch Datacom DBSQLPR program. This is a zip file containing these members:

IBDQS$$$ - README file for this set
IBDQSJC1 - JCL to execute Dataquery in Batch 
IBDQSPR1 - Query using INNER JOIN
IBDQSOP1 - Output of program execution 

The last member, above (ending with OP1), is an output execution/report file with records longer than 80 bytes. All other members are 80-byte source files. Please extract the zip file, and upload all source members into a single PDS. If you have downloaded other Datacom IVP samples, you can add these members to that PDS.