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
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
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
How can I execute 10 sql at one go ?
Answer Question | October 14, 2008 6:54 AM
DB2, QMF, Query Management Facility, SQL
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
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
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
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