I get the following error.
SQL State: 42601 Vendor Code: -104 Message: [SQL0104] Token NO was not
valid. Valid tokens: ALL CS CHG NONE RR RS UR NC. Cause . . . . . : A
syntax error was detected at token NO. Token NO is not a valid token. A
partial list of valid tokens is ALL CS CHG NONE RR RS UR NC. This list
assumes that the statement is correct up to the token. The error may be
earlier in the statement, but the syntax of the statement appears to be
valid up to this point. Recovery . . . : Do one or more of the following
and try the request again: -- Verify the SQL statement in the area of the
token NO. Correct the statement. The error could be a missing comma or
quotation mark, it could be a misspelled word, or it could be related to the
order of clauses. -- If the error token is <END-OF-STATEMENT>, correct the
SQL statement because it does not end with a valid clause.
This is a 7.3 machine that is way behind on PTFs. I don't know if that
makes any difference or not.
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Dan
Sent: Tuesday, December 29, 2020 8:15 PM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: PARTITION_TEXT column in QSYS2.PARTITION_STATISTICS (aka
SYSPARTITIONSTAT)
Asking for a favor from the community here. Please execute the following
SQL:
( SELECT *
FROM TABLE( QSYS2.PARTITION_STATISTICS('QTEMP', 'MBR_INF') ) X
) WITH NO DATA
then run DSPFFD QTEMP/MBR_INF and search for column VOLATILE. The column
immediately following VOLATILE should be the column that either is TEXT or
PARTITION_TEXT. You might even find it called LABEL. Please let me know
how that column is defined and the OS level.
Background:
An RFE I submitted a few years ago (
http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=89070)
was delivered for IBM i 7.1 and higher releases. Basically, the RFE asked
for a new column containing the member text for files' members be added to
the QSYS2.PARTITION_STATISTICS (aka SYSPARTITIONSTAT) catalog view.
The response from IBM in that RFE was that they added column PARTITION_TEXT.
The documentation for SYSPARTITIONSTAT (
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_71/db2/rbafzcatsyspsta
t.htm)
in all 7.1, 7.2, 7.3 & 7.4 renderings all reference PARTITION_TEXT.
However, on my 7.2 system, SYSPARTITIONSTAT has no column named
PARTITION_TEXT. The data is found in a column named TEXT.
I want IBM to correct this, either by changing the long column name to
PARTITION_TEXT and leaving the short (system) column name as TEXT *or*
correcting all of their documentation. Before I do that, though, I'd like
to learn from the community here on various OS levels what that column looks
like on their system.
Note: This column was added via TR for 7.1, 7.2, and 7.3. It's included in
7.4's base. According to IBM, "Enhanced with IBM i 7.3 SF99703 Level 3 and
IBM i 7.2 SF99702 Level 14". No info given for 7.1 TR.
--
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
midrange.com
