QMF issue
I have my QMF for windows version 8.1 Fix Pack 13, and I try to run this instructionINSERT INTO destination table SELECT * FROM origin tableand every time I receive this error message:An error occurred while running the query. destrination table not valid for operation.(SQL code = -7008, SQL...
Answer Question
| Jun 2 2008 9:28 PM GMT
| asked by
Tiburonblanco
SQL, QMF, Query Management Facility (QMF)
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 the...
View Answer
| May 13 2008 6:33 PM GMT
| asked by
Donnaw
DB2 Administration, OS/390, DB2
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...
Answer Question
| Apr 22 2008 10:59 AM GMT
| asked by
Panky
QMF, JCL
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...
Answer Question
| Apr 16 2008 5:20 AM GMT
| asked by
Nishantrk
CICS, QMF, Mainframe
