|
I don't know. I've never tried that. Once I started using SEQUEL, I quit using Query. The difference is like night and day. There IS a function that will allow you to convert your existing queries into views. Passing run time variables into a view is a piece of cake. Give me a call if you want more info. Paul Nelson Braxton-Reed, Inc. 630-327-8665 Cell 708-923-7354 Home pnelson@braxton-reed.com ----- Original Message ----- From: <rob@dekko.com> To: <midrange-l@midrange.com> Sent: Tuesday, August 13, 2002 9:52 PM Subject: Re: Is UNION supported on a VIEW in V5R1? > > So it will create a view that I can then access from Query? > > Rob Berendt > -- > "They that can give up essential liberty to obtain a little temporary > safety deserve neither liberty nor safety." > Benjamin Franklin > > > > "Paul Nelson" > <p_nelson-br@pop.in To: <midrange-l@midrange.com> > il.com> cc: > Sent by: Fax to: > midrange-l-admin@mi Subject: Re: Is UNION supported on a VIEW in V5R1? > drange.com > > > 08/13/2002 04:56 PM > Please respond to > midrange-l > > > > > > > SEQUEL from Advanced Systems Concepts does and has for the last 10 years. I > use it frequently. > > Paul Nelson > Braxton-Reed, Inc. > 630-327-8665 Cell > 708-923-7354 Home > pnelson@braxton-reed.com > ----- Original Message ----- > From: <rob@dekko.com> > To: <midrange-l@midrange.com> > Sent: Tuesday, August 13, 2002 3:04 PM > Subject: Is UNION supported on a VIEW in V5R1? > > > > This is a multipart message in MIME format. > > -- > > [ Picked text/plain from multipart/alternative ] > > I am running a RUNSQLSTM and seem to be having a problem. > > > > 5722SS1 V5R1M0 010525 Run SQL Statements IIML88 > > 08/13/02 14:57:19 Page 1 > > Source file...............QTEMP/QSQLSESS > > Member....................IIML88 > > Commit....................*NONE > > Naming....................*SYS > > Generation level..........10 > > Date format...............*JOB > > Date separator............*JOB > > Time format...............*HMS > > Time separator ...........*JOB > > Default collection........*NONE > > IBM SQL flagging..........*NOFLAG > > ANS flagging..............*NONE > > Decimal point.............*JOB > > Sort sequence.............*JOB > > Language ID...............*JOB > > Printer file..............*LIBL/QSYSPRT > > Source file CCSID.........37 > > Job CCSID.................65535 > > Statement processing......*RUN > > Allow copy of data........*OPTIMIZE > > Allow blocking............*ALLREAD > > Source member changed on 08/13/02 14:37:45 > > 5722SS1 V5R1M0 010525 Run SQL Statements IIML88 > > 08/13/02 14:57:19 Page 2 > > Record *...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6 > > ...+... 7 ...+... 8 SEQNBR Last change > > 1 CREATE VIEW IIML88 > > 2 AS ( > > 3 SELECT IID, IPROD, IDESC, IADJ, IRCT, IISS, IOPB, IYISS, IYTDU, > > 4 IYSLS, IMSLS, ICLAS, IUMS, IUMP, IUMCN, IITYP, ILEAD, > > IVEND, > > 5 IVEN2, ICUSA, IPRDA, IMIN, ILDTE, ILIST, ISCST, IACST, > > IFCST, > > 6 ILEVL, IONOD, IDISC, INSEQ, ITSEQ, ICYC, IDRAW, IMTDU, > > IMRP, > > 7 IACT, IORDP, IYRCT, ILOTS, IYADJ, IMCOS, IYCOS, IMUST, > > IORDC, > > 8 IAVEU, IDSCE, IWGHT, IABBT, IABC, IPFDV, IPACK, ILABL, > > IDRF, > > 9 ICLNG, ICWID, IPITM, IBUYC, IFENO, IUMR, IUMRC, IFII, > > TAXC1, > > 10 SAFLG, IIOQ, IBTCH, IYUSE, ICYCF, IPERS, ISTYL, IPODY, > > ITFDY, > > 11 IFRFG, ISACT, IUMAT, IVULI, IVULP, INCCFG, IWHS, ISOFL, > > ILCC, > > 12 IJIT, IUNCN, IMAXR, IMINR, IPCTK, IGTEC, IMAXP, IMTDP, > > IYTDP, > > 13 ITGQY, IARRT, IMXIN, IDMTF, IDMC1, IDMC2, IMBHD, IDLTR, > > 14 IMQDY, IMBWT, IMPOT, IMUSC, IMUMB, IMUMA, IPURC, IMSUM, > > 15 IBUSY, IDSCR, IMPSD, ILOC, IMCOM, IGLNO, IFCI, IMDCRT, > > ICOND, > > 16 IREF01, IREF02, IREF03, IREF04, IREF05, > > 17 CAST(iref05 as dec(7,2)) as length, > > 18 IORIGN, IMCOMC, IMFRMC, IMREVL, IMFORM, IMCCTL, IMBNDP, > > 19 IMBNDC, IMMNDT, IMBWIP, IMPMTH, IMCMTH, IMQLED, IMALOT, > > 20 IMNOT1, IMNOT2, IMMFGR, IMVFRY, IMSPEC, IMTLVL, IMQLE2, > > 21 IMSSPC, IMASTB, IMCNTR, IMPKD1, IMPKD2, IMHZRD, IMCSTC, > > 22 IMCORP, IMQCTL, IMCQTY, IDSALW > > 23 FROM IIM > > 24 WHERE iref05<>' ' > > 25 AND SUBSTR(IREF05,1,1) NOT BETWEEN 'A' AND 'Z' > > 26 UNION > > 27 SELECT IID, IPROD, IDESC, IADJ, IRCT, IISS, IOPB, IYISS, IYTDU, > > 28 IYSLS, IMSLS, ICLAS, IUMS, IUMP, IUMCN, IITYP, ILEAD, > > IVEND, > > 29 IVEN2, ICUSA, IPRDA, IMIN, ILDTE, ILIST, ISCST, IACST, > > IFCST, > > 30 ILEVL, IONOD, IDISC, INSEQ, ITSEQ, ICYC, IDRAW, IMTDU, > > IMRP, > > 31 IACT, IORDP, IYRCT, ILOTS, IYADJ, IMCOS, IYCOS, IMUST, > > IORDC, > > 32 IAVEU, IDSCE, IWGHT, IABBT, IABC, IPFDV, IPACK, ILABL, > > IDRF, > > 33 ICLNG, ICWID, IPITM, IBUYC, IFENO, IUMR, IUMRC, IFII, > > TAXC1, > > 34 SAFLG, IIOQ, IBTCH, IYUSE, ICYCF, IPERS, ISTYL, IPODY, > > ITFDY, > > 35 IFRFG, ISACT, IUMAT, IVULI, IVULP, INCCFG, IWHS, ISOFL, > > ILCC, > > 36 IJIT, IUNCN, IMAXR, IMINR, IPCTK, IGTEC, IMAXP, IMTDP, > > IYTDP, > > 37 ITGQY, IARRT, IMXIN, IDMTF, IDMC1, IDMC2, IMBHD, IDLTR, > > 38 IMQDY, IMBWT, IMPOT, IMUSC, IMUMB, IMUMA, IPURC, IMSUM, > > 39 IBUSY, IDSCR, IMPSD, ILOC, IMCOM, IGLNO, IFCI, IMDCRT, > > ICOND, > > 40 IREF01, IREF02, IREF03, IREF04, IREF05, > > 41 0 AS length, > > 42 IORIGN, IMCOMC, IMFRMC, IMREVL, IMFORM, IMCCTL, IMBNDP, > > 43 IMBNDC, IMMNDT, IMBWIP, IMPMTH, IMCMTH, IMQLED, IMALOT, > > 44 IMNOT1, IMNOT2, IMMFGR, IMVFRY, IMSPEC, IMTLVL, IMQLE2, > > 45 IMSSPC, IMASTB, IMCNTR, IMPKD1, IMPKD2, IMHZRD, IMCSTC, > > 46 IMCORP, IMQCTL, IMCQTY, IDSALW > > 47 FROM IIM > > 48 WHERE IREF05=' ' > > 49 OR SUBSTR(IREF05,1,1) BETWEEN 'A' AND 'Z' > > 50 ); > > * * * * * E N D O F S O U R C E * * > * > > * * > > 5722SS1 V5R1M0 010525 Run SQL Statements IIML88 > > 08/13/02 14:57:19 Page 3 > > Record *...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6 > > ...+... 7 ...+... 8 SEQNBR Last change > > MSG ID SEV RECORD TEXT > > SQL0154 30 1 Position 1 UNION and UNION ALL for CREATE VIEW not > > valid. > > Message Summary > > Total Info Warning Error Severe Terminal > > 1 0 0 0 1 0 > > 30 level severity errors found in source > > * * * * * E N D O F L I S T I N G * * > > * * * > > > > Rob Berendt > > -- > > "They that can give up essential liberty to obtain a little temporary > > safety deserve neither liberty nor safety." > > Benjamin Franklin > > _______________________________________________ > > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing > list > > To post a message email: MIDRANGE-L@midrange.com > > To subscribe, unsubscribe, or change list options, > > visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l > > or email: MIDRANGE-L-request@midrange.com > > 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@midrange.com > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l > or email: MIDRANGE-L-request@midrange.com > 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@midrange.com > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l > or email: MIDRANGE-L-request@midrange.com > Before posting, please take a moment to review the archives > at http://archive.midrange.com/midrange-l. > >
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.