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:
xdbcutil -d c:\data\dict -f list.txt
When building the system catalog, xdbcutil uses the XFD "main" to create a repository table called AcctTbl.
When a user accesses the table AcctTbl from SQL,AcuXDBC 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 AcuXDBC. 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 xdbcutil command line, like this:
xdbcutil -d c:\data\dict -x c:\data\data -a mainxfd#AcctTbl#Acct$$
You may have to escape the wildcard characters if they are shell interpreted. For example, the sample above would not work on UNIX, because the shells interpret the $ character. You would have to use:
xdbcutil -d /data/dict -x /data/data -a mainxfd#AcctTbl#Acct\$\$
xdbcutil -d /data/dict -x /data/data -a "mainxfd#AcctTbl#Acct$$"