Re: IBM Sample Tables

On Feb 9, 2022, at 6:38 PM, Sue Romano <slromano@xxxxxxxxxx> wrote:



Hi Jon,

There are actually 2 sets of sample tables. The "missing" ones are in the
XML set. You need to run a second procedure to establish them.
CALL QSYS.CREATE_XML_SAMPLE ('SAMPLEXML')
https://www.ibm.com/docs/en/i/7.4?topic=tables-sample-xml

I will try to get the embedded nature of these sections adjusted to make
this clear. It's rather messed up and confusing right now.

Just created the sample database on a new system with the standard CALL

QSYS.CREATE_SQL_SAMPLE ('SAMPLE').

Problem is that many of the tables that should be there according to

https://www.ibm.com/docs/en/i/7.3?topic=reference-db2-i-sample-tables <

https://www.ibm.com/docs/en/i/7.3?topic=reference-db2-i-sample-tables> are

not present. The most obvious ones (because I wanted to use them) are

PRODUCT and CUSTOMER.

Anyone seen this before? Run SQL scripts says it all ran OK.

Sue Romano
Db2 for IBM i Development
--
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