SERVPROF

Document containing Zim statements to be executed by the Zim Database Agent when it starts its execution.

Syntax

SERVPROF

Comments

The SERVPROF command, if it exists, is executed when the Database Agent process starts. This command can be used to do initialization.

If the database has Zim directories containing tables that are being accessed by clients, you must include ACCESS commands for those directories. If the server is accessing tables through other Server Access Modules, you must connect to those servers (using the CONNECT command) in SERVPROF or by executing a SERVEREXEC command from the client.

INITIALIZE

Freshly initializes per user entity sets and relationships with data.

Syntax

INITIALIZE PERUSER objectname

Parameters

objectname

 

An entity set name or relationship name (with fields).

 

Comments

INITIALIZE PERUSER creates a new physical file corresponding to the objectname. It eliminates the need of deleting all data from the object or copying physical files. Also, it doesn’t affect the internal data dictionary nor requires recompilation of programs after executing it.

It can be executed anytime a fresh file is needed.

objectname must be a PerUser object defined in the data dictionary and no longer needs to be indicated in the file “areas.zim”.

Example

If MyCustomer is an entity set defined as per user in the Data Dictionary, then the following statements are valid:

>INITIALIZE PERUSER MyCustomer

>ADD 1000000 MyCustomer FROM …

>FIND MyCustomer

>1000000 selected.

>INITIALIZE PERUSER MyCustomer

>FIND MyCustomer

>0 selected.

en_CAEnglish