NetBase SQL Shadowing Handbook

User Exits NetBase SQL

____________________________________________________________

3-2 QUEST Software, Inc. ver A0195

The names of the user exits must be as stated above, and they should reside in one of the

following libraries:

XL.NB.NETBASE XL.PUB.SYS (not recommended)

XL.PUB.NETBASE

The default library can be overridden by setting variables in NETBASE.JOB.NETBASE. You

may override the location for export_sql_exit by setting EXPORTSQLPROC to the name of the

library where the exit procedure resides. For post_sql_exit_before and post_sql_exit_after

you may define a new library using the POSTSQLPROC variable. Examples of these statements

are included in the job listed below.

!JOB NETBASE,MGR.NETBASE,PUB;HIPRI;OUTCLASS=,1;PRI=CS

!SETVAR EXPORTSQLPROC=XL.SPECIAL.PLACE

!SETVAR POSTSQLPROC=XL.SOMEWHER.ELSE

!SETJCW USEREXITTRACE=1

!COMMENT *** NETBASE job - Version 0.9.4 Upd 0

!CONTINUE

!PURGEGROUP TEMP

!CONTINUE

!NEWGROUP TEMP

!CONTINUE

!PURGE NBLOGBK.DATA

!CONTINUE

!RUN COPYN.LIB;INFO="FROM=NBLOG.DATA;TO=NBLOGBK.DATA"

!IF JCW >= FATAL THEN

! CONTINUE

! PURGE NBLOG.DATA

! CONTINUE

! BUILD NBLOG.DATA;REC=254,,V;DISC=256,1,1;CIR

!ENDIF

!SETDUMP

!CONTINUE

!RUN NBCOP.NB

!CONTINUE

!PURGEGROUP TEMP

!CONTINUE

!RUN PURGE.LIB

NBSE?#@.IPC

!EOJ

The user exits will be dynamically loaded by the import and export programs as needed.

Consequently, in order to update the user exits, you must stop exporting and posting in order to

unload the procedures and replace them.

All records that pass through the shadow export transport are sent to the export_sql_exit

procedure. The user exit can determine the disposition of each record, and it can individually

control logging if necessary. Since only one user exit procedure name is currently supported, the