1
  • Query Manager Report Forms

    Is there a simple way to print a cover page using Query Manager like there is in regular query/400

    Eamon6075 pointsBadges:
  • Help with Query Manager and Duplicate Values

    Below is snapshot of my SQL Query when I view it Query Manager: SELECT DISTINCT                                                               

    lorit365 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:
  • Need help with setvar for iSeries query manager using not in ()

    I have an issue with a Query Manager where I need help with the syntax for a list of entries in the Select not in ( ) portion. I have a command that will call an RPGLE module which will call the Query Manager. I know that the quotes have to be supplied by the calling program (found a lot of info in...

    VGP300 pointsBadges:
  • Difference between QM Query and traditional query

    When both a QM Query and a traditional Query are run against a database file with IDENTICAL record selection, the traditional query returns more records. I can only guess that it has to do with a difference in the way each utility handles uncommitted data. It almost looks as if traditional Query...

    slateken230 pointsBadges:
  • Passing parameter to Query Manager

    I have the following query manager that errors with the following statement that is being placed in the CLP program: Type a value for variable "SELECT" and press Enter. This value should have been passed by the CLP program: *************** Beginning of data ************************************ PGM...

    a1maida150 pointsBadges:
  • STRQMQRY: The variable should appear without quotes

    In my cl the strqmqry I am passing 2 variables that are character but should be numeric when the query runs.............now they have the quotes around them.................how do I get the quotes out of there so they are treated as numeric????

    Harrigan5 pointsBadges:
  • Requirements

    Is there a way that a test folder can be copied to a new location in the project along with it's associated Requirements

    SilverFox271530 pointsBadges:
  • convert from msaccess to sql2005

    SELECT Format(DTrans.DATE,'dd/mmm/yyyy') AS dated, DTrans.trntype as Expr1 , DTrans.JVNO, 'By ' & FINNACCO.ACCNAME , (select analscode from INCEXPAN where analscode=val(DTrans.CRANALSCODE) and accode=craccode) AS CRANALSCODE, '' , DTrans.AMOUNT, dtrans.craCCODE AS accode,...

    Radhikanutalapati5 pointsBadges:
  • Delete and Update in Query Magager

    How can I use delete and update statments in Query Manager (QMQ) in OS/400. I can able to create QM Queries for Select Statment but not able to update tables using Delete and Update statment. Please help, a production project in pending for this.

    Abhichavan5 pointsBadges:
  • Multiple DELETE From Statements in Query Manager

    How do I enter more than one Delete from ...... where .. Statement from within Query Manager?

    Pb5410 pointsBadges:
  • Report Query

    Can I run a query in peoplesoft if I don't have access to query manager?

    Aolpoint5 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