Query Management Facility

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...

QMF

can we save the statements write in QMF?

QMF for Windows

How can I execute 10 sql at one go ?

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.

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

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 =...

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 would like...