× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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 thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.