What is QMF in DB2?

What is IBM Db2 Query Management Facility? QMF is designed to be a security-rich, easy-to-use business analytics and visualization solution optimized for IBM Z® data. Delivers self-service business intelligence with interactive dashboards and intuitive visualizations.

How do I get to SPUFI in mainframe?

To open SPUFI and specify initial options: Select SPUFI from the DB2I Primary Option Menu as shown in The DB2I primary option menu. The SPUFI panel is displayed. Optional: Specify new values in any of the other fields on the SPUFI panel.

How do you comment in Spufi?

To comment any query in spufi give two hyphens before the query in the spufi. This will comment that line.

What does QMF mean?

QMF

How do I set up QMF?

Procedure

1. Go to the directory where you have downloaded setup executable file.
2. Run the setup executable file to begin the installation.
3. On the Introduction panel, read the recommendations and description of the installation process and click Next.

How do I access QMF?

You can enter QMF commands from TSO or CICS® environments. In TSO, you might also be using ISPF. You can issue QMF commands in several ways: on the command line, with a function key, on a prompt panel, or from a procedure or application. Several points apply to QMF commands that access data at a remote server.

How do you do a continuation in Spufi?

There is no continuation indicator SPFUI just concatenates the lines together until it encounters a semi-colon. after the intial insert, (which will contain as much of the literal as you can input, use multiple UPDATE statements.

How do you make a Dclgen?

Procedure

1. To start DCLGEN from ISPF through DB2I: Select the DCLGEN option on the DB2I Primary Option Menu panel.
2. To start DCLGEN directly from TSO: Sign on to TSO, issue the TSO command DSN, and then issue the subcommand DCLGEN.

https://www.youtube.com/watch?v=MDdKcCQ7y5Q