UPDATE: Apparently you need to run this:

  • RCLDBXREF OPTION(*CHECK) if there is a problem try RCLDBXREF OPTION(*FIX). If that doesn’t work try RCLSTG SELECT(*DBXREF) when the system can be put into a restricted state and the system can be down for a bit.

Anyone else running into this issue?  Where the field names don’t show up when using Data Transfer from IBM i in IBMi Access for Windows 7.1?  You select the IBMi (running V7R1 TR10) and then the file name and click Data Options… and then Details and you’ll get these 2 error messages CWBDB0014 Internal Software error (System %1) and CWBDB0036 – Server returned SQL error Token / was not valid.

Click image below for a bigger picture

DataTransferFromIBMi