Hello Sunny,

Sorry for my much delayed reply regarding your question through e-mail. I just misplaced your e-mail address and so I posted it here on UT forum.

Offline View totally works on behalf of the original remote view or local view. And so you can no longer modify the source view unless you drop the Offline view using DROPOFFLINE().

Offline View can be manipulated as Table using USE command. If you look further on the online help topic regarding USE command, there is an ADMIN|ONLINE option included. The said option pertains to offline views being open using USE command.

Here are partial explanations:

USE myofflineview [ONLINE|ADMIN] blah...blah...blah...

ONLINE Opens an offline view created with CREATEOFFLINE( ). Specify the name of the offline view in SQLViewName. Use TABLEUPDATE( ) to update data on the server.

The offline view must be opened exclusively. Include the EXCLUSIVE clause in USE or SET EXCLUSIVE to ON before opening the offline view with USE.

Please indicate your e-mail address when sending an e-mail.
ADMIN Opens an offline view created with CREATEOFFLINE( ), but does not update the data on the server with the changes made to the offline view.Opening an offline view with the ADMIN keyword allows you to make changes to the offline view without updating the data on the server.

Please indicate your e-mail address when sending an e-mail to me.

HTH