Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
Daniel7 Absent Member.
Absent Member.
1448 views

AcuXDBC, create System catalog

Jump to solution

I have got following Situation. If you want to create System catalog entries you should write

xfilename#tablename[tag:filename] 

AcuXDBC user's guide says at page 5-15. It means

xfilename                Name of XFD file
tablename               Name of database table use via AcuXDBC
filename                  Name of physical VISION file

Now, I have got any VISION files with equal XFD-structure and I want to join them to one table. Following example:

#xyz.xfd#xyz_table#xyz_file_1
#xyz.xfd#xyz_table#xyz_file_2
#xyz.xfd#xyz_table#xyz_file_3

More than one physical VISION files should be join to one AcuXDBC table. All data are supported by one table.

Is it a way to do this?

0 Likes
1 Solution

Accepted Solutions
Chuck Edgin Absent Member.
Absent Member.

RE: AcuXDBC, create System catalog

Jump to solution

You can't do this as you've described. But you can create a view to accomplish the same result.

First, create 3 tables corresponding to your 3 data files (but all using the same xfd).

Note that the xfd name should NOT include the ".xfd" extension - it's implied.

xdbcutil -d syscat -a xyz#xyz_table_1#xyz_file_1
xdbcutil -d syscat -a xyz#xyz_table_2#xyz_file_2
xdbcutil -d syscat -a xyz#xyz_table_3#xyz_file_3

Then, using the asql command-line utility, create a view named "xyz_table":

create view xyz_table as
  select * from xyz_table_1
    UNION ALL
  select * from xyz_table_2
    UNION ALL
  select * from xyz_table_3;

 

View solution in original post

0 Likes
2 Replies
Chuck Edgin Absent Member.
Absent Member.

RE: AcuXDBC, create System catalog

Jump to solution

You can't do this as you've described. But you can create a view to accomplish the same result.

First, create 3 tables corresponding to your 3 data files (but all using the same xfd).

Note that the xfd name should NOT include the ".xfd" extension - it's implied.

xdbcutil -d syscat -a xyz#xyz_table_1#xyz_file_1
xdbcutil -d syscat -a xyz#xyz_table_2#xyz_file_2
xdbcutil -d syscat -a xyz#xyz_table_3#xyz_file_3

Then, using the asql command-line utility, create a view named "xyz_table":

create view xyz_table as
  select * from xyz_table_1
    UNION ALL
  select * from xyz_table_2
    UNION ALL
  select * from xyz_table_3;

 

View solution in original post

0 Likes
Daniel7 Absent Member.
Absent Member.

RE: AcuXDBC, create System catalog

Jump to solution

Thank you very much. I tried and it is running successfully.

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.