A user can use the STORE command to create tables containing SQL query output. Once a user executes a SQL query he may issue STORE which dynamically creates a table in the user's private authorization ID, and populates it with the Found Set. Queries executed against a personal table can have a faster processing time than queries run against public tables.
The user can manipulate personal table data for special needs, for specialized reports, for forecasting, or use the manipulated data in a business chart to help with decision making. Since all the data in the user's personal tables is generated by the user, the user is completely in charge of what is done with the data.
Here are some considerations for the use of PDB (personal data base) and the STORE command. With these functions, tables are CREATED (by using SQL) into an area specified in the user's profile (this profile information is still used even when external security is in effect for CA Dataquery). The area must be in a database for which the user has both "create" authority and CA Dataquery authority to do maintenance. The area and database should be built separately for each user (or group of users) that are allowed PDB authority, so that these tables are not put into any arbitrary database. See the CA Datacom/DB Database and System Administration Guide for information about how to set up a database for SQL use.
|
Copyright © 2014 CA.
All rights reserved.
|
|