[archive] New xfd

[Migrated content. Thread originally posted on 16 August 2010]

When you have a new xfd, how do you put in syscat for xdbc?
Thanks

It depends on what you mean by "new xfd".

If it is an XFD for a new table that is not already in the database then just do: addfile -a xfdname

If it is a newly updated xfd for a table that already exists in the database there are two ways to do update the table definition.

1. Use the xdbcutil -u option
2. Drop the table from the system catalog and then add the updated XFD. That is, at the asql prompt issue this query: drop table tablename;
Then exit the asql prompt and do: addfile -a xfdname

NOTE that in these examples I assume that the xfd and table have the same name.