Building Databases

Description

This example shows how to build a database.

Example

set log c:\temp\hcengd.log;
set input c:\HRDMO\data\hcengd.db;
set no view;
set no space;
set no trace;
import *;
update PSLOCK set OWNERID = <OWNER_ID>;
update PSOPRDEFN set ACCESSID = <ACCESS_ID>, ACCESSPSWD = <ACCESS_ID_PSWD>,
 PTOPERPSWDV2= '0000000000000000' where OPRTYPE = 0;
update PSACCESSPROFILE set STM_ACCESS_ID = <ACCESS_ID>, STM_ACCESS_PSWD = <ACCESS_ID_PSWD>,
 VERSION = 0, ENCRYPTED = 0;
set log c:\temp\grant.log;
encrypt_password *;

Then run the resetpswd.dms data mover script from the PS_HOME/scripts directory.