Troubleshooting
Problem
This document describes how to guarantee data transfer output is ordered by arrival sequence.
Resolving The Problem
This document describes how to guarantee data transfer output is ordered by arrival sequence.
Because the sort order of IBM i5/OS Access Data Transfer is not guaranteed, how can the data be transferred in arrival sequence?
This is accomplished by adding the "Relative Record Number" SQL clause :
RRN(TheFileName)
... in the "Order by" box of the Data Options button. Replace TheFileName with the name of the file being transferred. For example:
Because the sort order of IBM i5/OS Access Data Transfer is not guaranteed, how can the data be transferred in arrival sequence?
This is accomplished by adding the "Relative Record Number" SQL clause :
RRN(TheFileName)
... in the "Order by" box of the Data Options button. Replace TheFileName with the name of the file being transferred. For example:
Here is the same request as an SQL Query:
SELECT RRN(QCUSTCDT) AS RRN, QCUSTCDT.* FROM QIWS.QCUSTCDT ORDER BY RRN
Related Information
[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z000000cwMLAAY","label":"Data Access-\u003EData Transfer"}],"ARM Case Number":"TS015681209","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions"}]
Historical Number
350003899
Was this topic helpful?
Document Information
Modified date:
11 March 2024
UID
nas8N1015935