problems on select statement

[Former Member]

Hi Gurus,

Can anyone pls tell me will a select statement on a maintainence view work...................

pls it is urgent.

if it is possible pls tell me how............

<REMOVED BY MODERATOR>

Edited by: Alvaro Tejada Galindo on Apr 8, 2008 6:00 PM

[ThomasZloch]

and why can't you try this out for yourself?

[Former Member]

U cannot write a select on a maintenance view ..

Instead write select on the table for the maintenance view ...

[Former Member]

yes it is but u need access key to chenge the maintanece view code .

if you have the key then it is work.

[Former Member]

Hi,

the select statement on a maintanence view will work.

for example there is a view called MARCP. just perform a select query giving a condition in your select statement like how you perform for a transparent table. Views are nothing but transparent tables with selected fields between two or more tables.So the data exists in them.

<REMOVED BY MODERATOR>

thanks,

archana

Edited by: Alvaro Tejada Galindo on Apr 8, 2008 6:00 PM

[ThomasZloch]

MARCP is a database view.

Selecting on maintenance views is not possible.

Still don't know why the OP can't just try this, takes about 1 minute.

[prasanth_kasturi]

write down the select statement as you write for normal tables.

select the fields in the view in the query

regards

prasanth