Courses to Take for QMF beginner
Is there a list of courses to take in QMF for a beginner from course one to the end? If so, could you please list them. We have SkillSoft courses through our Learning Center but they do not them in order from what you need to take first and so on.  If you could help [...]

Answer Question   |  February 1, 2011  1:09 PM
IT career planning, QMF, Query Management Facility, Query Manager

not a valid Query Management variable.
Hi, can someone please help me, I am trying to use the QMQRY function to run an update statement. I pass it a variable from the program. Get the following error. is not a valid Query Management variable. Error found on STRQMQRY command. Function check. CPF0001 unmonitored by PGMFCTSEC at statement 3500, instruction X’0021′. Can [...]

Answer Question   |  October 8, 2009  11:32 AM
CL, CL programming, CL variables, QMQRY, Query Management Facility, STRQMQRY, V5R4, Variables

QMF
can we save the statements write in QMF?

Answer Question   |  September 23, 2009  2:14 PM
DB2, DB2 query tools, IBM DB2, IBM DB2 Query Management Facility, IBM Query Management Facility, QMF, Query Management Facility

QMF for Windows
How can I execute 10 sql at one go ?

Answer Question   |  October 14, 2008  6:54 AM
DB2, QMF, Query Management Facility, SQL

Convert table entry from text to numeric
I have generated a table that has a 4 char text field. I want add a column and convert this text field that is numbers to numeric so that both coexist.

Answer Question   |  August 11, 2008  12:10 PM
Query Management Facility

How to restrict QMF to execute predefined queries only?
Hi, is there a way to restrict the usage of QMF/390 to predefined queries/procedures only? Some users should not be able to edit or create SQL statements on their own. Thank you very much. Regards Michael

Answer Question   |  July 29, 2008  8:01 AM
DB2, Mainframe, OS/390, QMF, Query Management Facility, z/OS

QMF issue
I have my QMF for windows version 8.1 Fix Pack 13, and I try to run this instruction INSERT INTO destination table SELECT * FROM origin table and every time I receive this error message: An error occurred while running the query. destrination table not valid for operation. (SQL code = -7008, SQL state = [...]

Answer Question   |  October 31, 2009  9:28 PM
AS/400 DB2, QMF, Query Management Facility, SQL

Unloading specific records in a foreign key, cascade format.
Hi, We have DB2 version 8, os/390. I know how to use QMF and JCL. I would like to unload, to files, specific records that I would enter, by the key, in a where clause. The record would then cascade down to unload ALL tables, with a specified TBCREATOR name based on foreign keys. I [...]

Answer Question   |  June 25, 2008  6:33 PM
DB2, DB2 administration, JCL, OS/390, QMF, Query Management Facility