|
I get the following error.to be
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
valid up to this point. Recovery . . . : Do one or more of thefollowing
and try the request again: -- Verify the SQL statement in the area ofview.
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=8
9070
)
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
TR.
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/rbafzcats
yspsta
t.htm
<https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_71/db2/rbafzcat
syspstat.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
----
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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
