Consultor Eletrônico

SUMMARY:
This solution explains the behavior of the bulkload utility regarding tables with recid data type fields on it.


EXPLANATION:
The option to generate the Bulk Loader Description File of the Data Administration Tool will generate a .fd file with no recid fields when finding a table with fields with this data type.

The bulkloader itself will load recids, but the routine in the dictionary that creates the bulk load description files specifically excludes any recid fields (see prodict/dumpbulk.p or prodict/dump/dumpbulk.p). This is because loading creates new records, and the new records will most likely not have the same recids as they did before the dump.
While doing the bulkload using a .fd file which excludes the recid fields, you may get the errors (110) and/or (1529).


SOLUTION:
It is a simple matter for the user to add the recid fields definitions back into the .fd bulk loader description file, if that is really what is wanted.

Also, when you do a

FOR EACH <record>:
EXPORT <record>.

any recid fields in the <record> are not expanded.
For example, if "file-x" had as fields NAME as CHARACTER, AMOUNT as DECIMAL and POINTER as RECID, doing a

FOR EACH file-x:
DISPLAY file-x.

would only show NAME and AMOUNT. So the way we dump bulk load description files is compatible with this.


References to Written Documentation: