Re: Table Split based on columns

In a nutshell I do not have any pockets. I was hoping I could write
something or use some sort of JAVA plugin or something like that. I can
get the table to the IFS to work on it if needed.
Multisystem sound interesting. I think I recall hearing of it a long time
ago.

On Fri, Dec 10, 2021 at 11:29 AM Rob Berendt <rob@xxxxxxxxx> wrote:

How deep are your pockets?
If they are infinitely deep then you might want to look at the option DB2
Multisystem. Don't let the name "Multisystem" confuse you. There are
options in there IBM will NOT unbundle, like the option to have partitioned
tables on a single system. You may know "partitions" as "members". With a
partitioned table you can create a table which will automatically assign
rows to the correct partition based on date/quarter. See the partitioning
clause at https://www.ibm.com/docs/en/i/7.4?topic=statements-create-table
You only get the partitioning clause if you have DB2 Multisystem installed.
IBM's classic examples involve tables created for history temporal
tables. Allows you to get by things like maximum rows by using multiple
partitions(members). Need to purge history? Simply drop a partition.

We are not using DB2 Multisystem.

If you really go whole hog on DB2 Multisystem you can partition so that
the tables are spread across multiple systems (hence the name). For
example each warehouse might have their own system and their partition
would be local to their warehouse. Allows you to query all warehouses by
addressing a single table.
People who do this kind of stuff want us to pick up their bill by
purchasing DB2 Multisystem for just doing partitioning on a single system.
Spread the development cost around.

Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 7310 Innovation Blvd, Suite 104
Ft. Wayne, IN 46818
Ship to: 7310 Innovation Blvd, Dock 9C
Ft. Wayne, IN 46818
http://www.dekko.com


-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of K
Crawford
Sent: Friday, December 10, 2021 11:01 AM
To: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
Subject: Table Split based on columns

CAUTION: This email originated from outside of the organization. Do not
click links or open attachments unless you recognize the sender and know
the content is safe.


I have a table with several columns that I want to split into several
tables.
My source table example:
SrcTbl
Year qtr data
2020 1 bob
2020 1 sam
2020 2 fred
2020 2 dog
2021 2 cat

What I want would be three tables.
tbl_2020_1
2020 1 bob
2020 1 sam
tbl_2020_2
2020 2 fred
2020 2 dog
tbl_2021_2
2021 2 cat

The table would be created/populated based on the values of the columns.
Ideally the table name would contain the values of the values of the
columns used as the splitter.
The number of tables created would be dynamic.

Does Anyone have a simple/good solution?
Thinking I am going to have to write some sort of RPG program.

--
KCrawford
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com