Procedures and SQL queries

The format of the file, data set, or CICS data queue representing these objects is the simplest of all the objects. Each record in the file, data set, or CICS data queue is essentially an image of a line as it appears on the screen (fixed length record of 79 bytes).

This is an SQL query:

 SQL query                                            MODIFIED  LINE    1
 
 SELECT *
 FROM Q.STAFF

This is the query in its externalized format:

* * * Top of File * * *
SELECT *
FROM Q.STAFF
 
 
 
 
* * * End of File * * *

Because of the simplicity of the record format, creating or editing an SQL query or procedure outside of QMF is very straightforward. An SQL query or procedure consists of a fixed-length file, data set, or CICS data queue containing 79-byte query or procedure records. Import the resulting file, data set, or CICS data queue, and your query or procedure is now in the QMF temporary storage area ready to be run.