How to create a table inside a table in the dictio...
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
I don't think it would be possible to create a nested table in data dictionary. You can create a structure inside a table but structures as such do not hold data independently. Even with pool or cluster tables in the data base there is single table with many data dictionary entity.
It is not possible to have a table inside a table in the database, But you can go with the logical database, you can create a logical database in the required format and later you can use that inyour program.
If you need multiple fileds based on a single line entry then , first figure out the relationships between these tables.
Then create a second table with a part of the primary key as the first and a unquie primary key to be defined for adding all the rest of the entries in the second table.
Also maintain the foreign key relationships between these tables.
This is the way to have multiple entries for a single line of a table entry.
This is impossible to include or create a TABLE insdie another TABLE, but you can solve this to include at max nine nested structure in the table using INCLUDE or can append the structures in the table. This will result in adding some more fields in the already defined TABLE.
Bluesky
