RE: SQL equivalent of query needed -- MIDRANGE-L

I see what I was doing wrong. I needed to specify ALWQRYDFN(*YES)
because it was a Query/400 query and not a QM query.

> -------- Original Message --------
> Subject: RE: SQL equivalent of query needed
> From: rob@xxxxxxxxx
> Date: Mon, March 07, 2005 11:50 am
> To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
> 
> Yes, even if you do not have STRQM, STRSQL, etc loaded on your system, you 
> can still use RTVQMQRY against a Query/400 query.   Many, many years ago I 
> wrote an article on this in News 3X/400.  Now, when I do my SQL I may do 
> things differently - like using JOINs instead of just WHERE clauses.  So I 
> wouldn't rely on RTVQMQRY being your sole method of learning how to code a 
> SQL statement.
> 
> Rob Berendt
> -- 
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
> 
> 
> 
> 
> 
> michael@xxxxxxxxxxxxxxxxxx 
> Sent by: midrange-l-bounces@xxxxxxxxxxxx
> 03/07/2005 07:33 AM
> Please respond to
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> 
> 
> To
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> cc
> 
> Subject
> RE: SQL equivalent of query needed
> 
> 
> 
> 
> 
> 
> Does that work for Query/400?
> 
> > -------- Original Message --------
> > Subject: RE: SQL equivalent of query needed
> > From: "Barton, Mike" <Mike.Barton@xxxxxxxxxxxxxxxxx>
> > Date: Mon, March 07, 2005 7:24 am
> > To: "'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
> > 
> > Murali
> >                I'm no expert on SQL but....
> > 
> > Since u have a query in existence, u can use the RTVQMQRY command
> > 
> > Create a source file first then:
> > RTVQMQRY QMQRY(QRYLIB/QRY) SRCFILE(YOURLIB/QMQSRC) ALWQRYDFN(*YES)
> > 
> > This will extract an SQL equivalent.
> > 
> > HTH
> > 
> > Mike
> > 
> > 
> >                                -----Original Message-----
> >                                From:           murali dhar 
> [mailto:hydchap1@xxxxxxxxx]
> >                                Sent:           07 March 2005 12:13
> >                                To:             midrange-l@xxxxxxxxxxxx
> >                                Subject:                SQL equivalent of 
> query needed
> > 
> >                                Hi 
> >                                Very good morning, I need SQL equivalent 
> of below query ,
> > can some one please help...
> >                                I have written query easily, but I want 
> to check on SQL...
> >                                QTEMP/YX1                  QTEMP/YY1
> >                                Type of join = 1 matched records
> > 
> >                                QUERY Conditions: 
> >                                T01.MOFIC EQ  T02.MOFIC
> >                                T01.MACCT  EQ  T02.MACCT
> > 
> >                                DEFINE ReSULT FIELDS:
> >                                IMRCHG       T02.IMR01-T01.IMR01
> > 
> >                                OTECHG       T02.OTE01-T01.OTE01
> >                                SELECT RECORDS ARE AS BELOW:
> >                                10 T01.MCLASS
> >                                20 T01.MSUBCL
> >                                30 T01.MFIRM
> >                                40 TOTALCALL         IMRCHG - OTECHG  
> >                                50 IMRCHG            T02.IMR01 - 
> T01.IMR01 
> >                                60 OTECHG            T02.OTE01 - 
> T01.OTE01 
> > 
> >                                Thanks very much for your help in 
> advance,
> > 
> > 
> > 
> > __________________________________________________
> >                                Do You Yahoo!?
> >                                Tired of spam?  Yahoo! Mail has the best 
> spam protection
> > around 
> >                                http://mail.yahoo.com 
> >                                -- 
> >                                This is the Midrange Systems Technical 
> Discussion
> > (MIDRANGE-L) mailing list
> >                                To post a message email: 
> MIDRANGE-L@xxxxxxxxxxxx
> >                                To subscribe, unsubscribe, or change list 
> options,
> >                                visit: 
> http://lists.midrange.com/mailman/listinfo/midrange-l
> >                                or email: MIDRANGE-L-request@xxxxxxxxxxxx
> >                                Before posting, please take a moment to 
> review the archives
> >                                at http://archive.midrange.com/midrange-l
> .
> > 
> > 
> > 
> > _____________________________________________________________________
> >                                This e-mail has been scanned for viruses 
> by MCI's Internet
> > Managed Scanning Services - powered by MessageLabs. For further 
> information
> > visit http://www.mci.com
> > ###########################################
> > 
> > This message has been scanned by F-Secure Anti-Virus for Microsoft 
> Exchange.
> > For more information, connect to http://www.F-Secure.com/
> > 
> > **********************************************************************
> > This communication and the information it contains: - (a) Is intended 
> for the person(s) or organisation(s) named above and for no other 
> person(s) or organisation(s). Access to this mail by anyone else is 
> unauthorised. (b) Is confidential, and may be legally privileged or 
> otherwise protected in law. Unauthorised use, circulation, copying or 
> disclosure of any part of this communication may be unlawful. (c) May be 
> susceptible to interference, and should not be assumed that it has come in 
> its original form and/or from the stated sender or PinkRoccade UK accepts 
> no responsibility for information, errors or omissions in this e-mail or 
> use or misuse thereof or any act done or omitted to be done in connection 
> with this communication. If you are not the intended recipient, please 
> inform postmaster@xxxxxxxxxxxxxxxxx immediately and delete it and all 
> copies from your system.
> > 
> > www.pinkroccade.co.uk
> > **********************************************************************
> > 
> > -- 
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
> list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
> 
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
> 
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.