Save Procedure

After you have created the PROC, you may wish to save it for later use. QMF does not keep a copy of your PROC to use later unless you save it.

Scenario: - Steps to save the PROC using QMF for future usage.

STEP-1: - Once the PROC editor screen appears, type your SQL query on the blank screen (example below):

Save PROC

STEP-2: - Enter any one of the below command to save the query and press Enter.

  • EXPORT PROC AS proc_name
  • SAVE PROC AS proc_name
Save PROC

STEP-3: - PROC is saved in the database with the name provided with userid before it. It shows like userid.proc_name.

Save PROC