Set up a virtual database operation to extract data from Sybase Data Federation’s virtual database.
Prerequisites
Provision or generate a SQL view.
Follow these steps to create a virtual database operation:
In Enterprise Explorer,
connect to the grid domain controller (GDC) that hosts the SQL view
you want to query.
Pull down the File menu and select New > Other
The wizard selection dialog opens.
Expand Sybase > Data Federation and select Virtual Database Operation. Click Next.
Select the grid domain controller you connected to in step 1 and click Next.
Enter a name and, if you wish, a description for your virtual database operation.
Click Next again.
The Basic Operation Properties pages appears.
Enter the SQL statement this virtual database operation will use to query the virtual database. Be sure to include the name of the SQL view (table) you want to query. For information on SQL statements and syntax for the Data Federation virtual database, see the
Data Federation API Guide, part of the DI Suite documentation set, which is
available on the Sybase Product Manuals Web site at
http://sybooks.sybase.com.
Select the caching behavior for the results of this virtual database operation: don’t cache, never expire from cache, or expire after a length of time you specify here.
Select how this virtual database operation
will run: as the grid user who executes it, or as a grid user you specify here.
Click Next
and specify parameters if any are required. Each parameter needs a data type. If desired, also enter descriptions for the parameters. The virtual database operation execution dialog uses parameter descriptions to prompt the executing user for parameter values.
Click Finish to create your virtual database operation. WorkSpace displays the new virtual database operation
under Categories/ViewLibrary/VirtualDatabaseServices/Operations/.
For product-related issues, contact Sybase Technical Support at 1-800-8SYBASE. Send your feedback on this
help topic directly to Sybase Technical Publications: pubs@sybase.com