Re: Table Split based on columns

[K Crawford <kscx3ksc@xxxxxxxxx>]

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