NetBase for MPE Reference Guide

Using NBDIR

4-57

Parameter Description

EXECPRI=BS|CS|DS|ES

Specifies the execution priority for the SQL import process.

ORIGDBE

Specifies the DBE name on the master.

USEREXIT

Specifies that a user exit routine should be called with each

transaction received for the defined file.

fakedbe1, fakedbe2

The pseudo name of the database to be used to administer the

partition. Use this name when starting and stopping the import

process for the partition.

PART=part1, part2

The partitions to be shadowed via this import process.

Example

To add a SQL DBE entry for a database file, accepting the default priority:

D> SQLIN PAYDBE1.DATA.PROD,4

To set up separate import processes per partition:

D> SQLIN DBE.PART1.PROD=DBEHERE.DATA.PROD,masternode;PART=1;ORIGDBE=MASTDBE;

EXECPRI=CS

To list the SQLIN records from the directory:

D> LISTSQLI @.@.@

Node: SHADOW Directory: NBD.DATA.NETBASE E

------LOCAL DBE NAME------ -----REMOTE EQUIVALENT----- I

File Group Account File Group Account Node T Pri

MMDBE PART1 PRODACT -> MMDBE DATAB PRODACT MASTER - 0

Exec Pri: CS Partitions: 1

MMDBE PART4 PRODACT -> MMDBE DATAB PRODACT MASTER - 0

Exec Pri: DS Partitions: 4

EEDBE DATAG PRODTWO -> --Same-- MASTER - 0

Orig DBE: CCDBE