Diagnostics
Symptom
WARNING: No fields available to be written.
Problem
Procedure in a custom provider fails to return groups to the client because a warning message is issued when writing to a HOLD file with COMT output.
Here is a sample of the procedure:
-SET &defaultRole = 6;
DEFINE FILE CAR
ROLE_ID/A10 = '&defaultRole.EVAL';
END
TABLE FILE CAR
DST.ROLE_ID
DST.ROLE_ID
COUNTRY NOPRINT
ON TABLE SET HOLDATTR OFF
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE HOLD AS JNONE FORMAT COMT
END
Solution
The warning message is preventing groups from being returned to the client even though they are written to the HOLD file.
To address this, change the statement from:
COUNTRY NOPRINT
To the following:
BY COUNTRY NOPRINT
This will remove the warning message. If there is no warning message, the groups are returned to the client.