Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

inline view

6 posts in Product Futures Discussion Last posting was on 2002-01-24 08:47:39.0Z
jinwook Posted on 2002-01-23 02:09:08.0Z
From: "jinwook" <jinwook@sybase.com>
Subject: inline view
Date: Wed, 23 Jan 2002 11:09:08 +0900
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <PhPgse7oBHA.123@forums.sybase.com>
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: 158.77.52.194
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:893
Article PK: 94421

Hi,

inline view is really really needed in ASE.
(ASA, ASIQ, DB2, Oracle support inline view, but ASE doesn't.....)

Please don't ask me why I cannot use temp tables..
If in 3-tier, temp table is useless(because always drop temp table and
recreate and insert into and again and again...............)

I'd like to know any plan or any reason not to be supported.


Thanks,
Jinuki


Pablo Sanchez Posted on 2002-01-23 04:09:29.0Z
From: "Pablo Sanchez" <pablo@dev.null>
References: <PhPgse7oBHA.123@forums.sybase.com>
Subject: Re: inline view
Date: Tue, 22 Jan 2002 21:09:29 -0700
Lines: 28
Organization: High-Performance Database Engineering
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <A3uiAS8oBHA.140@forums.sybase.com>
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: 207.225.105.222
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:892
Article PK: 94420

Are you talking about materialized views?
--
Pablo Sanchez, High-Performance Database Engineering
www.hpdbe.com
Independent Contractor, available for short-term and long-term
contracts

"jinwook" <jinwook@sybase.com> wrote in message
news:PhPgse7oBHA.123@forums.sybase.com...
> Hi,
>
> inline view is really really needed in ASE.
> (ASA, ASIQ, DB2, Oracle support inline view, but ASE doesn't.....)
>
> Please don't ask me why I cannot use temp tables..
> If in 3-tier, temp table is useless(because always drop temp table
and
> recreate and insert into and again and again...............)
>
> I'd like to know any plan or any reason not to be supported.
>
>
> Thanks,
> Jinuki
>
>


jinwook Posted on 2002-01-23 07:12:07.0Z
From: "jinwook" <jinwook@sybase.com>
References: <PhPgse7oBHA.123@forums.sybase.com> <A3uiAS8oBHA.140@forums.sybase.com>
Subject: Re: inline view
Date: Wed, 23 Jan 2002 16:12:07 +0900
Lines: 35
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-Mimeole: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <CrDscH#oBHA.189@forums.sybase.com>
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: 158.77.52.194
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:890
Article PK: 94417

No, no, no. materialized view and inline view are not same.(I think
materialized view is also needed)

"inline view" is similar to a subquery, but it is located after "from"
clause...

example)
SELECT iv.store_city, mv.prod_name, mv.sum_sales
FROM sum_fact_store_prod mv, (SELECT DISTINCT store_city, city_name
FROM store) iv
WHERE mv.store_city = iv.store_city
AND iv.store_name = 'BELMONT'
GROUP BY iv.store_city, mv.prod_name;

What do you call it? Anyway oracle call it "inline view".


Thanks,
Jinuki

"Pablo Sanchez" <pablo@dev.null> wrote in message
news:A3uiAS8oBHA.140@forums.sybase.com...
> Are you talking about materialized views?
> --
> Pablo Sanchez, High-Performance Database Engineering
> www.hpdbe.com
> Independent Contractor, available for short-term and long-term
> contracts
>
> "jinwook" <jinwook@sybase.com> wrote in message
> news:PhPgse7oBHA.123@forums.sybase.com...


Carl Kayser Posted on 2002-01-23 13:54:38.0Z
From: "Carl Kayser" <kayser_c@bls.gov>
References: <PhPgse7oBHA.123@forums.sybase.com> <A3uiAS8oBHA.140@forums.sybase.com> <CrDscH#oBHA.189@forums.sybase.com>
Subject: Re: inline view
Date: Wed, 23 Jan 2002 08:54:38 -0500
Lines: 36
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <nQATMZBpBHA.373@forums.sybase.com>
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: 146.142.35.25
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:885
Article PK: 94411

OK, I'll put my ignorance on the line. (Perhaps I'll learn something here.)
Since there are no sample tables (with result set) how does the query differ
from:

select distinct iv.store_city, mv.prod_name, mv.sum_sales
from sum_fact_store_prod mv, store iv
where mv.store_city = iv.store_cty
and iv.store_name = 'BELMONT' ?

What is the purpose of the "group by" clause in your query?

"jinwook" <jinwook@sybase.com> wrote in message
news:CrDscH#oBHA.189@forums.sybase.com...
> No, no, no. materialized view and inline view are not same.(I think
> materialized view is also needed)
>
> "inline view" is similar to a subquery, but it is located after "from"
> clause...
>
> example)
> SELECT iv.store_city, mv.prod_name, mv.sum_sales
> FROM sum_fact_store_prod mv, (SELECT DISTINCT store_city, city_name
> FROM store) iv
> WHERE mv.store_city = iv.store_city
> AND iv.store_name = 'BELMONT'
> GROUP BY iv.store_city, mv.prod_name;
>
> What do you call it? Anyway oracle call it "inline view".
>
>
> Thanks,
> Jinuki


jinwook Posted on 2002-01-24 08:47:39.0Z
From: "jinwook" <jinwook@sybase.com>
References: <PhPgse7oBHA.123@forums.sybase.com> <A3uiAS8oBHA.140@forums.sybase.com> <CrDscH#oBHA.189@forums.sybase.com> <nQATMZBpBHA.373@forums.sybase.com>
Subject: Re: inline view
Date: Thu, 24 Jan 2002 17:47:39 +0900
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <7nnIlhLpBHA.189@forums.sybase.com>
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: 158.77.52.194
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:881
Article PK: 94408

Hi, Carl

The query that I post is from oracle's homepage.
I think it's not a good sample... I just showed the query to explain what
inline view is.
Anyway, in some cases, inline view can be replaced with a plain query. But
in some other cases, it cannot be.
Only temp table can be a alternate way replacing inline view in ASE.
You can find many documents related to "inline view" in www.


Thanks
Jinuki


Pablo Sanchez Posted on 2002-01-23 13:24:11.0Z
From: "Pablo Sanchez" <pablo@dev.null>
References: <PhPgse7oBHA.123@forums.sybase.com> <A3uiAS8oBHA.140@forums.sybase.com> <CrDscH#oBHA.189@forums.sybase.com>
Subject: Re: inline view
Date: Wed, 23 Jan 2002 06:24:11 -0700
Lines: 31
Organization: High-Performance Database Engineering
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <mXW5#HBpBHA.373@forums.sybase.com>
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: 207.225.105.222
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:886
Article PK: 94419


"jinwook" <jinwook@sybase.com> wrote in message
news:CrDscH#oBHA.189@forums.sybase.com...
> No, no, no. materialized view and inline view are not same.(I
think
> materialized view is also needed)
>
> "inline view" is similar to a subquery, but it is located after
"from"
> clause...
>
> example)
> SELECT iv.store_city, mv.prod_name, mv.sum_sales
> FROM sum_fact_store_prod mv, (SELECT DISTINCT store_city,
city_name
> FROM store) iv
> WHERE mv.store_city = iv.store_city
> AND iv.store_name = 'BELMONT'
> GROUP BY iv.store_city, mv.prod_name;
>
> What do you call it? Anyway oracle call it "inline view".

Ah yes, I see what you're saying.... yes, that's a nice feature in
Oracle. Works very well for Top X result set too.
--
Pablo Sanchez, High-Performance Database Engineering
www.hpdbe.com
Independent Contractor, available for short-term and long-term
contracts