NetBase for MPE Reference Guide

Chapter 4
4-58
SQLOUT
The SQLOUT command is used to define which DBEs are to have transactions exported and to
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> SQLOUT dbename,node
;HOME=home-partition[,part2[,...]]
[;EXECPRI={BS|CS|DS|ES}]
[;FREQ=wakeup-seconds]
[;{INCLUDE|EXCLUDE}]
[;RESET]
[;USEREXIT]
D> SQLOUT dbename,@;PART=partition1[,partition2[,...]]
[;EXECPRI={BS|CS|DS|ES}]
[;FREQ=wakeup-seconds]
[;{INCLUDE|EXCLUDE}]
Parameters
Parameter Description
dbename
The name of the SQL DBE.
node
The node to which SQL transactions are transported.
home-partition
The home partition number is only entered on the export record
(SQLOUT). This is the home partition number of the local copy of
the DBE.
PART=partition1,
partition2
The list of partitions to export from the DBE to a user exit
(indicated by @ as the node).
EXECPRI=BS|CS|DS|ES
Specifies the execution priority for the SQL export process.
wakeup-seconds
Specifies the length of time that the export process will pause
between checks to see if new records have been added to the log
file. The pause only takes effect after a call to get the latest record
from the log file fails. The default is 20 seconds.
Continued