If your OS/400 user ID is authorized to invoke remote commands, CONNX uses its OS/400 remote command functionality to display index, key, and column/field definitions into temporary files in the QTEMP scratch pad. The output from the QTEMP temporary tables is then SELECTed via dynamic SQL, and returned to the CONNX CDD import utility. The following OS/400 CL commands are used:
DSPDBR (Display Data Base Relations)
DSPFD (Display File Description)
DSPFFD (Display File Field Description)
If your User ID is not authorized to use remote commands, index, key, and column/field definitions are imported from the QSYS2. metadata views.
