topic Re: Selecting Data From Maintainence View in Application Development and Automation Discussions

Selecting Data From Maintainence View

Former Member — Mon, 30 Oct 2006 09:25:53 GMT

Hi,

I have a requirement to select data from V_001_B view,

but it's a maintainence view,

When use this in FROM clause, i get a syntax error .

Is there any other way say FM etc to select data from Maintainence views.

regards,

Raghavendra

Re: Selecting Data From Maintainence View

Former Member — Mon, 30 Oct 2006 11:57:10 GMT

Hi,

You can't select Data from Maintenace view.

Data can only be selected either from Projection or Database View.

You can select it from the corresponding tables.

Regards,

Nitin

Re: Selecting Data From Maintainence View

Former Member — Mon, 30 Oct 2006 12:03:54 GMT

Find the underlying database tables for the maintenance view and write the select on that table.

Regards,

Ravi

Re: Selecting Data From Maintainence View

Former Member — Tue, 31 Oct 2006 15:03:11 GMT

Hi,

Check the tables which are used in this view V_001_B. based on your select fields, you can use the respective tables and write separate Select statement using join for those respective tables.

thanks,

sksingh

Re: Selecting Data From Maintainence View

Former Member — Wed, 01 Nov 2006 09:50:02 GMT

Hi Raghu,

check for the underlying database tables for the maintenance view exists and write the select on that table.

regards

Manish yogendra

Re: Selecting Data From Maintainence View

Former Member — Wed, 01 Nov 2006 09:54:32 GMT

Hi Raghu,

check for the underlying database tables for the maintenance view exists and write the select on that table.

regards

Manish yogendra