The BULKRTV file is only used by the BULK RTRIEV function.
It holds parameters that can be longer than the limit of the REQUEST
file.
For the three parameters specified in Table 1, each can be specified up to
10 times. The number of times each is specified is set by the BR-NumSQL
parameter in the REQUEST file. Each parameter must be specified the
same number of times as the value of BR-NumSQL.
Input
records to the BULKRTV file are 32,752 bytes, variable length. Bytes
1 through 9 contain the label field, and bytes 10 through 32,752 contain
the value field. Values entered in the label field are left justified,
and are validated for specific values.
Table 1. The
relationship between the structured API request and the BULKRTV field
label
BULKRTV field label
Structured API request
FLISTNAME
BR-FListName
THREADDIR
BR-ThreadDir
SQLCLAUSE
BR-SQL
Figure 1 shows an
example of a BULKRTV file. The first two queries run in one thread
because they both use the same THREADDIR value. The third query runs
in a second thread. Figure 1. Example of a BULKRTV
RTRIEV function
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----9--------0
FLISTNAME /u/ussuser/bulkrtv/flist01
THREADDIR /u/ussuser/bulkrtv/dir01
SQLCLAUSE WHERE ACCOUNT_NUMBER IN ('123000022', '123000055', '123000261') AND POSTING_DATE = 12854
FLISTNAME /u/ussuser/bulkrtv/flist02
THREADDIR /u/ussuser/bulkrtv/dir01
SQLCLAUSE WHERE ACCOUNT_NUMBER IN ('123000287', '123000469') AND POSTING_DATE = 12854
FLISTNAME /u/ussuser/bulkrtv/flist03
THREADDIR /u/ussuser/bulkrtv/dir02
SQLCLAUSE WHERE ACCOUNT_NUMBER IN ('123000535', '123000709') AND POSTING_DATE = 12854