Highlighted
Absent Member.
Absent Member.
527 views

[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
0 Likes
1 Reply
Highlighted
Absent Member.
Absent Member.

RE: [archive] New xfd

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.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.