DB2 graphic QMF Version 8

Sample procedure

The following sample procedure demonstrates how to display, run, and print a report using a query and a form. It also creates a new query based on a table, runs that query, exports the data to a file, and saves the data in a table at a different database server.

SET GLOBAL (TABLE=SMITH.PAYROLL
DISPLAY QUERY SMITH.PAYROLL_QUERY
RUN QUERY (FORM=SMITH.PAYROLLFORM
PRINT REPORT
DRAW SMITH.PAYROLLTABLE (TYPE=SELECT
RUN QUERY
EXPORT DATA TO C:\TEMP\EXP1.IXF (DATAFORMAT=IXF

CONNECT TO 'SERVERC'
SAVE DATA AS SMITH.DATASAVE
SHOW REPORT


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004