QMF

Office 2007

I have QMF for Windows 7.2 installed on my computer. I just got Office 2007 installed on my computer. Now, the Excel QMF Add-on is not working properly. I have a query with eight columns. when I use the QMF add-on to retrieve the data, it only retrieves 3 of the columns. How can I get the add-on to...

Install QMF V9

What are the conversion requirements for QMF objects going from V8 to V9 - queries, forms & procs and what about tables and views saved in QMF, do they need to be unloaded and re-loaded?

QMF

can we save the statements write in QMF?

QMF for Windows

How can I execute 10 sql at one go ?

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

How to replace edited dataset in QMF through jcl( i.e Batch)

I have exported one dataset 'IN105.Nord1'through QMF , then I have edited it and now I want to import it in QMF by same name( i.e IN105.Nord1') which I can do it through QMF . But now I would like to achieve same thing by running QMF through jcls( i.e through batch).Can I replace edited dataset...

Calling QMF interactive from COBOL programs in CICS regions

We have a call to QMF from all the screen in the application. We also has QMF report generation from onlines where users enter the details in onlines which is passed to QMF proc and report is shown to them on QMF screen. Once user is done with QMF queries/reports and presses PF3 he/she returns...