For example, if your data is:
main.xfd ACCT01.dat ACCT02.dat ACCT03.dat
you might have an entry like this in list.txt:
where main is the XFD name, AcctTbl is the table/repository name, and Acct$$ represents the indexed file name.
For example, the configuration file might contain:
mfdbcutil -d c:\data\dict -f list.txt
When building the system catalog, mfdbcutil uses the XFD "main" to create a repository table called AcctTbl.
(For instructions on creating DSNs, see the section Setting Up DSNs on the Client.)
When a user accesses the table AcctTbl from SQL,Micro Focus XDBC looks in the configuration file for the FILENAME-WILDCARD variable, and, substituting 01 for $$, accesses the data file, Acct01. In programming terms, when "SELECT * from AcctTbl;" is issued, it functions as if SELECT * from acct01; was entered.
There is no limit on the number of wildcards/replacements that you can use with Micro Focus XDBC. You can change several characters in a filename, for example:
where the actual filename would be ACCTZ01AA and the configuration file entry would be:
FILENAME_WILDCARD >==Z ;$$=01;**=AA
You don't have to create a list file to specify your company wildcards. If you prefer, you can specify them directly on the mfdbcutil command line, like this:
mfdbcutil -d c:\data\dict -x c:\data\data -a mainxfd#AcctTbl#Acct$$