Troubleshooting
Problem
Is there a way to substitute user-friendly column headings for the operating system column names when using IBM i Access Client Solutions Data Transfer?
Resolving The Problem
Is there a way to substitute user-friendly column headings for the operating system column names when using IBM Access Client Solutions Data Transfer?
Aliases can be used to provide users with descriptive column names. To specify a column alias in the transfer request, manually edit the Select clause. Click the "Data Options" button in the data transfer request.
Aliases can be used to provide users with descriptive column names. To specify a column alias in the transfer request, manually edit the Select clause. Click the "Data Options" button in the data transfer request.
In the "Select:" box, specify an alias using the syntax AS AliasName. For example, if running a data transfer request against test file QIWS/QCUSTCDT, aliases for the CUSNUM and LSTNAM fields can be specified in the "Select:" box as follows:
CUSNUM as Customer_Number, LSTNAM as LastName
Run the data transfer request and you will now have user-friendly column headings.
Alternatively, ACS data transfer allows execution of standard SQL statements. To do so, click the "Properties" button and then the "SQL" tab and select "Process SELECT as native SQL".
Click "OK".
Now, when clicking on the "Data Options" button in the data transfer request, you will be presented with an "SQL SELECT statement:" box. Here you could enter a complete SQL statement such as:
SELECT CUSNUM as Customer_Number, LSTNAM as LastName FROM "QIWS"/"QCUSTCDT" FOR FETCH ONLY
...and you will have the same column aliases.
[{"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->Data Transfer"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Version(s)"}]
Historical Number
23065339
Was this topic helpful?
Document Information
Modified date:
04 January 2021
UID
nas8N1017398