1
  • How to export query output from qmf to access and/or excel?

    I would like to be able to use the date eventually in excel? Is there a way to export direct to excel? If not, through access is another option. How do I accomplish these?

    mtanutama10 pointsBadges:
  • Qmf for Windows 8.1 fp18 – date datatype from db2 z/os 8 format error in excel 2003

    When I import a DB2 z/OS query result  containing date or date(timestamp) columns from QMF for WINDOWS in EXCEL 2003 using the Add-in the cells cannot be formatted. In the same column the date are displayed sometimes as dd/mm/yyyy, sometimes as nnnnn or in the previously defined format (example...

    Erredi5 pointsBadges:
  • QMF

    USER TRYING TO DOWNLOAD QMF REPORTS GETS ERROR IKJ56712I INVALID KEYWORD

    stewarteg5 pointsBadges:
  • How to replace the batch query in QMF thru JCL?

    i have one batch query in DBC4MED1.BR211Q_SALEANAL(PRODUCTION).. this batch query is running thru the QMF PROC DBC4MED1.BR211P_SALEANAL to create a report. now i have made changes to the batch query and saved with my HLQ  (PM7351.BR21Q_SALEANAL) in QMF.Now i want to repace the query in...

    PratapMetta5 pointsBadges:
  • Designing a single query using SPUFI

    Hi, I am new to Mainframe..using QMF.Instead of using multiple select queries,my TL told me to design a single query.How to execute the query in SQL execution engine SPUFI??? Please tell the steps involved in creating a dataset & import the results?

    Ajsjanani5 pointsBadges:
  • 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 me, it would be greatly...

    Sunshine755695 pointsBadges:
  • QMF results display as Excel sheet (line feed characters within data fields)

    When displaying QMF (V8.1) Query Results as an Excel spreadsheet, the Line control X'0A' characters within the data fields are causing: fields to split (multiple fields) where the where the LineControl characters occur and, the field and record to be continued [strong][em]on the following...

    Girwin505 pointsBadges:
  • 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...

    Tiburonblanco80 pointsBadges:
  • QMF

    can we save the statements write in QMF?

    Avijji5 pointsBadges:
  • 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...

    AuntDi5 pointsBadges:
  • 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?

    BhleftD10 pointsBadges:
  • QMF for Windows

    How can I execute 10 sql at one go ?

    Jams5 pointsBadges:
  • 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

    Meichhar5 pointsBadges:
  • 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...

    Donnaw5 pointsBadges:
  • 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...

    Panky5 pointsBadges:
  • 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 back...

    Nishantrk5 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following