RE: QM/400 vs Query/400

["Simon Coulter" <shc@xxxxxxxxxxxxxxxxx>]

Œ
Hello Dennis,

These questions should go via the list so others can learn from your 
experiences.

The easiest way to convert Query/400 definitions to QM is to use the RTVQMQRY 
and 
RTVQMFORM commands.  Specify ALWQRYDFN(*YES) and extract the query and form 
definitions 
to a file.  You can then create the queries and forms using CRTQMQRY and 
CRTQMFORM.  
They will be SQL queries rather than prompted queries but that is the easiest 
way.  You 
could easily knock up some CL to automate the entire process.

        List *QRYDFN objects
        For each *QRYDFN
                RTVQMQRY
                RTVQMFORM
                CRTQMQRY
                CRTQMFORM
        Endfor

I don't believe there is any way to convert Query/400 to a prompted QM query 
nor any 
way to convert an SQL QM Query to the prompted form but since you seem to want 
the SQL 
version then there is no need to create a prompted version first.

The reference manuals you need are:

        DB2 for AS/400 SQL Reference
        DB2 for AS/400 Query Managemer Use
        DB2 for AS/400 Query Management Programming
        
all of which have been moved to that poxy excuse for a library called the 
Information 
Centre (colloquially known as Obfuscation Central).

Regards,
Simon Coulter.

«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»
«» FlyByNight Software         AS/400 Technical Specialists       «»
«» Eclipse the competition - run your business on an IBM AS/400.  «»
«»                                                                «»
«» Phone: +61 3 9419 0175      Mobile: +61 0411 091 400           «»
«» Fax:   +61 3 9419 0175      mailto: shc@flybynight.com.au      «»
«»                                                                «»
«» Windoze should not be open at Warp speed.                      «»
«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»
//--- forwarded letter -------------------------------------------------------
> X-Mailer: Internet Mail Service (5.5.2650.21)
> Date: Mon, 15 May 00 16:25:46 -0500
> From: "Dennis Munro" <DMunro@badgerminingcorp.com>
> To: "'shc@flybynight.com.au'" <shc@flybynight.com.au>
> Subject: RE: QM/400 vs Query/400

> 
> Rimon,
> 
> I was working/looking through your example when I had to quit for an
> emergency.  I will get back to your example to figure out my problem as soon
> as I can.  I have 20+ queries to convert for "automating" month end & can
> only guess I will have more of this type of logic to work through.
> 
> What is the better way to convert Query/400 definitions to QMQuery specs?
> Do I just enter the specs through the "prompt" function & then take option
> 10 to convert to SQL?  That is what I'm doing now.  With the "limited"
> number of queries to convert, that should not be to bad but it brings up my
> keying ability.  If I had more it would be nice to automate the conversion
> process but I don't know what or how to accomplish that thought?  Is there a
> way to help automate the process?
> 
> Again, thanks for your example with my example.  Doing that makes it easier
> to understand.  I think I'm getting confused by the negative(?) Boolean
> logic that the NLIST parms need to generate.  I didn't write the query & I
> try to write queries with "include" logic vs. omit logic.  Just seems to be
> easier to understand.
> 
> What IBM manual is a good reference for the QMQueries?  I have the DB2 for
> AS/400 Query manager manual printed & just last Friday downloaded two SQL
> manuals.  They are huge to print so I will need to schedule some time for
> that.
> 
> Again, thanks for your insight.  If you would prefer I not send a response
> directly to you, please let me know & I will respond to the list.
> 
> Dennis
> 
> "One never notices what has been done; one can only see what remains to be
> done." -- Marie Curie 
> "I love deadlines.  I especially like the whooshing sound they make as they
> go flying by."  Dilbert's Words Of Wisdom:
> 
> Dennis Munro  
> Badger Mining Corporation
> dmunro@badgerminingcorp.com <mailto:dmunro@badgerminingcorp.com> 
> (920) 361-2388        
> 

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---