NetBase for MPE Reference Guide

Chapter 4
4-56
SQLIN
The SQLIN command is used to define which DBE's are importing updates from which nodes. See
the NetBase SQL Shadowing Handbook for more information on how these records are used. This
command requires NODE MANAGER (NM) or SYSTEM MANAGER (SM) capability.
Syntax
D> SQLIN dbename node [;PRI=transaction-priority]
[;EXECPRI={BS|CS|DS|ES}]
[;ORIGDBE=dbename]
[;USEREXIT]
[;RESET]
To set up multiple import processes for one DBE:
D> SQLIN fakedbe1=dbename,node;PART=part1,[part2[,...]][...]
D> SQLIN fakedbe2=dbename,node;PART=...
To remove a SQLIN command:
D> SQLIN dbename, node;RESET
Parameters
Parameter Description
dbename
The name of the SQL DBE.
node
The node from which SQL transactions are received.
transaction-priority
The PRI option is used to set the priority on the BEGIN WORK for the
transaction being applied. This is important in the case of
deadlocks. The import process should have the highest priority of
all the processes on the system. This is because HP resolves a
deadlock by aborting the process with the lowest priority. The valid
range is 0 to 255 with the highest priority going to the lowest
number. The default is 0.
Continued