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.
1069 views

AcuXDBC, table too big

Jump to solution

I have any VISION file with 2411 defined fields. This definition is this:

FD SWHF
LABEL RECORD OMITTED
DATA RECORD SWHR.
01 SWHR.
02 SWH-TA.
03 SWH-KY.
04 SWH-NRKYFA PIC 9(4).
04 SWH-XXKY PIC 9(9).
03 SWH-TAKURZ.
04 SWH-XXKURZ PIC X(3) OCCURS 200.
03 SWH-TANAME.
04 SWH-XXNAME PIC X(25) OCCURS 200.
03 SWH-TAKURS.
04 SWH-PRKURS PIC 9(5)V9(6) OCCURS 200.
04 SWH-KZRUND PIC 9 OCCURS 200.
04 SWH-BEKURS PIC 9(5) OCCURS 200.
03 SWH-TAKD.
04 SWH-KDKDKDIF PIC X(9) OCCURS 200.
04 SWH-KDKDSKOA PIC X(9) OCCURS 200.
04 SWH-KDKDSKDE PIC X(9) OCCURS 200.
04 SWH-KDWSFORD PIC X(9) OCCURS 200.
04 SWH-KDWSVERB PIC X(9) OCCURS 200.
03 SWH-DM PIC 9(6).
03 SWH-TATEILN.
04 SWH-KZTEILN PIC X OCCURS 200.
03 SWH-XXKURZ0 PIC X(3).
03 SWH-XXNAME0 PIC X(25).
03 SWH-PRKURS0 PIC 9(5)V9(6).
03 SWH-KZRUND0 PIC 9.
03 SWH-KZTEILN0 PIC X.
03 SWH-TADIRUM.
04 SWH-KZDIRUM PIC X OCCURS 200.
03 SWH-KDKDIF0 PIC X(9).
03 SWH-XXLEER PIC X(6031).
02 SWH-TAR REDEFINES SWH-TA PIC X(24500).

Because of this record structure you will get 2411 fields defined. This is too big for AcuXDBC. If I want to define a view for this table I get following message from system:

create view PUBLIC.SWHV_1234 as select SWH_NRKYFA, SWH_XXKY, SWH_XXKURZ_1, SWH_XXNAME_1, SWH_PRKURS_1, SWH_KZRUND_1, SWH_BEKURS_1 from PUBLIC.SWHF_1234
***** ERROR: VISION: Too many columns 2411 (max: 512)

Is it another way to define any view for tables with more than 512 columns? I need any possibility to do that for my customers.

Thanks.

Tags (2)
0 Likes
2 Solutions

Accepted Solutions
Micro Focus Expert
Micro Focus Expert

RE: AcuXDBC, table too big

Jump to solution

You can use directives. Such as 03 SWH-TAKD. you could have:

$XFD USE GROUP.

03 SWH-TAKD

I would try this on all of your table definitions.

View solution in original post

0 Likes
DougP Outstanding Contributor.
Outstanding Contributor.

RE: AcuXDBC, table too big

Jump to solution

In addition to the USE GROUP directive the SUBTABLE directive will be helpful:

documentation.microfocus.com/.../HHXRRHXDBC5T.html

View solution in original post

0 Likes
2 Replies
Micro Focus Expert
Micro Focus Expert

RE: AcuXDBC, table too big

Jump to solution

You can use directives. Such as 03 SWH-TAKD. you could have:

$XFD USE GROUP.

03 SWH-TAKD

I would try this on all of your table definitions.

View solution in original post

0 Likes
DougP Outstanding Contributor.
Outstanding Contributor.

RE: AcuXDBC, table too big

Jump to solution

In addition to the USE GROUP directive the SUBTABLE directive will be helpful:

documentation.microfocus.com/.../HHXRRHXDBC5T.html

View solution in original post

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.