Your query attempts to delete all of a table and part of the same table. Remove at least one D. row.
One D. row has no conditions, which means that all rows of the table would be deleted. A second D. row has at least one condition, which means that only the rows that meet the condition would be deleted.
Decide whether you want to delete all the rows or only some of the rows. Then remove the contradictory D. row.
Query is too long.
Before executing, your QBE query is translated into SQL. In this case, the resulting SQL query is too long for an internal storage area, and cannot be executed.
Try to use two or more shorter queries to accomplish the same objective.
Row &V3 of example table &V1 does not have an I. operator.
If one row of an example table has an I. operator, every row must have an I operator.
Put an I. operator in the row-operator area of every row of table &V1..
Column &V2 in row &V3 of example table &V1 has insert data but no column name.
If a column has insert data, it must also contain the name of the column into which the data is to be inserted.
Name the column or remove the insert data.
Row &V3 of example table &V1 has an I. but no insert data.
You must supply insert data in at least one column. An entire row of nulls may not be inserted into a table.
Put data to be inserted in at least one column of the table or remove the I.
See DSQ80012
Follow the directions in the referenced message.
Row &V2 in table &V1 attempts to retrieve row data from a group.
You cannot retrieve row data from a group, as in the following invalid example.
Invalid
Query:
Q.STAFF | NAME | DEPT |
--------+--------+------|
| _N | G._Y |
| |
------+--------|
P. | _N |The target table attempts to retrieve NAME, but NAME is part of the DEPT group.
Remove row references to the group.
A row with grouping has an invalid link.
A row that has grouping may be linked only to a row from which data is retrieved. In the following example, the Q.STAFF row has grouping and is invalidly linked to the Q.ORG row.
Invalid query:
Q.EMP | DEPT | | SALARY |
------+------+----------+--------|
| P.G. | P.AVG._S | _S |
| CONDITIONS |
|------------------|
| AVG._S> AVG._S1 |
Q.STAFF | SALARY | DEPT |
--------|---------+-------|
| _S1 | _D G. |
Q.ORG | DEPT | LOCATION |
------+-------+----------|
| _D G. | BOSTON |Remove the invalid link.
Example element &V4 in column &V3 of row &V2 in example table &V1 must represent a column of a named example table.
The example element of the message does not represent a column in any of the tables named in your query. Because of this, your query cannot be run.
Either remove all references to the undefined example element or define it. Define it by placing its name alone (except for QBE operators) in the column it represents. Example: Adding _SAL to the SALARY column of Q.EMP in the query below defines _SAL as representing that column.
Q.EMP | NAME | SALARY | COMM |
------+------+----------+-------|
| P. | P. _SAL | >_SAL |See DSQ50445
Follow the directions in the referenced message.
Row &V2 of target table &V1 cannot have both grouped and row data.
A row in a target table cannot have both grouped and row data. Example:
Invalid query:
Q.STAFF | NAME | SALARY | DEPT |
------+------+--------+------|
| _N | | |
| | _S | G. |
| | |
-----+----+--------|
P. | _N | AVG._S |The target table refers to row data with the _N link, and to group data with the reference to AVG._S.
Change the target table row to reference either all row data or all group data.
Row &V2 of target table &V1 is not linked to any row in a named example table.
Row &V2 of target table &V1 must have an example element that is defined in some row of a named example table. Such an element links the target table row to the example table row. Example:
Q.STAFF | NAME | SALARY | COMM |
--------+------+--------+--------|
| _N | _S | _C |
| | |
--------+------+--------|
P. | _N | _S+_C |Here, the row in the target table is linked to the row in the Q.STAFF example table by the example elements _N, _S, and _C.
In row &V2 of target table &V1, use at least one example element that is defined in some row of a named example table.
A condition has an invalid row and group reference.
A condition may not have a group and a row reference to rows from which data is retrieved. In the following example, an attempt is made to compare the average salary for a group to the commission for a row.
Invalid query:
Q.EMP | DEPT | | SALARY | COMM |
------+------+----------+---------+------|
| P.G. | P.AVG._S | _S | _C |
| CONDITIONS |
|-------------|
| AVG._S>_C |Correct the condition. For example,
Q.EMP| DEPT | | SALARY | COMM |
-----+------+----------+--------+------|
| P.G. | P.AVG._S | _S | _C |
| CONDITIONS |
|----------------|
| AVG._S>AVG._C |Column &V3 of row &V2 in table &V1 attempts to retrieve row data from a group.
If a row has a G. or is referenced by an aggregate, the row is part of a group. Only group data may be retrieved from a group. The following invalid example attempts to retrieve the NAME, which is row data from a group formed on DEPT.
Invalid
Query:
Q.STAFF| NAME| SALARY| DEPT | |
-------+-----+-------+------+----------|
| P. | _S | G. | P.AVG._S |Remove the P. from the column that is not part of the group.
See DSQ50445
Follow the directions in the referenced message.
Row &V2 of example table &V1 does not have a U. Each row of an update table must have at least one U.
If one row of an example table has a U., every row of it must have at least one U.
Put a U. in at least one column of every row of example table &V1..
Row &V2 of example table &V1 has a U. but no data.
You must supply update data in at least one column of row &V2 in table &V1..
Put update data in at least one column of the example table.
Column &V3 of example table &V1 has a U. but no column name.
If a column has a U., it must also have the name of the column to be updated.
Give the column that has a U. the name of the column to be updated.
Column &V3 of row &V2 in example table &V1 has a U. but no update data.
If a particular column and row has a U., it must also have update data.
Put update data in the column and row that has a U.
&V4 in column &V3 of row &V2 in example table &V1 must represent data in the same row.
Data in a row can only be updated by data in the same row. For example,
Q.STAFF | SALARY | SALARY |
-----------+---------------+----------|
| U. _SAL*1.15 | _SAL |Note that SALARY in each row is updated using an existing value in the same row. A value of 10000 in the SALARY column will, for example, be updated to 11500.
Use the example element, &V4, to represent data in row &V2 of example table &V1.
See DSQ80012
Follow the directions in the referenced message.
See DSQ50445
Follow the directions in the referenced message.
Condition &V2 in CONDITIONS box &V1 refers to a row and to a group containing the same row.
The first condition in the CONDITIONS box of the following query is invalid because it has both a group reference (AVG._CO) and a row reference (_S) to the same row (the second row of Q.EMP).
Invalid query:
Q.EMP | NAME | SALARY | COMM | DEPT |
----+------+--------+------+------|
P. | | | | |
| | _S | _CO | |
| CONDITIONS |
|--------------|
| _S > AVG._CO |
| |This type of query is invalid because a group must be formed from rows that meet the condition, but it cannot be determined which rows meet the condition until the group is formed.
Rewrite the query so that the condition references separate rows. For example, the query above could be rewritten as follows:
Q.EMP | NAME | SALARY | COMM | DEPT |
------+------+--------+------+------|
P. | | _S | | |
| | | _CO | |
| CONDITIONS |
|--------------|
| _S > AVG._CO |
| |The condition in column &V3 of row &V2 in example table &V1 refers to a row and to a group containing the same row.
A group is formed from rows that meet the condition, but it cannot be determined which rows meet the condition until the group is formed. For example,
Invalid query:
Q.STAFF | NAME | SALARY | COMM |
--------+------+----------+------|
P. | _N | | |
| _N | < AVG._C | _C |Remove the group and row reference to the same row. For example, the above query could be rewritten as follows:
Q.STAFF | NAME | SALARY | COMM |
--------+------+----------+------|
P. | _N | < AVG._C | |
| _N | | _C |Condition &V2 in CONDITIONS box &V1 links a grouped row to a row without a P., D., or U. operator.
In the following example, the condition in the CONDITIONS box links the grouped third row to the second row, but the second row does not have a P. operator.
Invalid query:
Q.EMP | DEPT | SALARY | COMM |
------+------+--------+------|
P. | | >_X+_Z | |
| | _X | _Z |
| G. | | _Y |
| CONDITIONS |
|------------|
| _Z> AVG._Y |Remove the invalid link. You may want to use two separate QBE queries to get the desired results.
Column &V3 of row &V2 in example table &V1 links a grouped row to a row without a P., D., U., or I. operator.
In the following example, row 3 is linked to the second row, but the second row does not have a P. operator.
Invalid query:
Q.STAFF | DEPT | SALARY | COMM |
------+-------+--------+---------|
P. | | >_X | |
| | _X | >AVG._Y |
| G. | | _Y |Remove the invalid link. You may want to use two QBE queries to obtain the desired results.
Condition &V2 in CONDITIONS box &V1 refers to two rows that are grouped.
In the following example, the condition in the CONDITIONS box has invalid references to two rows that are grouped.
Invalid query:
Q.STAFF | NAME | DEPT | SALARY | COMM |
--------+------+------+--------+------|
P. | | _D | | |
| | G._D | | _C |
Q.EMP | DEPT | SALARY |
------+------+--------|
| G. | _S |
| CONDITIONS |
|-----------------|
| AVG._C < AVG._S |Remove or change the condition that refers to the two rows that are grouped. You may want to use two QBE queries to obtain the desired results.
Column &V3 of row &V2 in example table &V1 links two grouped rows.
In the following example, the second row of Q.EMP is a grouped row that is linked to the grouped row in Q.SALE.
Invalid Q.EMP | DEPT | SALARY | COMM |
query: ------+------+---------+------|
P. | | >AVG._X | |
| G._D | _X | |
Q.SALE | DEPARTMENT | ITEM |
-------|------------+------|
| G. _D | PEN |Remove the link between grouped rows. You may want to use two QBE queries to obtain the desired results.
Column &V3 of row &V2 in example table &V1 links a grouped row to more than one other row.
A grouped row must be linked to one and only one other row.
Invalid Q.EMP | NAME | SALARY |
query: ------+------+----------|
P. | | >AVG._S |
P. | | >MAX._C |
Q.STAFF | DEPT | SALARY | COMM |
-------+------+--------+------|
| G. | _S | _C |The query is invalid because DEPT in Q.STAFF is linked to two rows in Q.EMP.
Use separate rows, if possible. For example,
Q.EMP | NAME | SALARY |
------+------+----------|
P. | | >AVG._S |
P. | | >MAX._C |
Q.STAFF | DEPT | SALARY | COMM |
-------+------+--------+------|
| G. | _S | |
| G. | | _C |Condition &V2 in CONDITIONS box &V1 links a grouped row to more than one other row.
A grouped row must be linked to one and only one other row. Invalid query:
Q.EMP | SALARY | | CONDITIONS |
--------+--------| |------------|
P. | _SA | | _SA>AVG._S |
P. | _CO | | _CO>MAX._C |
Q.STAFF | DEPT | SALARY | COMM |
--------+------+--------+------|
| G. | _S | _C |Q.STAFF is invalidly linked to both Q.EMP rows by the conditions.
Use separate rows, if possible. For example, change Q.STAFF.
Q.STAFF | DEPT | SALARY | COMM |
--------+------+--------+------|
| G. | _S | |
| G. | | _C |See DSQ50445
Follow the directions in the referenced message.
System problem in FP function. FPCODE = &1.
Follow the directions in the referenced message.
See DSQ50445
Follow the directions in the referenced message.
Free storage failed.
Follow the directions in the referenced message.
Please give a value for each variable name.
You must provide a value for &V2 and for any other variable name used in the procedure or query.
Give a value in the prompt panel for &V2 and for any other variable name used. Then press enter to complete your command. You may also use substitution variables as in the following examples:
RUN QUERY (&NAME = 'JASON SMITH', &YEARS=5 RUN PROC (&DNO = DEPARTMENT CONVERT QUERY (&ID = 10
&V2 has an invalid value of &V3..
The value for &V2 may have been truncated in the message. Some examples of invalid values follow:
Invalid values: 32A54 - Invalid integer value 'JAMES - Missing closing apostrophe "Q"DEPT" - Invalid embedded quote
Provide a value in the correct form.
Value for &V2 is longer than 55 characters.
You have used a RUN option of the form
&&V2 = value
where 'value' is longer than the limit of 55 characters. (If you followed this option with another one, be sure to separate the two with a comma or blank.)
Use a different value and run the query again.
The variable beginning with &V2 is longer than 18 characters.
Variable names cannot have more than 18 characters.
Choose a shorter variable name.
More than 100 substitution variables referenced.
A query or procedure cannot be run, nor a query converted, if it contains references to more than 100 different names of the form '&variable'.
Reduce the number of substitution variables referenced to 100 or fewer and try again.
See DSQ50445
Follow the directions in the referenced message.
Unequal number of '(' and ')' in column &V3 of row &V2 in table &V1..
An expression must have an equal number of left and right parentheses.
Correct the expression.
'&V4' cannot follow '&V5' in column &V3 of row &V2 in table &V1..
You may have used a comparison operator as other than the first element of a condition, or you may have tried to use an AND or OR in an example table. For example, the use of > after _S in the following query is invalid.
Invalid query: Q.STAFF | NAME | SALARY | COMM | --------+------+------------+------| P. | | _S > 20000 | < _S |
You may want to use a CONDITIONS box, as follows:
Q.STAFF | NAME | SALARY | COMM | --------+------+--------+------| P. | | _S | _C | | CONDITIONS | |------------------------| | _S > 20000 AND _C < _S |
See DSQ80012
Follow the directions in the referenced message.
System problem in FP function. FPCODE = &1.
Follow the directions in the referenced message.
See DSQ50445
Follow the directions in the referenced message.
System problem in FP function. FPCODE = &1.
Follow the directions in the referenced message.
See DSQ50445
Follow the directions in the referenced message.
Free storage failed.
Follow the directions in the referenced message.
'&V3' cannot end condition &V2 in CONDITIONS box &V1..
The condition is incomplete. Each condition in a CONDITIONS box must be complete on one line.
Complete the condition on one line. If necessary, use the ENLARGE command to enlarge the CONDITIONS box.
Unequal number of '(' and ')' in condition &V2 in CONDITIONS box &V1..
A condition must have the same number of left and right parentheses.
Correct the condition.
'&V3' cannot follow '&V4' in condition &V2 of CONDITIONS box &V1.. An 'AND', 'OR', or end of condition was expected.
The condition is incomplete. Each condition must be complete on one line of the CONDITIONS box.
Complete the condition on one line. If necessary, use the ENLARGE command to enlarge the CONDITIONS box.
'&V3' cannot follow '&V4' in condition &V2 of CONDITIONS box &V1.. A comparison operator was expected.
A condition was ended by '&V3'. You may be missing an arithmetic operator or you may have inadvertently embedded a blank between '&V4' and '&V3'.
Correct the condition.
'&V4' cannot end the expression or condition in column &V3 of row &V2 in table &V1..
The expression or condition is incomplete.
Complete the expression or condition.
'&V4' cannot follow '&V5' in column &V3 of row &V2 in table &V1..
An example element or a numeric constant is followed by an element that causes a syntax error. You may have:
Fix the expression or condition.
'&V4' cannot follow '&V5' in column &V3 of row &V2 in table &V1.. A comparison operator was expected.
NOT must be followed by one of the following:
Correct the condition.
'&V4' cannot follow '&V5' in column &V3 of row &V2 in table &V1.. Character data was expected.
LIKE must be followed by character data. For example, display the NAME and SALARY of those whose names begin with JA.
Q.STAFF | NAME | SALARY | --------+----------+--------| P. | LIKE JA% | |
Correct the condition.
A '(' must follow 'IN' in column &V3 of row &V2 in table &V1..
IN must be followed by a list of constant values that are enclosed in parentheses.
Correct the parentheses error.
'&V4' may not appear in the list of elements after 'IN' in column &V3 of row &V2 in table &V1..
Only constant values can appear in a IN list. For example,
IN (NY,PA,CA,MD)
Correct the IN list.
'&V4' cannot follow '&V5' in column &V3 of row &V2 in table &V1.. The list of constants after 'IN' must be separated by commas and end with ')'.
You may have omitted a comma or right parenthesis. The following is an example of a correct IN condition.
IN (NY,PA,CA,MD)
Correct the condition.
Unequal number of '(' and ')' following 'BT' or 'BETWEEN' in column &V3 of row &V2 in table &V1..
The expression following BT or BETWEEN and preceding AND is missing either a left or a right parenthesis.
Correct the condition.
'AND' must separate the first and second expression of the BETWEEN condition in column &V3 of row &V2 in table &V1..
The first expression following BT or BETWEEN must be followed by AND and a second expression. For example,
BETWEEN 20000 AND 30000
Correct the condition.
'&V4' cannot be the first element of an expression in column &V3 of row &V2 in table &V1..
The expression must begin with one of the following:
Correct the expression.
The expression following a built-in function in column &V3 of row &V2 in table &V1 must contain an example element.
The expression following a built-in function is meaningless without an example element. For example:
Invalid Query:
Q.STAFF | NAME | SALARY | COMM |
--------+------+--------+------------|
P. | | | >AVG.(200) |Correct the built-in function. For example:
Q.STAFF | NAME | SALARY | COMM |
--------+------+--------+------------|
P. | | | >AVG._C |
| | | _C |'&V4' cannot follow '&V5' in column &V3 of row &V2 in table &V1..
A character constant, USER, or NULL is followed by an invalid element. You may have:
Correct the expression.
'&V4' cannot follow '&V5' in column &V3 of row &V2 in table &V1..
One of the following was expected:
Correct the expression.
A built-in function cannot contain another built-in function in column &V3 of row &V2 in table &V1..
A built-in function cannot contain another built-in function. The following is an example of the invalid form:
SUM.(AVG._SAL)
Correct the expression.
'&V4' cannot follow '&V5' in column &V3 of row &V2 in table &V1..
One of the following was expected:
Correct the expression.
&V4 cannot follow '&V5' in column &V3 of row &V2 in table &V1..
One of the following was expected:
Correct the expression.
'UNQ.' or 'COUNT.' may not be used in an expression in column &V3 of row &V2 in table &V1..
UNQ., COUNT., and CNT. cannot be used with a built-in function that is part of an expression. The following are examples of invalid and valid uses of UNQ. and COUNT.
INVALID VALID .5*AVG.UNQ._SAL .5*AVG._SAL COUNT.(_SAL+_COMM) COUNT._SAL SUM.UNQ.(_SAL+_COMM) SUM.(_SAL+_COMM) CNT._SAL/2 CNT._SAL
Correct the expression.
'UNQ.' or 'ALL.' must be followed by an example element or a '(' in column &V3 of row &V2 in table &V1..
A built-in function must be followed by either an example element or an expression beginning with a left parenthesis.
Correct the built-in function.
Condition &V2 in CONDITIONS box &V1 contains no example elements.
A condition in a CONDITIONS box must contain at least one example element that is defined in the query. Example:
Invalid Query: Q.STAFF | NAME | SALARY | --------+------+--------| P. | | _S | | CONDITIONS | |------------| | _S > 20000 | | 30000 |
Condition 1 in the query above is valid: It contains the example element _S, which is defined to represent the SALARY column in Q.STAFF. Condition 2, however, is invalid because it contains no example elements.
Use at least one example element in the condition.
'COUNT.' or 'CNT.' must be followed by an example element or 'UNQ.' in column &V3 of row &V2 in table &V1..
You may not use ALL. or an expression after CNT. or COUNT.
Correct the built-in function.
Condition &V2 in CONDITIONS box &V1 is incomplete.
A condition in a CONDITIONS box must be complete on one line. You may have tried to continue a condition onto a second line.
Complete the condition on one line. If necessary, use the ENLARGE command to widen the CONDITIONS box.
'&V3' cannot follow '&V4' in condition &V2 of CONDITIONS box &V1..
An example element or numeric constant is followed by an element that causes a syntax error. You may have:
Fix the expression or condition.
'&V3' cannot follow '&V4' in condition &V2 of CONDITIONS box &V1.. A comparison operator was expected.
A condition was ended by '&V3'. You may be missing an arithmetic operator or you may have inadvertently embedded a blank between '&V4' and '&V3'.
Correct the condition.
'&V3' cannot follow '&V4' in condition &V2 of CONDITIONS box &V1.. Character data was expected.
LIKE must be followed by character data. For example, display NAME and SALARY of those whose names begin with JA or with SM.
Q.STAFF | NAME | SALARY | --------+----------+--------| P. | _N | | | CONDITIONS | |----------------------------| | _N LIKE JA% OR _N LIKE SM% |
Correct the condition.
A '(' must follow 'IN' in condition &V2 of CONDITIONS box &V1..
IN must be followed by a list of constant values that are enclosed in parentheses.
Correct the parentheses error.
'&V3' may not appear in the list of elements after 'IN' in condition &V2 of CONDITIONS box &V1..
Only constant values can appear in a IN list. For example,
IN (NY,PA,CA,MD)
Correct the IN list.
'&V3' cannot follow '&V4' in condition &V2 of CONDITIONS box &V1.. The list of constants after 'IN' must be separated by commas and end with ')'.
You may have omitted a comma or right parenthesis. The following is an example of a correct IN condition.
IN (NY,PA,CA,MD)
Correct the condition.
Unequal number of '(' and ')' following 'BT' or 'BETWEEN' in condition &V2 of CONDITIONS box &V1..
The expression following BT or BETWEEN and preceding AND is missing either a left or a right parenthesis.
Correct the condition.
'AND' must separate the first and second expression following BETWEEN in condition &V2 of CONDITIONS box &V1..
The first expression following BT or BETWEEN must be followed by AND and a second expression. For example,
BETWEEN 20000 AND 30000
Correct the condition.
'&V3' cannot be the first element of an expression in condition &V2 of CONDITIONS box &V1..
The expression must begin with one of the following:
Correct the expression.
The expression following a built-in function in condition &V2 of CONDITIONS box &V1 must contain an example element.
The expression following a built-in function is meaning- less without an example element. For example:
Invalid Query: Q.STAFF | NAME | COMM | --------+------+------| P. | | _C | | CONDITIONS | |------------------| | _C > AVG.(10000) |
Instead, use a query like the following:
Q.STAFF | NAME | COMM |
--------+------+-------|
P. | | _C |
| | _COMS |
| CONDITIONS |
|----------------|
| _C > AVG._COMS |Correct the built-in function.
'&V3' cannot follow '&V4' in condition &V2 of CONDITIONS box &V1..
A character constant, USER, or NULL is followed by an invalid element. You may have:
Correct the expression.
'&V3' cannot follow '&V4' in condition &V2 of CONDITIONS box &V1..
One of the following was expected:
Correct the expression.
A built-in function cannot contain another built-in function in condition &V2 of CONDITIONS box &V1..
A built-in function cannot contain another built-in function. The following is an example of the invalid form:
SUM.(AVG._SAL)
Correct the expression.
'&V3' cannot follow '&V4' in condition &V2 of CONDITIONS box &V1..
One of the following was expected:
Correct the expression.
'&V3' cannot follow '&V4' in condition &V2 of CONDITIONS box &V1..
One of the following was expected:
Correct the expression.
'UNQ.' or 'COUNT.' may not be used in an expression in condition &V2 of CONDITIONS box &V1..
UNQ., COUNT., and CNT. cannot be used with a built-in function that is part of an expression. The following are examples of invalid and valid uses of UNQ. and COUNT.
INVALID VALID .5*AVG.UNQ._SAL .5*AVG._SAL COUNT.(_SAL+_COMM) COUNT._SAL SUM.UNQ.(_SAL+_COMM) SUM.(_SAL+_COMM) CNT._SAL/2 CNT._SAL
Correct the expression.
'UNQ.' or 'ALL.' must be followed by an example element or a '(' in condition &V2 of CONDITIONS box &V1..
A built-in function must be followed by either an example element or an expression beginning with a left parenthesis.
Correct the built-in function.
'NOT' cannot precede '&V3' in condition &V2 of CONDITIONS box &V1..
NOT may not be used in a CONDITIONS box to precede the <, >, <=, >=, or =. The following are examples of valid versus invalid forms.
VALID INVALID NOT _A > _B _A NOT > _B
Correct the condition.
Condition &V2 in CONDITIONS box &V1 has an arithmetic expression that contains a character constant.
You cannot use character constants in an arithmetic expression.
Remove all character constants from the expression.
'COUNT.' or 'CNT.' must be followed by an example element or 'UNQ.' in condition &V2 of CONDITIONS box &V1..
You may not use ALL. or an expression after CNT. or COUNT.
Correct the built-in function.
Uneven number of single quotes in condition &V2 of CONDITIONS box &V1..
Single quotes may be used to enclose a constant. Also, two adjacent single quotes are used to signify a single quote. For example:
O''BOYLE (interpreted to mean,
O'BOYLE)
'P. LANGAN' (interpreted to mean,
P. LANGAN)Make sure that there are an even number of single quotes in the constant.
Double quotes are invalid in condition &V2 of CONDITIONS box &V1..
Double quotes are not valid in this context.
Remove the invalid double quotes.
'&V3' is an invalid comparison operator in condition &V2 of CONDITIONS box &V1..
Only the following comparison operators are valid:
> < >= <= = ¬=
Correct the comparison operator.
Exponent is missing from '&V3' in condition &V2 of CONDITIONS box &V1..
An exponent must appear in the number as in the following example:
456783E2
Correct the constant.
Double quotes are invalid in condition &V2 of CONDITIONS box &V1..
Double quotes may not appear in a condition.
Remove the double quotes from the condition.
Shift-in character is missing from '&V4' in condition &V2 of CONDITIONS box &V1..
A DBCS constant must end with a shift-in character.
Correct the DBCS constant.
'&V3' is an invalid DBCS constant in condition &V2 of CONDITIONS box &V1..
A DBCS must appear as follows:
G'...DBCS...'
Correct the DBCS constant.
'&V3' is an unrecognized special character in condition &V2 of CONDITIONS box &V1..
QBE does not recognize '&V3' as a meaningful character. If you want to retain the special character, you must enclose the constant in which it appears in single quote. In the following example, ; is a special character that is part of the constant, P;SMITH.
| CONDITIONS |
|-------------|
| 'P;SMITH' |Remove '&V3' from the query, or enclose it in single quotes.
'&V4' is an unrecognized special character in column &V3 of row &V2 in table &V1..
QBE does not recognize '&V4' as a meaningful character. If you want to retain the special character, you must enclose the constant in which it appears in single quotes. In the following example, ; is a special character that is part of the constant, P;SMITH.
Q.STAFF | NAME |
--------+-----------|
P. | 'P;SMITH' |Remove '&V4' from the query, or enclose it in single quotes.
A constant in your query exceeds 254 characters in length.
A constant may not exceed 254 characters in length.
Reduce the length of the constant.
You have no more storage space.
Your command cannot be executed because you don't have any space left in your virtual storage or in the QMF internal buffer.
Use a RESET DATA command. This should give you additional storage space. If you are not using DATA now, perhaps more storage space is necessary for your session. If this error repeats, contact your QMF administrator. If you are running a QBE query, reduce your query operation rows until you no longer receive the message.
Invalid function code '&1' passed to module.
This is a system error. Please see your system administrator for assistance, or consult the Installing and Managing QMF manual for your operating system.
The view has not been specified yet.
You cannot run an ER prompted query until you have specified the view.
When your query is displayed use the Specify View function to specify the view for your query.
Invalid function code '&1' passed to module.
Follow the directions in the referenced message.
See DSQ84300
Follow the directions in the referenced message.
Free storage failed.
This is a system error. Please see your system administrator for assistance, or consult the Installing and Managing QMF manual for your operating system.
Invalid storage pool id: &1.
This is a system error. Please see your system administrator for assistance, or consult the Installing and Managing QMF manual for your operating system.
Invalid list item index: &1.
This is a system error. Please see your system administrator for assistance, or consult the Installing and Managing QMF manual for your operating system.
The tool group &V1 does not exist.
The tool group you named does not exist or it is misspelled. You can list the names of the tool groups you may include in your query by using your List function.
Check the spelling of the tool group name. Either retype the name, or select it from the list of tool groups.
Prompted Query Manager Error - unexpected input.
This is a system error. See your system administrator for assistance, or consult the Installing and Managing QMF manual for your operating system.
See DSQ84300
Follow the directions in the referenced message.
Free storage failed.
Follow the directions in the referenced message.
Template ID not found.
This is a system error. See your system administrator for assistance, or consult the Installing and Managing QMF manual for your operating system.
Template name not found.
This is a system error. See your system administrator for assistance, or consult the Installing and Managing QMF manual for your operating system.
Unexpected result &1 from package &2.
This is a system error. See your system administrator for assistance, or consult the Installing and Managing QMF manual for your operating system.
Prompted Query Manager Error - unexpected input.
Follow the directions in the referenced message.
See DSQ84300
Follow the directions in the referenced message.
Free storage failed.
Follow the directions in the referenced message.
Template ID not found.
Follow the directions in the referenced message.
Template name not found.
Follow the directions in the referenced message.
Unexpected result &1 from package &2.
Follow the directions in the referenced message.
The attribute and field data types are incompatible.
The data type of the template.field entered as a comparison value does not match the data type of the attribute on the left side of the condition. If the data type of the attribute to the left of the comparison operator has a data type of character, the data type of the template.field must also be character. If the data type of the attribute to the left of the comparison operator has a data type that is one of the valid Repository Manager numeric data types, the template.field must also have a data type that is one of the valid Repository Manager numeric data types.
Type a valid template.field (or other comparison value) and proceed, or use the List function to find out what fields are valid in the current context.
The selection expression for a template is too long.
The selection expression for one of the templates in the query is too long. The total length limit for an expression is 3,300 characters. Within the list of templates that compose your query, the index of the relevant template is &V1.. Within the list of selection clauses that compose the selection expression of the template, the index of the relevant clause is &V2.. It is possible that a substitution variable was used to give a value for this.
Change the selection expression and run the query again.
Comparison expression is invalid.
The Repository Manager has determined that the comparison expression you entered is invalid. This may be due to one of the following reasons:
Make sure the value in the comparison value field to the right of the comparison operator matches the data type of the attribute on the left. If it doesn't, type a valid literal (or other comparison value) in the comparison value field. If the literal is valid, check with your QMF administrator to verify that the Repository Manager has been installed correctly and that you have access to the proper tables.
The number of specified attributes exceeds 999.
The maximum number of attributes that can be specified in a query is 999. The current query has exceeded this limitation.
Reduce the number of specified attributes.
OK, &1 performed. Please proceed.
OK, &1 performed. Please proceed.
OK, &1 performed. Please proceed.
Invalid function code '&1' passed to module.
Follow the directions in the referenced message.
Unexpected result &1 from package &2.
Follow the directions in the referenced message.
Panel state error: panel=&1, code=&2.
This is a system error. See your system administrator for assistance, or consult the Installing and Managing QMF manual for your operating system.
See DSQ84300
Follow the directions in the referenced message.
Invalid storage pool ID: &1.
Follow the directions in the referenced message.
Free storage failed.
Follow the directions in the referenced message.
Invalid storage pool ID: &1.
Follow the directions in the referenced message.
Unexpected result &1 from package &2.
Follow the directions in the referenced message.
The entity &V1 cannot be found in the Repository.
The entity you named either does not exist or cannot be located in the Repository.
If the entity name is spelled correctly (you can list the entities you have access to by using the List function), contact your QMF administrator for more Repository Manager information.
The aggregation &V1 cannot be found in the Repository.
The aggregation you named either does not exist or cannot be located in the Repository.
If the aggregation name is spelled correctly (you can list the aggregations you have access to by using the List function), contact your QMF administrator for more Repository Manager information.
Unexpected result &1 from package &2.
Follow the directions in the referenced message.
You cannot specify the root entity with delete.
The entity you specified for delete is the root entity. The root entity cannot be deleted because it defines the starting point of your view.
If you want to delete your entire view, return to the Entity Relationship Prompted Query base panel and use the Reset command. If you want to delete just part of your view, place your cursor next to the appropriate entity and use the Delete function again.
&V1 is an invalid variable name.
A variable name can be up to 17 characters long after the initial ampersand. The first character following the ampersand must be a letter or a national character. The remaining characters can be letters, numbers, or other characters as defined in the QMF Reference manual.
Substitute a valid name for &V1 and give your command again.
Unexpected result &1 from package &2.
Follow the directions in the referenced message.
Template does not precede current template.
The template named in the template.field comparison value is invalid. If template.field is used in the comparison value in a condition, the named template must precede the template representing the entity-relationship for which you are creating the condition.
Type in a valid template.field (or other comparison value) and proceed, or use the List function to find out what templates are valid in the current context, or cancel out of your condition.
The cursor is not in position for &V1..
To delete a line or a variable, the cursor must be placed in the scrollable area of the display.
Move the cursor to the line you want to delete and press the DELETE PF key (if available) or type DELETE on the command line and then move the cursor to the appropriate line and hit ENTER.
The cursor is not in position for &V1..
To insert a line, the cursor must be placed in the scrollable area of the display.
Move the cursor to the line you want to insert after and press the INSERT PF key (if available) or type INSERT on the command line and then move the cursor to the appropriate line and hit ENTER.
Invalid function code '&1' passed to module.
Follow the directions in the referenced message.
Panel process error: panel=&1, code=&2.
This is a system error. See your system administrator for assistance, or consult the Installing and Managing QMF manual for your operating system.
See DSQ84300
Follow the directions in the referenced message.
Free storage failed.
Follow the directions in the referenced message.
No entities that match your search criteria were found.
You specified an entity list search criteria string, but no entities were found that matched the criteria in the specified tool group.
Modify your search criteria. You can use the characters "%" and "_" as selection symbol (unspecified) characters. If you want to list all the entities that are in the specified tool group, make sure the entry field that contains the cursor is empty.
The view has already been specified.
You have already specified the view name and the Specify View function cannot be used now.
If you want to use a different view for your query, use the Reset Query command. If you want to continue using the current view, use the Show View function.
No aggregations that match your search criteria were found.
You specified an aggregation list search criteria string, but no aggregations were found that matched the criteria in the specified tool group.
Modify your search criteria. You can use the characters "%" and "_" as selection symbol (unspecified) characters. If you want to list all the aggregations that are in the specified tool group, make sure the entry field that contains the cursor is empty.
No tool group found.
You specified a tool group list search, but no tool groups were found.
Contact your QMF administrator to find out why you do not have access to any tool groups.
No items in requested list.
This is a system error. See your system administrator for assistance, or consult the Installing and Managing QMF manual for your operating system.
No templates found which can be used in comparison value.
When you specify a template list search, the only templates returned are those that precede the template representing the entity-relationship in your view to which you are applying your current condition. You are applying your current condition to your view's root entity, and no templates can precede the one representing the root entity.
Type in a comparison value in the comparison value field and proceed, or cancel out of your current condition.
No items in requested list.
Follow the directions in the referenced message.
The view is defined by a variable name.
You have defined your view with a variable name and are not allowed to specify anything else in the query.
If you want to use a different view for your query, use the Reset Query command.
The view has not been specified yet.
You cannot use the Show View function until you have specified the view.
Use the Specify View function to specify the view for your query.
No entities were found in Tool Group.
The specified tool group does not contain any entities.
Change your tool group entry. You can use the PF4 List option to list all available tool groups. .
No aggregations were found in Tool Group.
The specified tool group does not contain any aggregations.
Change your tool group entry. You can use the PF4 List option to list all available tool groups. .
No fields with &V1 data type found.
The template selected to complete the condition does not contain any fields that have the same data type as the attribute to the left of the comparison operator.
The attribute to the left of the comparison operator is either character or numeric. To complete the condition, select a template with at least one field of matching data type. Numeric includes all non-character data types.
Prompted Query Manager Error - unexpected input.
Follow the directions in the referenced message.
See DSQ84300
Follow the directions in the referenced message.
Free storage failed.
Follow the directions in the referenced message.
Template ID not found.
Follow the directions in the referenced message.
Template name not found.
Follow the directions in the referenced message.
Template field name not found.
This is a system error. See your system administrator for assistance, or consult the Installing and Managing QMF manual for your operating system.
Prompted Query Manager Error - unexpected input.
Follow the directions in the referenced message.
See DSQ84300
Follow the directions in the referenced message.
Free storage failed.
Follow the directions in the referenced message.
Too many substitution variables passed in RUN command.
This is a system error. See your system administrator for assistance, or consult the Installing and Managing QMF manual for your operating system.
Unexpected result &1 from package &2.
Follow the directions in the referenced message.
Template name not found.
Follow the directions in the referenced message.
Attribute &V1 is not in entity &V2..
You used attribute name &V1 as a substitution value. It was not found in entity &V2.. The substitution value may be too long to be a valid name, or you may have misspelled the name, or the specified attribute may belong to a different entity.
Verify that the attribute name belongs to the correct entity and is spelled correctly.
The Repository Manager cannot locate entity &V1..
An entity name associated with the aggregation being retrieved from the Repository Manager cannot now be found by the Repository Manager.
Contact your QMF administrator for further Repository Manager information.
The Repository Manager cannot locate relationship &V1.
A relationship name associated with the aggregation being retrieved from the Repository Manager cannot now be found by the Repository Manager.
Contact your QMF administrator for further repository information.
Aggregation &V1 definition is invalid.
The definition may be invalid for a number of different reasons. One possibility is that the aggregation may reference an entity or relationship that has been deleted from the repository. Refer to repository msg &V2
Correct the definition within the repository or contact your QMF administrator for further information.
Aggregation view not found in the Repository.
You specified an aggregation for the view of the ER prompted query to be run, but the aggregation name was not found by the Repository Manager. It is possible that a substitution variable was used to give a value for this. If so, the name represented by the substitution value was misspelled or was too long.
Correct the aggregation name.
Entity view not found in the Repository.
You specified an entity for the view of the ER prompted query to be run, but the entity name was not found by the Repository Manager. It is possible that a substitution variable was used to give a value for this. If so, the name represented by the substitution value was misspelled or was too long.
Correct the entity name.
Invalid function code '&1' passed to module.
Follow the directions in the referenced message.
See DSQ84300
Follow the directions in the referenced message.
Invalid storage pool ID: &1.
Follow the directions in the referenced message.
Free storage failed.
Follow the directions in the referenced message.
Invalid storage pool id: &1.
Follow the directions in the referenced message.
The ENTER key is not active on this panel.
This panel provides information only. There are no selections to be made or values to be entered.
When you are finished viewing the contents of the panel, press Cancel.
&V1 is not a valid selection number.
The value you entered is not a number, or not a number of a selection in the list.
Each of the valid selections in the list is preceded by a number. Select one and type it in the input space at the top of the list. Then press Enter.
&V1 is not selectable.
You entered the number of a list item which is not currently selectable.
Each of the valid selections in the list is preceded by a number. Select one and type it in the input space at the top of the list. Then press Enter.
Select a choice from the list.
You did not select a choice from the list when one was required.
The choices in the list that you may select are numbered. Choose one of them and type the number in the input space at the top of the list. Then press Enter.
Select one or more choices from the list.
You did not select a choice from the list when one was required. The list allows for multiple choices.
Select one or more choices by placing a character in the space preceding each of your choices. Then press Enter.
Type a value before pressing the ENTER key.
Input is required on the panel. You must type at least one value in the spaces allocated for text entry before pressing Enter.
Type in a value. Then press Enter.
The cursor is not in a valid field for &V1..
To complete the &V1. function, the cursor must be placed in one of the current panel's valid fields.
Move the cursor to the desired field and respecify the &V1. function.
Sorry, entry not allowed. Use cursor for selection.
To select an entity, use cursor position and a function key. There must not be any entries in the panel's entry fields.
Remove all characters preceding entity names. Use cursor and a function key to proceed.
See DSQ84481
Follow the directions in the referenced message.
See DSQ84475
Follow the directions in the referenced message.
Select choices from one or both lists.
You did not select a choice from one of the lists when a selection was required.
Select a choice or choices from one or both lists. Then press Enter.
The name used with the SPECIFY command is invalid.
The format for the SPECIFY command is: SPECIFY name, where "name" is a Prompted Query function. The valid ER prompted query function is VIEW. Name is required in ER prompted query.
Enter the SPECIFY command again with a valid name for ER prompted query.
&V1 command cannot be used now.
You have issued a command which is not valid from this panel, or you have issued a command which is not valid in this operating environment (for example, CICS).
Choose a different command.
Internal logic error in module DSQGDRCI.
This is a system error. See your system administrator for assistance, or consult the Installing and Managing QMF manual for your operating system.
This field cannot be null.
You entered a null indicator (&V1.) in this field which indicates null data. However, this field is defined in the database as not allowing null data.
Enter a non-null value in the field.
&V1 is not an allowed integer value.
The value can be from -32768 to 32767.
Enter a valid value in the field.
&V1 is not an allowed decimal value.
The value must be in the format 'smmm&V4.nnn' where
s is an optional sign (plus or minus) m is the digits before the decimal point n is the digits after the decimal point
For this column, the maximum number of digits allowed before the decimal point is &V3., and the maximum number of digits allowed after the decimal point is &V2..
Enter a valid value in the field.
&V1 is not an allowed floating point value.
The value must be in the format 'sm&V4.mmmmmmmEsee' where
s is an optional sign (plus or minus) m is the digits for the mantissa (up to 8 digits) E is the beginning of the exponent e is the digits for the exponent (1 or 2 digits)
The exponent portion may be omitted. The value must be in the range +/-(5&V4.4E-79, 7&V4.2E+75).
Enter a valid value in the field.
&V1 is not an allowed timestamp value.
The correct format is
yyyy-mm-dd-hh.mm.ss.nnnnnn
where
yyyy-mm-dd is the year, month, and day hh.mm.ss is the hour, minute, seconds nnnnnn is the microseconds
The microseconds are optional.
Enter a valid value in the field.
&V1 is not an allowed date value.
The correct format is "mm/dd/yyyy" or "yyyy-mm-dd" or "dd.mm.yyyy".
Enter your date in one of the valid formats.
&V1 is not an allowed date value.
The correct format is "mm/dd/yyyy" or "yyyy-mm-dd" or "dd.mm.yyyy" or the local date format for your installation.
Enter your date in one of the valid formats.
Internal logic error in module DSQGDRCI.
Follow the directions in the referenced message.
&V1 is not an allowed time value.
The correct format is "hh:mm AM" or "hh:mm PM" or "hh:mm:ss" or "hh.mm.ss".
The seconds are optional.
Enter your time in one of the valid formats.
&V1 is not an allowed time value.
The correct format is "hh:mm AM" or "hh:mm PM" or "hh:mm:ss" or "hh.mm.ss" or the local time format for your installation.
The seconds are optional.
Enter your time in one of the valid formats.
Internal logic error in module DSQGDRCI.
Follow the directions in the referenced message.
This field cannot be blank.
You left this field blank. However, the data type of this field does not allow blank data to be entered.
Enter a non-blank value in the field.
Internal logic error in module DSQGDRCI.
Follow the directions in the referenced message.
See DSQ84552
Follow the directions in the referenced message.
Internal logic error in module DSQGDRCI.
Follow the directions in the referenced message.
See DSQ84552
Follow the directions in the referenced message.
&V1 has too many digits after the decimal point.
The maximum number of digits allowed after the decimal point for this field is &V2..
Remove the extra digits.
&V1 is not an allowed integer value.
The value can be from -2,147,483,648 to 2,147,483,647.
Enter a valid value in the field.
&V1 is not an allowed floating point value.
The value must be in the format 'sm&V4.mmmmmmmmmmmmmmmmEsee' where
s is an optional sign (plus or minus) m is the digits for the mantissa (up to 17 digits) E is the beginning of the exponent e is the digits for the exponent (1 or 2 digits)
The exponent portion may be omitted. The value must be in the range +/-(5&V4.4E-79, 7&V4.2E+75).
Enter a valid value in the field.
Internal logic error in module DSQGDRCI.
Follow the directions in the referenced message.
Column default is not available.
The default indicator (&V1.) is not supported. QMF could not determine the column default information for this column. Possible reasons are that the table being edited is:
Do not use the default indicator (&V1.) for this column. Remove the Default indicator (&V1.) from the input field and provide another value. If the value you want to use is the same as the default indicator character (&V1.) then exit the edit session and set the global Variable DSQCP_TEDFLT or DSQCP_TEDFLT_DBCS for graphic data field to a different character. You can then use the value in this field during the next edit session. Refer to QMF I2 trace for more detailed information.
This column does not have a default.
You entered the default indicator (&V1.) in the field for this column. However the column does not have a default defined in the database.
Replace the default indicator (&V1.) in the field with another value. If the value you want to use is the same as the default indicator character (&V1.) then exit the edit session and set the global Variable DSQCP_TEDFLT or DSQCP_TEDFLT_DBCS for graphic data field to a different character. You can then use the value in this field during the next edit session.
RP failure on search.
This is a system error. See your system administrator for assistance, or consult the Installing and Managing QMF manual for your operating system.
Default is not supported on Search mode.
You entered the default indicator (&V1.) in the field for this column. However the default indicator (&V1.) is not supported on Search mode.
Replace the default indicator (&V1.) in the field with another value. If the value you want to search for is the same as the default indicator character (&V1.) then exit the edit session and set the global Variable DSQCP_TEDFLT or DSQCP_TEDFLT_DBCS for graphic data field to a different character. You can then use the value in this field during the next edit session.
&V1 is not a valid HEX value.
A single hexadecimal character is expressed by two letters or digits, so a hexadecimal value must be expressed by an even number of the digits 0 through 9 or the letters A, B, C, D, E, or F. The incorrect hexadecimal value either has an odd number of digits or letters, or contains an invalid letter or other character.
Enter a valid HEX value in the field.
Free storage failed.
Follow the directions in the referenced message.
Invalid item name length at position &V2 in record &V1..
The prompted query you were retrieving contains an error. Record &V1 of the retrieved query is a V record with a data length value of &V3 at position &V2.. The maximum allowable value is &V4..
If you are creating an application which builds or modifies the query, correct the data length value. See the QMF Accessing Repository Data manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
No aggregation or entity name found in V recs for the view.
The prompted query you were retrieving contains an error. The V records describing the view of the retrieved query do not contain a valid aggregation or entity name.
If you are creating an application which builds or modifies the query, correct the data length value. See the QMF Accessing Repository Data manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
See DSQ84612
Follow the directions in the referenced message.
No records should follow when view is a variable.
The prompted query you were retrieving contains an error. The aggregation or entity specified in the view for the retrieved query is a variable. No records, other than an E record should follow the view.
If you are creating an application which builds or modifies the query, delete all records following the view. See the QMF Accessing Repository Data manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
Parent relationship data in record &V1 should be blank.
The prompted query you were retrieving contains an error. Record &V1 represents the root entity of the query. Therefore the parent relationship and parent template id should be blank.
If you are creating an application which builds or modifies the query, correct the parent relationship data. See the QMF Accessing Repository Data manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
See DSQ84300
Follow the directions in the referenced message.
Free storage failed.
Follow the directions in the referenced message.
Invalid template name &V2 in record &V1..
The prompted query you were retrieving contains an error. The template name &V2 that you specified in record &V1 cannot be found in the relationship table (if one exists) or in the database.
If you are creating an application which builds or modifies the query, correct the template name. See the QMF Accessing Repository Data manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
The comparison value in the condition in record &V1 is invalid.
The prompted query you were retrieving contains an error. In record &V1 you have specified the comparison value in the condition as template.field. In the encoded format, template.field is specified by 32 characters for template, then 32 characters for field, and then 32 characters for the name of the attribute to which the field maps. The attribute name (and possibly more) is missing.
If you are creating an application which builds or modifies the query, correct the comparison value. See the QMF Accessing Repository Data manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
Invalid comparison value type in record &V1..
The prompted query you were retrieving contains an error. The comparison value type specified in the condition in record &V1 is not a valid type. Valid types are: L, V, TF.
If you are creating an application which builds or modifies the query, correct the comparison value type. See the QMF Accessing Repository Data manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
Unexpected record code &V2 found in record &V1..
The prompted query you were retrieving contains an error. Record &V1 of the retrieved query contains a record code of &V2. This record code is not allowable at this place in the query to be retrieved.
If you are creating an application which builds or modifies the query, correct the record code. See the QMF Accessing Repository Data manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
See DSQ84365
Follow the directions in the referenced message.
Entity name on record &V1 does not match entity name on view record.
The prompted query you were retrieving contains an error. You have specified a view based on the root entity named &V2.. You have also provided an R record which indicates the root entity of the template tree is &V3.. If an entity name is included on the root template R record, it must match the entity name on the view record.
You must ensure that the entity name on the R record matches the entity name on the view record, or you must remove the entity name from the R record. See the QMF Accessing Repository Data manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
See DSQ84612
Follow the directions in the referenced message.
See DSQ84622
Follow the directions in the referenced message.
Invalid condition connector in record &V1..
The prompted query you were retrieving contains an error. The condition connector specified in record &V1 is not a valid condition connector. Valid condition connectors are: IF, AND, OR.
If you are creating an application which builds or modifies the query, correct the condition connector. See the QMF Accessing Repository Data manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
Invalid condition operator in record &V1..
The prompted query you were retrieving contains an error. The condition operator specified in record &V1 is not a valid operator. Valid operators are: EQ, NE, GT, LT, GE, LE, LK, NL.
If you are creating an application which builds or modifies the query, correct the condition operator. See the QMF Accessing Repository Data manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
Condition operator in record &V1 is wrong.
The prompted query you were retrieving contains an error. The condition operator specified in record &V1 is a valid operator, but is not compatible with the left hand side of the condition.
If you are creating an application which builds or modifies the query, correct the condition operator. See the QMF Accessing Repository Data manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
See DSQ84619
Follow the directions in the referenced message.
Aggregation view not found in the Repository.
The prompted query you were retrieving contains an error. You specified an aggregation for the view of the ER prompted query to be retrieved, but the aggregation name was not found by the Repository Manager.
If you are creating an application which builds or modifies the query, correct the aggregation name. See the QMF Accessing Repository Data manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
Root entity name not found in the Repository.
The prompted query you were retrieving contains an error. You specified a root entity name as the view for the prompted query to be retrieved, but the root entity name was not found by the Repository Manager.
If you are creating an application which builds or modifies the query, correct the root entity name. See the QMF Accessing Repository Data manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
The template id in record &V1 is not unique.
The prompted query you were retrieving contains an error. The template id specified in record &V1 was not accepted by the repository because it is duplicated elsewhere in the relationship table.
If you are creating an application which builds or modifies the query, correct the template id. See the QMF Accessing Repository Data manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
Template id in record &V1 does not match the Repository.
The prompted query you were retrieving contains an error. The template id in record &V1 does not match any template id in the relationship table (if there is one) or in the template tree built by the Repository.
If you are creating an application which builds or modifies the query, correct the template id. See the QMF Accessing Repository Data manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
Parent in record &V1 not found in prior records.
The prompted query you were retrieving contains an error. The parent template id in an R record in the relationship table must also appear as a template id in a previous R record.
If you are creating an application which builds or modifies the query, correct the parent template ID. See the QMF Accessing Repository Data manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
Relationship in record &V1 not found in the repository.
The prompted query you were retrieving contains an error. The relationship specified in record &V1 is not the name of a valid relationship in the database.
If you are creating an application which builds or modifies the query, correct the relationship name. See the QMF Accessing Repository Data manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
Relationship in record &V1 does not map to specified entity.
The prompted query you were retrieving contains an error. The relationship you specified in record &V1 exists in the database, but it does not map to the parent template id specified in the same record.
If you are creating an application which builds or modifies the query, correct the entity name. See the QMF Accessing Repository Data manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
User is not authorized to use relationship in record &V1..
The prompted query you were retrieving contains an error. The relationship you specified in record &V1 exists in the database, but you are not authorized to use it.
If the relationship specified in record &V1 is not correct, change the name of the relationship. See the QMF Accessing Repository Data manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for authorization to use the relationship.
Relationship in record &V1 does not match the repository.
The prompted query you were retrieving contains an error. The relationship you specified in record &V1 exists in the database, but it is not correctly positioned within the structure of the aggregation view specified.
If you are creating an application which builds or modifies the query, correct the entity names. See the QMF Accessing Repository Data manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
Entity in record &V1 does not match the Repository.
The prompted query you were retrieving contains an error. The entity you specified in record &V1 does not match the entity name which the repository connects to the relationship you specified in the same record.
If you are creating an application which builds or modifies the query, correct the relationship or entity. See the QMF Accessing Repository Data manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
Attribute specified in record &V1 is not in current view.
The prompted query you were retrieving contains an error. In record &V1 the left hand side of the condition is not an attribute associated with the current V record's template.
If you are creating an application which builds or modifies the query, correct the attribute. See the QMF Accessing Repository Data manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
The variable specified in record &V1 is invalid.
The prompted query you were retrieving contains an error. In record &V1 you have indicated that the comparison value in the condition is a variable. It is not in the form of a valid QMF variable.
If you are creating an application which builds or modifies the query, correct the form of the variable. See the QMF Accessing Repository Data manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
Comparison value template in record &V1 not found.
The prompted query you were retrieving contains an error. You have indicated that the comparison value in the condition in record &V1 is a template.field. The template does not exist in the current view.
If you are creating an application which builds or modifies the query, correct the template.field. See the QMF Accessing Repository Data manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
Template in record &V1 does not precede last V record template.
The prompted query you were retrieving contains an error. The comparison value in the condition in record &V1 is a template.field. The template in template.field must appear in the view structure before the template of the last V record.
If you are creating an application which builds or modifies the query, correct the condition as appropriate. See the QMF Accessing Repository Data manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
In record &V1., comparison value attribute not in its template.
The prompted query you were retrieving contains an error. The attribute specified in the comparison value in the condition in record &V1 does not belong to the template specified in that comparison value.
If you are creating an application which builds or modifies the query, correct the attribute name. See the QMF Accessing Repository Data manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
In comparison value in record &V1., field and attribute mismatched.
The prompted query you were retrieving contains an error. The field name specified in the comparison value in the condition in record &V1 does not correspond to the attribute following that field name.
If you are creating an application which builds or modifies the query, correct the field/attribute names. See the QMF Accessing Repository Data manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
Attribute in record &V1 not found in specified template.
The prompted query you were retrieving contains an error. In record &V1 you have specified an attribute that is not part of the template specified immediately before it.
If you are creating an application which builds or modifies the query, correct the attribute. See the QMF Accessing Repository Data manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
An expression used for a template in line &V1 is too long.
An expression used for a particular template in line &V1 of the query being retrieved is too long. The total length limit for an expression is 3,300 characters. It is possible that a substitution variable was used to give a value for this.
If you are creating an application which builds or modifies the query, correct the expression. See the QMF Accessing Repository Data manual for more information on the external format of prompted queries. Otherwise, contact your Information Center for assistance.
Invalid literal in line &V1..
The literal entered in line &V1 to complete the condition does not match the data type of the attribute to the left of the comparison operator. The attribute to the left of the comparison operator is either character or numeric. If the attribute is numeric, the literal string must also be numeric.
If you are creating an application which builds or modifies the query, correct the literal. See the QMF Accessing Repository Data manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
The attribute field data types in line &V1 are incompatible.
The data type of the right side template.field comparison value in line &V1 does not match the data type of the attribute on the left side of the condition. Numeric data types can only be compared to numeric, character to character.
If the attribute on the left side of the condition is numeric, replace the right side comparison value with a numeric template.field. If the left side data type is character, use character on the right. See the QMF Accessing Repository Data manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
INTEGER: -2,147,483,648 to 2147483647, has default, never null.
This column is an integer data type. It can contain a number in the range -2,147,483,648 to 2,147,483,647 (Up to 10 digits).
The reserved character for default (&V2.) is allowed in this column in Add or Change mode.
The reserved character for null (&V1.) is not allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
INTEGER: -2,147,483,648 to 2147483647, has default, null allowed.
This column is an integer data type. It can contain a number in the range -2,147,483,648 to 2,147,483,647 (Up to 10 digits).
The reserved character for default (&V2.) is allowed in this column in Add or Change mode.
The reserved character for null (&V1.) is allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
SMALL INTEGER: -32,768 to 32,767, has default, never null.
This column is a small integer data type. It can contain a number in the range -32,768 to 32,767.
The reserved character for default (&V2.) is allowed in this column in Add or Change mode.
The reserved character for null (&V1.) is not allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
SMALL INTEGER: -32,768 to 32,767, has default, null allowed.
This column is a small integer data type. It can contain a number in the range -32,768 to 32,767.
The reserved character for default (&V2.) is allowed in this column in Add or Change mode.
The reserved character for null (&V1.) is allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
FLOAT: (+/-)&V1&V2&V3.E(+/-)ee, has default, never null.
In the format shown above:
The exponent portion may be omitted.
The reserved character for default (&V5.) is allowed in this column in Add or Change mode.
The reserved character for null (&V4.) is not allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
FLOAT: (+/-)&V1&V2&V3.E(+/-)ee, has default, null allowed.
In the format shown above:
The exponent portion may be omitted.
The reserved character for default (&V5.) is allowed in this column in Add or Change mode.
The reserved character for null (&V4.) is allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
DECIMAL: &V1 digits before decimal, &V2 after, has default, never null.
This column is a decimal data type. A plus or minus sign may be used before the decimal number. Plus is assumed if the sign is omitted.
The reserved character for default (&V4.) is allowed in this column in Add or Change mode.
The reserved character for null (&V3.) is not allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
DECIMAL: &V1 digits before decimal, &V2 after, has default, null allowed.
This column is a decimal data type. A plus or minus sign may be used before the decimal number. Plus is assumed if the sign is omitted.
The reserved character for default (&V4.) is allowed in this column in Add or Change mode.
The reserved character for null (&V3.) is allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
VARYING CHARACTER(&V1): has default, never null.
This column is a varying character data type. It can contain up to &V1 characters. Trailing blanks are stripped from the data.
The reserved character for default (&V3.) is allowed in this column in Add or Change mode.
The reserved character for null (&V2.) is not allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
VARYING CHARACTER(&V1): has default, null allowed.
This column is a varying character data type. It can contain up to &V1 characters. Trailing blanks are stripped from the data.
The reserved character for default (&V3.) is allowed in this column in Add or Change mode.
The reserved character for null (&V2.) is allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
CHARACTER(&V1): has default, never null.
This column can contain up to &V1 characters. The column in the database is always &V1 characters long. Blanks are added to the end of the column if you key less than &V1 characters.
The reserved character for default (&V3.) is allowed in this column in Add or Change mode.
The reserved character for null (&V2.) is not allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
CHARACTER(&V1): has default, null allowed.
This column can contain up to &V1 characters. The column in the database is always &V1 characters long. Blanks are added to the end of the column if you key less than &V1 characters.
The reserved character for default (&V3.) is allowed in this column in Add or Change mode.
The reserved character for null (&V2.) is allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
VARYING GRAPHIC(&V1): has default, never null.
This column can contain up to &V1 DBCS characters. Trailing blanks are stripped from the data.
The reserved character for default (&V3.) is allowed in this column in Add or Change mode.
The reserved character for null (&V2.) is not allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
VARYING GRAPHIC(&V1): has default, null allowed.
This column can contain up to &V1 DBCS characters. Trailing blanks are stripped from the data.
The reserved character for default (&V3.) is allowed in this column in Add or Change mode.
The reserved character for null (&V2.) is allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
GRAPHIC(&V1): has default, never null.
This column can contain up to &V1 DBCS characters. The column in the database is always &V1 characters long. Blanks are added to the end of the column if you key less than &V1 characters.
The reserved character for default (&V3.) is allowed in this column in Add or Change mode.
The reserved character for null (&V2.) is not allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
GRAPHIC(&V1): has default, null allowed.
This column can contain up to &V1 DBCS characters. The column in the database is always &V1 characters long. Blanks are added to the end of the column if you key less than &V1 characters.
The reserved character for default (&V3.) is allowed in this column in Add or Change mode.
The reserved character for null (&V2.) is allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
DATE: &V1, has default, never null.
The default format for the date is shown above. The correct format for entering data is "mm/dd/yyyy" or "yyyy-mm-dd" or "dd.mm.yyyy" or the local date format for your installation.
The reserved character for default (&V3.) is allowed in this column in Add or Change mode.
The reserved character for null (&V2.) is not allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Enter your date in one of the valid formats.
DATE: &V1, has default, null allowed.
The default format for the date is shown above. The correct format for entering data is "mm/dd/yyyy" or "yyyy-mm-dd" or "dd.mm.yyyy" or the local date format for your installation.
The reserved character for default (&V3.) is allowed in this column in Add or Change mode.
The reserved character for null (&V2.) is allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Enter your date in one of the valid formats.
TIME: &V1, has default, never null.
The default format for the time is shown above. The correct format for entering data is "hh:mm AM (or PM)" or "hh:mm:ss" or "hh.mm.ss" or the local time format for your installation.
The seconds are optional.
The reserved character for default (&V3.) is allowed in this column in Add or Change mode.
The reserved character for null (&V2.) is not allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Enter your time in one of the valid formats.
TIME: &V1, has default, null allowed.
The default format for the time is shown in the message text. The correct format for entering data is "hh:mm AM (or PM)" or "hh:mm:ss" or "hh.mm.ss" or the local time format for your installation.
The seconds are optional.
The reserved character for default (&V3.) is allowed in this column in Add or Change mode.
The reserved character for null (&V2.) is allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Enter your time in one of the valid formats.
TIMESTAMP: yyyy-mm-dd-hh.mm.ss.nnnnnn, has default, never null.
In the timestamp format shown above
yyyy-mm-dd is the year, month, and day hh.mm.ss is the hour, minute, seconds nnnnnn is the microseconds
The microseconds are optional.
The reserved character for default (&V2.) is allowed in this column in Add or Change mode.
The reserved character for null (&V1.) is not allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
TIMESTAMP: yyyy-mm-dd-hh.mm.ss.nnnnnn, has default, null allowed.
In the timestamp format shown above
yyyy-mm-dd is the year, month, and day hh.mm.ss is the hour, minute, seconds nnnnnn is the microseconds
The microseconds are optional.
The reserved character for default (&V2.) is allowed in this column in Add or Change mode.
The reserved character for null (&V1.) is allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
OK, VARYING CHARACTER(&1) shown, has default, never null.
OK, VARYING CHARACTER(&1) shown, has default, null allowed.
OK, CHARACTER(&1) shown, has default, never null.
OK, CHARACTER(&1) shown, has default, null allowed.
OK, VARYING GRAPHIC(&1) shown, has default, never null.
OK, VARYING GRAPHIC(&1) shown, has default, null allowed.
OK, GRAPHIC(&1) shown, has default, never null.
OK, GRAPHIC(&1) shown, has default, null allowed.
OK, ROWID shown in HEX, has default, never null.
OK, CLOB(&1) shown, has default, never null.
OK, CLOB(&1) shown, no default, never null.
OK, CLOB(&1) shown, has default, null allowed.
OK, CLOB(&1) shown, no default, null allowed.
OK, BLOB(&1) shown, has default, never null.
OK, BLOB(&1) shown, no default, never null.
OK, CLOB(&1) shown. SEARCH will use LIKE.
OK, BLOB(&1) shown. SEARCH will use LIKE.
OK, DBCLOB(&1) shown. SEARCH will use LIKE.
OK, BLOB(&1) shown, has default, null allowed.
OK, BLOB(&1) shown, no default, null allowed.
OK, DBCLOB(&1) shown, has default, never null.
OK, DBCLOB(&1) shown, no default, never null.
OK, DBCLOB(&1) shown, has default, null allowed.
OK, DBCLOB(&1) shown, no default, null allowed.
A condition in column &V3 of row &V2 in table &V1 does not refer to existing data.
Conditions may refer only to data that already exists in a database. If the column containing the condition is unnamed, it is not known what existing data you mean. If the condition is in an I. row, data in that row does not exist until after the row is inserted.
Remove the condition from your query.
See DSQ84228
Follow the directions in the referenced message.
Double quotes are invalid in column &V3 of row &V2 in table &V1..
Double quotes are not valid in this context.
Remove the invalid double quotes.
Double quotes are invalid in the row field of row &V2 in table &V1..
Double quotes are not valid in this context.
Remove the invalid double quotes.
Uneven number of double quotes in the column name in column &V2 of table &V1..
There must be an even number of double quotes around a column name as in the following example:
"SALARY + COMM"
Correct the column name, making sure that there is an even number of double quotes.
Uneven number of double quotes in the table name of table &V1..
There must be an even number of double quotes around a table name as in the following examples:
"DEPT 45".STAFF
Q."MY STAFF"Correct the table name, making sure that there is an even number of double quotes.
'&V4' is an invalid DBCS constant in column &V3 of row &V2 in table &V1..
A DBCS must appear as follows:
G'...DBCS...'
Correct the DBCS constant.
Shift-in character is missing from '&V4' in column &V3 of row &V2 in table &V1..
A DBCS constant must end with a shift-in character.
Correct the DBCS constant.
Double quotes are invalid in column &V3 of row &V2 in table &V1..
Double quotes may not appear in a data field.
Remove the double quotes from the data field.
Double quotes are invalid in the row field of row &V2 of table &V1..
Double quotes may not appear in a row field.
Remove the double quotes from the row field.
Adjacent double quotes are invalid in the column name in column &V2 of table &V1..
Double quotes may not appear next to each other. The following are examples of invalid and valid uses of double quotes:
VALID INVALID "LOCAL STAFF" ""
Correct the constant.
Adjacent double quotes are invalid in the table name of table &V1..
Double quotes may not appear next to each other. The following are examples of invalid and valid uses of double quotes:
VALID INVALID "LOCAL STAFF" ""
Correct the constant.
Exponent is missing from '&V4' in column &V3 of row &V2 in table &V1..
An exponent must appear in the number as in the following example:
456783E2
Correct the constant.
'&V4' is an invalid comparison operator in column &V3 of row &V2 in table &V1..
Only the following comparison operators are valid:
> < >= <= = ¬=
Correct the comparison operator.
Uneven number of single quotes in column &V3 of row &V2 in table &V1..
Single quotes may be used to enclose a constant. Also, two adjacent single quotes are used to signify a single quote. For example:
O''BOYLE (interpreted to mean,
O'BOYLE)
'P. LANGAN' (interpreted to mean,
P. LANGAN)Make sure that there are an even number of single quotes in the constant.
The qualifier in the table name area of example table &V1 must be followed by a table name.
A table name is required after a qualifier. Example:
"Q".STAFF | NAME | SALARY |
----------+------+--------|
P. | | >20000 |The qualifier (Q) is followed by the table name (STAFF).
Provide the missing table name.
An example table must have at least one column.
Every example table in a QBE query must have at least one column.
Use the DELETE command to delete the example table and the DRAW command to redraw it.
Free storage failed.
Follow the directions in the referenced message.
See DSQ84300
Follow the directions in the referenced message.
System problem in FP function. FPCODE = &1.
This is a system error. See your system administrator for assistance, or consult the Installing and Managing QMF manual for your operating system.
See DSQ84300
Follow the directions in the referenced message.
A query must have at least one named example table.
A query must refer by name to at least one existing table.
Use the DRAW command to draw the table or tables that you wish to use in your query.
Example element &V1 is not required.
Your query was run, but since the example element was not used anywhere else in the query, it is not required.
If you meant to refer to the example element somewhere in the query, make the necessary change and rerun the query.
A query must have at least one named example table.
None of the example tables in your query names a table. At least one of them must name an existing table in its table name area.
Use the DRAW command to draw the table or tables that you want to use in your query. Each example table drawn will automatically contain the name of the table it represents.
Free storage failed.
Follow the directions in the referenced message.
See DSQ84300
Follow the directions in the referenced message.
A query must have a P., D., U., or I. operator.
A query must be used to do a present (P.), delete (D.), update (U.), or insert (I.).
Add a P., D., U., or I. operator to the appropriate row or rows of one of the example tables in the query.
See DSQ84300
Follow the directions in the referenced message.
System problem in FP function. FPCODE = &1.
Follow the directions in the referenced message.
See DSQ84300
Follow the directions in the referenced message.
Free storage failed.
Follow the directions in the referenced message.
Double quotes in the table name in example table &V1 are invalid.
An entire table name may be enclosed in double quotes, but double quotes must not be used in the name itself.
Correct: "DEPT 46 SALES"
"DEPT '46' SALES"
Incorrect: "DEPT "46" SALES"Remove the double quotes from the table name.
See DSQ84985
Follow the directions in the referenced message.
See DSQ85030
Follow the directions in the referenced message.
Invalid sort form in column &V3 of row &V2 in example table &V1..
The following are examples of valid sort forms:
AO. DO. AO(1). DO(2).
Be sure to use the letter O and not a zero.
Use the correct sort form.
Query is too long.
Before executing, your QBE query is translated into SQL. In this case, the resulting SQL query is too long for an internal storage area, and cannot be executed.
Try to use two or more shorter queries to accomplish the same objective.
Duplicate D. in row &V2 of table &V1 was ignored.
Your query was run.
None required.
Duplicate I. in row &V2 of table &V1 was ignored.
Your query was run.
None required.
Duplicate P. in row &V2 of table &V1 was ignored.
Your query was run.
None required.
Row &V2 of example table &V1 has more than one ALL. or UNQ.
ALL. or UNQ. may be used only once as a row operator in any given row.
Remove all extra UNQ. and ALL. operators.
The ALL. or UNQ. in row &V2 of example table &V1 may be used only in a row that has a P. operator.
A P. operator is needed because ALL. and UNQ. as row operators refer only to retrieved data, and you must use P. operators to retrieve data.
Either remove the ALL. or UNQ., or put at least one P. operator in the row.
Double quotes within the column name in column &V2 of example table &V1 are invalid.
An entire column name may be enclosed in double quotes, but the name itself must not contain them. Examples:
Correct: "SALARY + COMM"
"DEPT 'NUM' "
Incorrect: "PART "NUM" "Remove the double quotes from the column name.
Duplicate G. in row &V2 of table &V1 was ignored.
Your query was run.
None required.
The D. in column &V3 of row &V2 in example table &V1 is invalid when used in a column.
Use D. only to delete entire rows. You cannot use it to delete data from columns.
Remove the D. from the column. To delete data from a column, use the U. operator instead. Example:
Q.STAFF | NAME | SALARY | COMM |
--------+-------+--------+------|
| SMITH | U.NULL | |To delete entire rows use the D. as follows:
Q.STAFF | NAME | SALARY | COMM | --------+-------+--------+------| D. | SMITH | | |
The I. in column &V3 of row &V2 in example table &V1 is invalid when used in a column.
Use I. only to insert entire rows, not to insert data into columns of existing rows.
Remove the I. from the column. To insert data into an existing column, use a U. instead. Example:
Q.STAFF | NAME | SALARY | COMM |
--------+-------+---------+------|
| SMITH | U.20000 | |To insert an entire row, use I. as follows:
Q.STAFF | NAME | ID | --------+-------+--------| I. | SMITH | 702 |
Duplicate U. in row &V2 of example table &V1 was ignored.
Your query uses U. more than once. The second use was ignored.
If everything you wanted to update was not completed, write and run another query.
Duplicate P. operator in column &V3 of row &V2 in example table &V1 was ignored.
Your query was run without the duplicate P. operator.
If you meant to use a P. operator somewhere else, fix the query and run it again.
If you are going to SAVE the query, you should remove the duplicate P. operator.
Column &V3 of example table &V1 contains more than one sort (AO. or DO.) operator.
Only one such operator can be used in a column. The following query is invalid because the NAME column contains two such operators.
Invalid query: Q.STAFF | NAME | SALARY | COMM | --------+------+----------+------| P. | AO. | >20000 | | P. | DO. | | >800 |
Use only one AO. or DO. operator in the column.
&V1 is invalid in row &V3, column &V4 of table &V2..
The entry beginning with &V1 in column &V4, row &V3, of example table &V2 is invalid because of another entry in that row and column.
For example, if this (incorrect) entry: 20 P. 30 appears under one column, the entry 30 is invalid and will cause this message to display.
Remove &V1 and everything after, make sure that the remaining value is correct, and run the query again.
Invalid mix of operators in table &V1..
No more than one of the operators I., U., D., and P. may be used in the same example table or target table. (The same operator may be used more than once.)
Correct table &V1. and run the query again.
D., I., U., or P. operators may appear in only one table.
You cannot do deletes, inserts, updates, or retrievals of more than one table per query.
Create and run separate queries for each delete, insert, update, and retrieval.
You cannot use a G. in row &V2 of example table &V1 because the row has a D., U., or I. operator.
Rows that contain any of the above operators must not be grouped. Example:
Invalid Q.STAFF | DEPT | SALARY |
query: --------+------+--------|
I. | G._D | _SAL |Remove the grouping operator.
The qualifier for the table name in example table &V1 has more than eight characters.
The qualifier identifies the table's owner. No qualifier can be longer than eight characters.
Correct the qualifier. If you don't remember it, find it by issuing the command
LIST TABLES (OWNER=ALL)
This will list all the tables you are authorized to use. Look for the name of your table in this list. The qualifier for the table will be under the Object Owner column.
The name of column &V2 in example table &V1 has more than 18 characters.
No column name can be longer than 18 characters.
Replace the invalid column name with one defined for the table. If you can't recall the valid name, issue the command
DRAW tablename
where "tablename" is the name of the table of interest. This will draw an example table whose columns have the names of every column in the table.
See DSQ85041
Follow the directions in the referenced message.
The table name in example table &V1 has more than 18 characters.
No table name can be longer than 18 characters.
Correct the table name. If you don't remember it, issue the command
LIST TABLES (OWNER=ALL)
This will list all the tables you are authorized to use.
Example table &V1 has an I., D., or U., but not a name.
You must name the table that you want to change.
Enter the name of the table you want to change in example table &V1..
The AO. or DO. in example table &V1 must be used in a table with a P. operator.
Only retrieved data may be sorted. You must use a P. operator to retrieve data.
Either remove the sort operator or put P. operators in the row containing the sort operator.
See DSQ85052
Follow the directions in the referenced message.
Column &V3 of row &V2 in table &V1 contains a G. operator. The column must be named.
Use of a G. means that rows are to be grouped by the values in a particular column. The name of the column must appear above the G. in the same column. For example,
Q.STAFF | SALARY | DEPT | |
--------+--------+------+----------|
| _S | P.G. | P.AVG._S |Put a column name above the G. in the same column or remove the G. operator.
See DSQ85055
Follow the directions in the referenced message.
&V1 in row &V3 of example table &V2 is invalid in the row-operator area.
Only the following QBE operators are valid in the row-operator area:
P., D., I., UNQ., or ALL.
Either replace &V1 with a valid operator or remove it from the row-operator area. Note that the QBE operators:
U., AO., DO., and G.
are not valid when used in the row-operator area.
See DSQ85053
Follow the directions in the referenced message.
Example element &V1 in column &V4 of row &V3 in example table &V2 is longer than 18 characters.
An example element name must not be more than 18 characters long.
Choose a shorter example element name.
See DSQ84300
Follow the directions in the referenced message.
Example table &V1 must have at least one named column.
A named example table must have at least one named column.
Use the DELETE command to delete the table with no names. Then use the DRAW command to redraw the table and its columns.
See DSQ85034
Follow the directions in the referenced message.
See DSQ84300
Follow the directions in the referenced message.
System problem in FP function. FPCODE = &1.
Follow the directions in the referenced message.
See DSQ84300
Follow the directions in the referenced message.
Column &V3 of example table &V1 has an entry but not a column name.
The entry in the column must refer to a particular column of the referenced table. To do so, the column must have a name.
Either give column &V3 the name of a column defined for the example table or remove its entry.
Column &V3 in row &V2 of example table &V1 links two rows that have a P., D., or U. operator.
You cannot link two rows containing P., D., or U. Two rows are linked when one has an example element that the other references, or when they are linked through other rows.
Example: The query below is invalid because its two P. rows are linked through the example element _S.
Invalid query: Q.STAFF | NAME | SALARY | COMM | --------+------+--------+-------| P. | | | >_S | P. | | _S | >1200 |
Remove the invalid link.
Condition &V2 in CONDITIONS box &V1 links 2 rows that have a P., D., or U. operator.
You cannot link two rows with P., D., or U. through a condition in a CONDITIONS box. This happens when the condition references both rows, or when it links both rows through other rows.
Invalid query: Q.STAFF | NAME | SALARY | COMM | --------+------+--------+-------| P. | | | _C | P. | | _S | | | CONDITIONS | |------------| | _C > _S | | _S > 20000 |
This query is invalid because the first condition in the CONDITIONS box links the two P. rows.
Remove the invalid link.
Example element &V4 in column &V3 of row &V2 in example table &V1 must represent a column of a named example table.
The example element does not represent a column in any of the tables named in your query.
Either remove all references to the example element or define it by placing it alone (except for QBE operators) in the column it represents.
Example: Adding _SAL to the SALARY column of Q.EMP in the query below defines _SAL as representing that column.
Q.EMP | NAME | SALARY | COMM |
------+------+----------+-------|
| P. | P. _SAL | >_SAL |Condition &V2 in CONDITIONS box &V1 has a group reference to a row that has a D., U., or I. operator.
A row with an D., U., or I. cannot be grouped. Referring to such a row in a built-in function implies grouping of the row. For example,
Invalid query:
Q.EMP | NAME | SALARY |
------+------+---------|
D. | | _S |
| | _SA |
| CONDITIONS |
|---------------|
| _SA > AVG._S |The condition implies grouping of the D. row.
You may want to change the implied grouping. For example,
Q.EMP | NAME | SALARY |
------+------+---------|
D. | | _S |
| | _SA |
| CONDITIONS |
|---------------|
| _S <= AVG._SA |Column &V3 of row &V2 in example table &V1 has a group reference to a row that has a D., U., or I. operator.
A row with a D., U., or I. cannot be grouped. Referring to such a row in a built-in function implies grouping of the row. For example,
Invalid query:
Q.EMP | NAME | SALARY | COMM |
------+------+----------+------|
D. | | | _CM |
| | >AVG._CM | |The condition in the second row implies grouping of the D. row.
You may want to change the implied
grouping. For example,
Q.EMP | NAME | SALARY | COMM |
------+------+----------+------|
D. | | >AVG._CM | |
| | | _CM |Example element &V3 in condition &V2 of CONDITIONS box &V1 must represent a column of a named table.
The example element of the message does not represent a column in any of the tables named in your query.
Either remove all references to the undefined example element from the CONDITIONS box or define that element. Define it by placing its name alone (except for QBE operators) in the column it represents.
Example: Adding _S to the SALARY column of Q.STAFF in the query below defines _S as representing that column and allows it to be used in the CONDITIONS box.
Q.STAFF | NAME | SALARY | COMM | -------- ------ -------- ------| P. | | AO._S | _C | | CONDITIONS | |--------------| | _S _C>20000 |
See DSQ84300
Follow the directions in the referenced message.
Free storage failed.
Follow the directions in the referenced message.
See DSQ84300
Follow the directions in the referenced message.
Free storage failed.
Follow the directions in the referenced message.
See DSQ85034
Follow the directions in the referenced message.
Column &V3 in row &V2 of example table &V1 has a P. operator but no name.
You must name the column from which you want to retrieve data.
Either remove the P. or give the column a name. If you give the column a name, be sure it is the name of a column defined for the example table.
All the rows containing P. operators in example table &V1 must retrieve the same columns.
More than one row in your query has P. operators. Each column retrieved in one such row must be retrieved in each of the others.
Invalid query:
Q.STAFF | NAME | SALARY | COMM |
--------+------+----------+---------|
| P. | P.>20000 | |
| P. | | P.>1200 |This query is invalid because the first row, but not the second, retrieves data from SALARY, and also because the second row, but not the first, retrieves data from COMM.
Place the P. operators in such a way that the rows containing them retrieve the same columns.
All the rows containing P. operators in example table &V1 must retrieve the same columns.
More than one row in your query has P. operators. Each column retrieved in one such row must be retrieved in each of the others.
Invalid query:
Q.STAFF | NAME | SALARY | COMM |
--------+------+----------+---------|
| P. | P.>20000 | |
| P. | | P.>1200 |This query is invalid because the first row, but not the second, retrieves data from SALARY, and also because the second row, but not the first, retrieves data from COMM.
Place the P. operators in such a way that the rows containing them retrieve the same columns.
Example table &V1 has no table name. Either give it a table name or remove its column names.
An example table without a name (that is, a "target table") cannot contain named columns.
Remove the column names if you mean the example table to be a target table. If not, give the example table the name of the table it is to represent.
Row &V2 of target table &V1 must contain a P. operator.
The row designated in the message contains at least one column entry. In a target table, such a row directs the retrieval of data and must therefore contain a P. operator.
Put a P. in the row-operator area of the row. Or put P. operators in every column that has an entry.
Row &V2 of target table &V1 contains nothing but P. operators.
The P. in row &V2 of target table &V1 orders the retrieval of data, but you have not shown what you want retrieved.
Place entries in the columns of table &V1 to show what you want in each column. Example:
Q.STAFF | NAME | SALARY | COMM |
--------+------+--------+--------|
| _N | _S | _C |
| | |
--------+------+--------|
P. | _N | _S+_C |In the example, the target table entries are _N and _S+_C. Running the query will list employee names (_N) and their total earnings (_S+_C).
Column &V3 of row &V2 in target table &V1 has an entry but no P. operator.
Every column entry in a target table specifies data to be retrieved. You must indicate data retrieval through the P. operator.
Put a P. operator in row &V2. Place it either in the row-operator area or in column &V3..
All the rows containing P. operators in example table &V1 must retrieve the same columns.
More than one row in your query has P. operators. Each column retrieved in one such row must be retrieved in each of the others.
Invalid query:
Q.STAFF | NAME | SALARY | COMM |
--------+------+----------+---------|
| P. | P.>20000 | |
| P. | | P.>1200 |This query is invalid because the first row, but not the second, retrieves data from SALARY, and also because the second row, but not the first, retrieves data from COMM.
Place the P. operators in such a way that the rows containing them retrieve the same columns.
Column &V3 of row &V2 in target table &V1 has a P. operator but no indication of what should be retrieved.
If a column in a target table has a P. operator, it must also show what you want to retrieve.
Either remove the P. from the column or add an indication of what you want to retrieve. This could be a constant ('J. Jones'), an example element (_S), or an expression (_S _C).
All the rows containing P. operators in example table &V1 must retrieve the same columns.
More than one row in your query has P. operators. Each column retrieved in one such row must be retrieved in each of the others.
Invalid query:
Q.STAFF | NAME | SALARY | COMM |
--------+------+----------+---------|
| P. | P.>20000 | |
| P. | | P.>1200 |This query is invalid because the first row, but not the second, retrieves data from SALARY, and also because the second row, but not the first, retrieves data from COMM.
Place the P. operators in such a way that the rows containing them retrieve the same columns.
The AO. or DO. in column &V2 of example table &V1 must appear in a column from which data is to be retrieved.
Data can only be sorted on retrieved data, but data is retrieved by using the P. operator.
Either remove the AO. or DO., or put a P. in the same column.
See DSQ84300
Follow the directions in the referenced message.
A sort priority must appear after AO. or DO. in column &V2 of row &V1..
If more than one AO. or DO. appears in a QBE query, a numeric value must appear after each AO. and DO. The numeric value is its sort priority. For example,
Q.STAFF | NAME | DEPT | SALARY |
--------+--------+--------+--------|
P. | AO(2). | AO(1). | |means sort by DEPT and by NAME within each DEPT.
Insert a numeric value after every AO. or DO. in your query.
The same sort priority may not appear in two AO. or DO. operators.
The numeric value in a sort operator is its sort priority. For example,
Q.STAFF | NAME | DEPT | SALARY |
--------+--------+--------+--------|
P. | AO(2). | AO(1). | |means sort by DEPT and by NAME within each DEPT.
Remove the duplicate sort priority.
DXEECP base value required for echo function.
This is a system error. See your system administrator for assistance, or consult the Installing and Managing QMF manual for your operating system.
Echo base must be displayed to perform function.
This is a system error. See your system administrator for assistance, or consult the Installing and Managing QMF manual for your operating system.
DXEECP base value required for echo function.
Follow the directions in the referenced message.
Echo base is already displayed.
This is a system error. See your system administrator for assistance, or consult the Installing and Managing QMF manual for your operating system.
Echo line token or ID was not found.
This is a system error. See your system administrator for assistance, or consult the Installing and Managing QMF manual for your operating system.
Echo base must be displayed to perform function.
Follow the directions in the referenced message.
Echo line token or ID was not found.
Follow the directions in the referenced message.
DXEECP base value required for echo function.
Follow the directions in the referenced message.
Echo base must be displayed to perform function.
Follow the directions in the referenced message.
Echo query function value was not supplied.
This is a system error. See your system administrator for assistance, or consult the Installing and Managing QMF manual for your operating system.
Either echo line ID, token, or line number required.
This is a system error. See your system administrator for assistance, or consult the Installing and Managing QMF manual for your operating system.
Invalid line number used to adjust echo.
This is a system error. See your system administrator for assistance, or consult the Installing and Managing QMF manual for your operating system.
Echo line token or ID was not found.
Follow the directions in the referenced message.
Either echo line ID, token, or line number required.
Follow the directions in the referenced message.
See DSQ84300
Follow the directions in the referenced message.
Free storage failed.
Follow the directions in the referenced message.
System problem in FP function. FPCODE = &1.
Follow the directions in the referenced message.
See DSQ84300
Follow the directions in the referenced message.
Invalid function code '&1' passed to module.
Follow the directions in the referenced message.
You cannot access a partial query.
Your command was not executed because the query is a partial query. A partial query is one that is in the process of being updated, having an active ellipsis, ">...", in the echo.
Finish updating the query.
Variable substitution caused an expression to exceed 255 characters.
The query contains an expression that has variables in it. When values were substituted for these variables, the resulting expression exceeded the allowable maximum of 255 characters.
Delete data from the expression so that it is less than the allowable maximum number of characters.
See DSQ84300
Follow the directions in the referenced message.
Column information was not retrieved.
You used the Describe key to retrieve information about a column for which information cannot be retrieved from the database. This may mean that you do not have authorization to see the column information, or that the global variables containing the names of the views used to retrieve this information were not set correctly.
Contact your QMF administrator.
Unexpected return code from RPT: &1.
This is a system error. See your system administrator for assistance, or consult the Installing and Managing QMF manual for your operating system.
Invalid function code '&1' passed to module.
Follow the directions in the referenced message.
Panel process error: panel=&1, code=&2.
Follow the directions in the referenced message.
See DSQ84300
Follow the directions in the referenced message.
Free storage failed.
Follow the directions in the referenced message.
No sortable columns or expressions in query.
You specified Sort but there aren't any columns or expressions in your query that can be used for sorting.
Specify at least one column or expression (that is not a constant) in the Columns section of your query before attempting to specify sort criteria.
There are no tables in the Prompted Query.
You cannot specify Columns, Rows, Sort, or Duplicate Rows when the Prompted Query does not contain a table.
Specify a table in the Prompted Query before attempting to specify any other part of the query.
No tables found that match your list search criteria.
You specified a table list search criteria string, but no tables were found that matched the criteria.
Modify your search criteria. You can use the characters "%" and "_" as "wild card" (unspecified) characters. If you want to list all the tables that you are authorized to use, make sure the entry field that contains the cursor is empty.
No items in requested list.
Follow the directions in the referenced message.
See DSQ84300
Follow the directions in the referenced message.
Free storage failed.
Follow the directions in the referenced message.
See DSQ84488
Follow the directions in the referenced message.
Invalid function code '&1' passed to module.
Follow the directions in the referenced message.
Select a choice from the list or choose Expression.
You either selected from the list and selected Expression also, or you made no selection at all.
Make a single selection. Then press Enter.
See DSQ84476
Follow the directions in the referenced message.
See DSQ84477
Follow the directions in the referenced message.
See DSQ84478
Follow the directions in the referenced message.
See DSQ84479
Follow the directions in the referenced message.
The tables you selected cannot be joined.
You have selected the same table in both of the tables lists. A table is not normally joined to itself in a query.
If you really need to join a table to itself, you can do so by specifying the same table name more than once on the Tables panel. The table name will then appear more than once in the tables list in the Join Tables panel, and you can select different occurrences of the table for joining.
Select a different table from either of the lists in the Join Tables panel, or return to the Tables panel and specify the same table more than once as described above.
See DSQ85241
Follow the directions in the referenced message.
See DSQ84486
Follow the directions in the referenced message.
See DSQ85241
Follow the directions in the referenced message.
See DSQ85226
Follow the directions in the referenced message.
The columns you selected don't have compatible data types.
You are attempting to join two tables using columns that do not have compatible data types. For example, you may be attempting to join using a column that is numeric and another column that is non-numeric.
Choose two columns that are compatible. Then press Enter. To find out what a column's data type is, move the cursor to the column name and press the Describe key.
The item you selected will not fit in the entry field.
The item you selected will not fit into the remaining space of the entry field into which the item is to be moved. For example, you may have selected a column name to go into the Expression panel, but there is not enough room left in the entry field to accept the column name.
Condense the contents of the entry field so that the item you selected will fit, or select a shorter item.
Select a choice from each list.
You either made a selection from only one of the lists, or you made no selection at all. This panel requires that selections be made from each list.
Make a selection from each list shown on the panel. Then press Enter.
See DSQ84481
Follow the directions in the referenced message.
You may only use Describe with a table name on this panel.
You used the Describe key while your cursor was positioned on a line which does not include a table name. On this panel, you may only use the Describe key while your cursor is positioned on a line which does include a table name.
Reposition your cursor to a line with a table name and then use the Describe key to retrieve information about that table.
You may only use Describe with a column name on this panel.
You used the Describe key while your cursor was positioned on a line which does not include a column name. On this panel, you may only use the Describe key while your cursor is positioned on a line which does include a column name.
Reposition your cursor to a line with a column name and then use the Describe key to retrieve information about that column.
See DSQ84475
Follow the directions in the referenced message.
See DSQ84480
Follow the directions in the referenced message.
You must type a value in each entry field.
You entered a value in one entry field, but not in the other.
Enter a value in both entry fields. Then press Enter.
See DSQ84480
Follow the directions in the referenced message.
The variable beginning with &V2 is longer than 18 characters.
Variable names cannot have more than 18 characters.
Choose a shorter variable name.
You can't use a summary function in a summary function.
You tried to specify a summary function (such as SUM, AVG, MIN, MAX, or COUNT) within another summary function. This is not allowed in a Prompted Query.
Change your query to remove the inner summary function.
You can't use a summary function in a row condition.
You tried to use a summary function (such as SUM, AVG, MIN, MAX, or COUNT) in a row condition. This is not allowed in a Prompted Query.
Either remove the summary function from the row condition or convert your Prompted Query to an SQL Query, which allows summary functions within WHERE clauses.
See DSQ84300
Follow the directions in the referenced message.
Free storage failed.
Follow the directions in the referenced message.
Data is too long. Check your quotes.
A character constant must be enclosed in quotes. If you omit a closing quote, your data could exceed the maximum length: 254 characters normally, or 127 graphic characters if you are using the Double Byte Character Set under SQL/DS.
Change your data and run the query again.
The expression is too long.
The maximum allowable number of character positions is 255. The expression may have become too long because you typed over some special DBCS identification characters, or you may have used too many single quotes (which are doubled when the expression is processed.)
Delete data from the expression so that it fits within the allowable maximum number of character positions.
The expression, when processed, will exceed 255 characters.
The expression may have unqualified column names in it which, when qualified, will cause the expression to be longer than the allowable maximum of 255 characters.
Delete data from the expression so that it is less than the allowable maximum number of characters.
Invalid function code '&1' passed to module.
Follow the directions in the referenced message.
See DSQ84300
Follow the directions in the referenced message.
Free storage failed.
Follow the directions in the referenced message.
Invalid type code: &1.
This is a system error. See your system administrator for assistance, or consult the Installing and Managing QMF manual for your operating system.
Invalid list item index: &1.
Follow the directions in the referenced message.
Invalid storage pool ID: &1.
Follow the directions in the referenced message.
Invalid list item index: &1.
Follow the directions in the referenced message.
Invalid function code '&1' passed to module.
Follow the directions in the referenced message.
Target area not twice as long as source area.
This is a system error. See your system administrator for assistance, or consult the Installing and Managing QMF manual for your operating system.
Free storage failed.
Follow the directions in the referenced message.
Prompted Query Manager Error - unexpected input.
Follow the directions in the referenced message.
See DSQ84300
Follow the directions in the referenced message.
The query is empty or contains only comments.
An empty query, or one containing only comments, contains no instructions to do anything. It cannot be run.
If the query is a Prompted Query, it cannot be converted to SQL and the equivalent SQL statements cannot be shown using the "SHOW SQL" command.
Create another query.
Free storage failed.
Follow the directions in the referenced message.
Prompted Query Manager Error - unexpected input.
Follow the directions in the referenced message.
See DSQ84300
Follow the directions in the referenced message.
Free storage failed.
Follow the directions in the referenced message.
See DSQ84300
Follow the directions in the referenced message.
Free storage failed.
Follow the directions in the referenced message.
See DSQ84300
Follow the directions in the referenced message.
Free storage failed.
Follow the directions in the referenced message.
Prompted Query Manager Error - unexpected input.
Follow the directions in the referenced message.
See DSQ84300
Follow the directions in the referenced message.
Prompted Query Manager Error - unexpected input.
Follow the directions in the referenced message.
See DSQ84300
Follow the directions in the referenced message.
Free storage failed.
Follow the directions in the referenced message.
Prompted Query Manager Error - unexpected input.
Follow the directions in the referenced message.
Free storage failed.
Follow the directions in the referenced message.
See DSQ84300
Follow the directions in the referenced message.
The SQL generated by Prompted Query is too large.
QMF generates an SQL query that is equivalent to your Prompted Query. The SQL generation failed because the length of the SQL generated was greater than the database can handle.
Split the query up into multiple smaller queries.
Free storage failed.
Follow the directions in the referenced message.
See DSQ85272
Follow the directions in the referenced message.
Prompted Query Manager Error - unexpected input.
Follow the directions in the referenced message.
Free storage failed.
Follow the directions in the referenced message.
See DSQ84300
Follow the directions in the referenced message.
Free storage failed.
Follow the directions in the referenced message.
Column &V1 is in more than one table.
The column name &V1 exists in more than one listed table. Qualify the column name so that the column can be matched with the corresponding table. Some examples are:
PERS.DEPT is the column named "DEPT" in table PERS. Q.STAFF.DEPT is the column named "DEPT" in table Q.STAFF.
Qualify column name &V1.
The expression starting with &V1 is incomplete.
The expression, most likely built with substitution variables, is missing some delimiters. Qualify the column name so that the column can be matched with the corresponding table. Some examples are:
SUM(SALARY is missing the right parenthesis. Q.STAFF. is missing the column qualifier.
Add the missing delimiters.
Column name starting with &V1 is invalid.
The column name could not be matched to any valid column name of a table in the query. If a table or site qualifier is given, they may be in error.
Correct the column name.
Prompted Query Manager Error - unexpected input.
Follow the directions in the referenced message.
See DSQ84300
Follow the directions in the referenced message.
Prompted Query Manager Error - unexpected input.
Follow the directions in the referenced message.
Free storage failed.
Follow the directions in the referenced message.
The ALL keyword under Columns cannot be deleted.
You are attempting to delete the default ALL keyword that indicates that all columns from the selected table or tables should be selected. This entry cannot be deleted. The ALL keyword will be removed if you select any columns in the query.
Move the cursor to a valid location for DELETE. If you want to select some columns for your query, enter the SPECIFY command and select Columns from the panel.
See DSQ84300
Follow the directions in the referenced message.
Prompted Query Manager Error - unexpected input.
Follow the directions in the referenced message.
Free storage failed.
Follow the directions in the referenced message.
See DSQ84300
Follow the directions in the referenced message.
See DSQ84388
Follow the directions in the referenced message.
See DSQ84387
Follow the directions in the referenced message.
The cursor is not in position for &V1..
To change a part of the query, the cursor must be placed on a detail line for a Column, Row Condition, Sort Condition, or Duplicate Row information.
Move the cursor to the line you want to change and press the CHANGE PF key (if available) or type CHANGE on the command line and then move the cursor to the appropriate line and hit ENTER.
OK, &1 performed; proceed.
No more lines can be inserted here.
The area in which you have attempted to insert a line already contains the maximum number (&V1.) that are allowed.
Delete any lines that you no longer need.
See DSQ84388
Follow the directions in the referenced message.
The only table in a Prompted Query cannot be deleted.
You are attempting to delete the only table in a Prompted Query. This table cannot be deleted because deleting it would cause the query to be completely empty. You can create an empty query by using the RESET command.
Move to cursor to a valid location for DELETE and re-issue the DELETE command. If you want to remove this table from the query, issue the RESET QUERY (LANGUAGE=PROMPTED command.
You cannot change a table name in a Prompted Query.
You are attempting to change a table name in a Prompted Query. Table names cannot be changed.
Move the cursor to a valid location for CHANGE. If you want to replace this table with a different one, use the DELETE and INSERT commands to remove this table from the query and to add another table.
You cannot change a Join Condition in a Prompted Query.
You are attempting to change a Join Condition in a Prompted Query. Join Conditions cannot be changed.
Move the cursor to a valid location for CHANGE. If you want to replace this Join Condition with a different one, you can use the DELETE command to remove all of the Join Conditions (note that they will ALL be deleted). Panels will then be displayed to guide you through the specification of the new Join Conditions.
The ALL keyword under Columns cannot be changed.
You are attempting to change the default ALL keyword that indicates that all columns from the selected table or tables should be selected. This entry cannot be changed.The ALL keyword will be removed if you select any columns in the query.
Move the cursor to a valid location for CHANGE. If you want to select some columns for your query, enter the SPECIFY command and select Columns from the panel.
This column selection is too long to change.
You are attempting to change a column selection in a Prompted Query that is more than 65 characters long. This selection was created outside of QMF and cannot be changed within QMF because the expression will not fit in the Change Column window.
Move the cursor to a valid location for CHANGE. If you want to change this column selection, export the query, modify the query using an editor, and import the modified query.
This row condition contains an expression that is too long to change.
You are attempting to change a row condition in a Prompted Query that contains either a left side expression that is more than 65 characters long or a right side expression that is more than 45 characters long. This row condition was created outside of QMF and cannot be changed within QMF because the expression is too long to display in a window.
Move the cursor to a valid location for CHANGE. If you want to change this row condition, export the query, modify the query using an editor, and import the modified query.
Free storage failed.
Follow the directions in the referenced message.
See DSQ84300
Follow the directions in the referenced message.
Free storage failed.
Follow the directions in the referenced message.
See DSQ85266
Follow the directions in the referenced message.
Unexpected T record at record &V1 in retrieved query.
The prompted query you were retrieving contains an error. The T record at record &V1 in the retrieved query is not the expected one. The TABLES T record must be the first T record (and must immediately follow the H record), and the JOINS T record must be the second. The remaining T records may be in any order.
If you are creating an application which builds or modifies the query, correct the order of T records. See the Developing QMF Applications manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
Same table specified for both sides of join condition.
The prompted query you were retrieving contains an error. In record &V1 the same table is specified for both sides of the join condition. If there is only one table in the query, no join is possible. If you really need to join a table to itself, you can do so by specifying the table more than once in the Table Definitions Table of the query to be retrieved. You can then specify the two different occurrences of the table in the join.
If you are creating an application which builds or modifies the query, correct the join condition so that it joins together two tables that are specified in the query. See the Developing QMF Applications for more information on join conditions in prompted queries. Otherwise, contact your QMF administrator for assistance.
Join condition does not use a column name.
The prompted query you were retrieving contains an error. The join condition in record &V1 specifies an expression or a literal constant to be used as part of the join condition. Both sides of the join condition must be column names from two of the tables specified in the query.
If you are creating an application which builds or modifies the query, correct it so each join condition refers to two columns from two of the tables that are specified in the query. See the Developing QMF Applications manual for more information on join conditions in retrieved prompted queries. Otherwise, contact your QMF administrator for assistance.
Tables specified in join condition are already joined.
The prompted query you were retrieving contains an error. The join condition in record &V1 specifies two tables that are already joined by a previous join condition.
If you are developing an application which builds or modifies the query, correct the join condition so that it refers to one table that is already joined and one table that is currently unjoined. See the Developing QMF Applications manual for more information on join conditions in retrieved prompted queries. Otherwise, contact your QMF administrator for assistance.
Too many right side expressions in retrieved query.
The prompted query you were retrieving contains an error. The query contains more than &V2 right side expressions in one row condition. The error was found at record &V1..
If you are creating an application which builds or modifies the query, change the query to have no more than the specified number of right side row condition R records in each row condition. See the Developing QMF Applications manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
Condition connector in retrieved query is invalid.
The condition connector value at position &V2 in record &V1 is invalid. In the first row condition the condition connector value should be the following:
I - If
In subsequent row conditions the value must be one of:
A - And O - Or
If you are creating an application which builds or modifies the query, correct the condition connector value at the indicated location. See the Developing QMF Applications manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
Sort column not selected in columns section of query.
The prompted query you were retrieving contains an error. The sort condition in record &V1 specifies an expression or a column name that is not selected in the columns section of the query. An expression must be selected in the columns section if it is to be used as a sort expression.
If you are creating an application which builds or modifies the query, either change the sort expression so that it matches a column name or expression from the columns section of the query or add the sort expression to the columns section. See the Developing QMF Applications manual for more information. Otherwise, contact your QMF administrator for assistance.
See DSQ85501
Follow the directions in the referenced message.
Too many tables in retrieved query.
The prompted query you were retrieving contains an error. A prompted query may contain at most &V2 tables. The query you were retrieving contains more than that. The problem was found at record &V1 in the query.
If you are creating an application which builds or modifies the query, reduce the number of tables in the query. See the Developing QMF Applications manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
Correlation variable in retrieved query is invalid.
The prompted query you were retrieving contains an error. A correlation variable was expected at position &V2 in record &V1, but an invalid value was found. Any single character from the following groups is valid:
Capital Letters A - Z Special Characters # $ @
If you are creating an application which builds or modifies the query, correct the correlation variable, using one of the choices listed above. See the Developing QMF Applications manual for more information on field values in retrieved queries. Otherwise, contact your QMF administrator for assistance.
Table &V3 does not exist.
The prompted query you were retrieving contains an error. The table &V3 named at position &V2 in record &V1 does not exist. The name may be spelled incorrectly.
Check the spelling of the table name at the indicated location in the query. If it is correct, check whether the table has been inadvertently deleted.
Table &V3 not authorized.
The prompted query you were retrieving contains an error. You are not authorized to use the table &V3 named at position &V2 in record &V1..
Obtain authority to use the table from its owner, or specify a different table in the retrieved query.
Invalid field number &V3 at position &V2 in record &V1..
You are trying to import a form or prompted query that does not have a valid field number in record &V1.. The invalid field number &V3 is located at position &V2 in the V record. A field number must be a 4 digit number. It cannot be blank. The following data value in the V record is ignored.
If you are developing an application that either modifies or builds a form, see the Developing QMF Applications manual for a complete list of valid field numbers. Otherwise, contact your QMF administrator for information on how to proceed.
Duplicates disposition in retrieved query is invalid.
The prompted query you were retrieving contains an error. The value at position &V2 in record &V1 should indicate the disposition for duplicate rows in the query results. Valid values are:
K - Keep duplicate rows. D - Keep single copy of each row.
If you are creating an application which builds or modifies the query, replace the value at the indicated position with one of the choices listed above. See the Developing QMF Applications manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
Invalid table number &V3 at position &V2 in record &V1..
You are trying to retrieve a form or prompted query that does not have a valid table number in the T record &V1.. The invalid table number &V3 is located at position &V2 in the record. A table number must be a 4 digit number. It cannot be blank. All data values in the R records following this T record are ignored.
If you are developing an application that either modifies or builds a form or prompted query, see the Developing QMF Applications manual for a complete list of valid table numbers. Otherwise, contact your QMF administrator for information on how to proceed.
Column type value in retrieved query is invalid.
The prompted query you were retrieving contains an error. The value at position &V2 in record &V1 should indicate a type for the column entry in the R record. The valid values are:
C - Column.
E - Expression.
S - Summary function with an
expression.
F - Summary function (column name
only).If you are creating an application which builds or modifies the query, replace the value at the indicated position with one of of the choices listed above. See the Developing QMF Applications manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
Row condition type value in retrieved query is invalid.
The prompted query you were retrieving contains an error. The value at position &V2 in record &V1 was expected to be &V3 to indicate a type &V3 row condition entry. The valid types are:
1 - Left of operator 2 - Operator 3 - Right of operator 4 - Connector
If you are creating an application which builds or modifies the query, correct the entry type value. See the Developing QMF Applications manual for more information on row condition fields in retrieved prompted queries. Otherwise, contact your QMF administrator for assistance.
Row condition type value in retrieved query is invalid.
The prompted query you were retrieving contains an error. The value at position &V2 in record &V1 should indicate a type for the left of operator in a row condition. The valid values are:
C - Column. E - Expression.
If you are creating an application which builds or modifies the query, replace the value at the indicated position with one of the choices listed above. See the Developing QMF Applications manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
See DSQ85519
Follow the directions in the referenced message.
Row condition verb in retrieved query is invalid.
The prompted query you were retrieving contains an error. The value at position &V2 in record &V1 should be a row condition verb. Valid values are:
IS ISN (abbreviation for Is Not)
If you are creating an application which builds or modifies the query, replace the value at the indicated position with one of the choices listed above. See the Developing QMF Applications manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
Row condition operator in retrieved query is invalid.
The prompted query you were retrieving contains an error. The value at position &V2 in record &V1 should be a row condition operator. Developing QMF Applications manual lists the valid choices for this field.
If you are creating an application which builds or modifies the query, replace the value at the indicated position with a valid row condition operator code. See Developing QMF Applications manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
See DSQ85519
Follow the directions in the referenced message.
See DSQ85506
Follow the directions in the referenced message.
See DSQ84300
Follow the directions in the referenced message.
Duplicate correlation variable in retrieved query.
The prompted query you were retrieving contains an error. Each table correlation variable in a prompted query must be unique. Position &V2 of record &V1 contains correlation variable &V3., which is the same as the correlation variable of another table.
If you are creating an application which builds or modifies the query, assign a unique correlation variable to the indicated table. See the Developing QMF Applications manual for more information on retrieved prompted queries. Otherwise, contact your QMF administrator for assistance.
Sort order value in imported query is invalid.
The prompted query you were importing contains an error. The value at position &V2 in record &V1 should be a sort order value. The valid values are:
A - Ascending order. D - Descending order.
If you are creating an application which builds or modifies the query, replace the value at the indicated position with one of the choices listed above. See the Developing QMF Applications manual for more information on the format of imported prompted queries. Otherwise, contact your QMF administrator for assistance.
Too many join conditions in imported query.
The prompted query you were importing contains an error. The query you were importing contains more than &V2 join condition(s), which is the maximum allowed for this query. The number of join conditions can be at most one less than the number of tables in the query. The problem was found at record &V1 in the query.
If you are creating an application which builds or modifies the query, reduce the number of query join conditions. See the Developing QMF Applications manual for more information on the format of imported prompted queries. Otherwise, contact your QMF administrator for assistance.
Comparison operator in retrieved query is invalid.
The prompted query you were retrieving contains an error. The comparison operator at position &V2 in record &V1 cannot be used with the left side of the condition. For example, the left side of the condition may be a numeric value while the comparison operator is a string function.
If you are creating an application which builds or modifies the query, use a comparison operator that can be used with the left side of the condition. See the Developing QMF Applications manual for more information. Otherwise, contact your QMF administrator for assistance.
See DSQ85516
Follow the directions in the referenced message.
See DSQ85519
Follow the directions in the referenced message.
Error in record &V1 of retrieved prompted query.
The prompted query you were retrieving contains an error. The problem was found in record &V1..
&V2
If you are creating an application which builds or modifies the query, see the Developing QMF Applications manual for more information on how to correct the error. Otherwise, contact your QMF administrator for assistance.
Invalid use of summary function in retrieved query.
The prompted query you were retrieving contains an error. The expression at position &V2 in record &V1 contains a summary function (such as SUM, AVG, MIN, MAX, or COUNT), but the record is part of a row condition, and summary functions are not allowed in prompted query row conditions.
If you are creating an application which builds or modifies the query, remove the summary function, or use an SQL query (which allows summary functions in WHERE clauses) instead of a prompted query. See the Developing QMF Applications manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
Free storage failed.
Follow the directions in the referenced message.
Query section appears more than once in retrieved query.
The prompted query you were retrieving contains an error. A T record with table field number &V2 (or a V record with that field number) appears in the retrieved query more than once. Thus there are two T (or V) records that describe the same query section. The duplicate appears at record &V1..
If you are creating an application which builds or modifies the query, remove one of the duplicate query sections. See the Developing QMF Applications manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
See DSQ85537
Follow the directions in the referenced message.
Table data missing in retrieved query.
The prompted query you were retrieving contains an error. The section of the query beginning at record &V1 contains query elements, but the query does not contain any tables. If a retrieved query does not list any tables in the tables section, it cannot list any query elements in subsequent sections.
If you are developing an application which builds or modifies the query, add at least one table to the tables section of the query. See the Developing QMF Applications manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
The expression in record &V1., when processed, will exceed 255 character.
The prompted query you were retrieving contains an error. The expression in record &V1., may have unqualified column names in it, which, when qualified, will cause the expression to be longer than the allowable maximum of 255 characters.
If you are creating an application that builds or modifies the query, make sure that any expression it builds will be less than 255 characters long, even after all column names in it have been fully qualified. See Developing QMF Applications manual for more information on the external format of prompted queries. Otherwise, contact your QMF administrator for assistance.
Your query cannot have more than &V1 tables.
You have entered more table names than are allowed for the query you are creating.
Reduce the number of selected tables so that the total does not exceed &V1.. Then press Enter.
See DSQ84475
Follow the directions in the referenced message.
See DSQ84480
Follow the directions in the referenced message.
&V1.&V2.&V3.&V4.&V5 does not exist.
The table you named does not exist. Perhaps you typed it incorrectly. You can list the names of the tables you may include in your query by using the List function.
Check the spelling of the table name. Either type it correctly, or select it from the list of table names.
You are not authorized to use &V1.&V2.&V3.&V4.&V5..
You specified that the table shown in the message be used in your query, but you are not authorized to access the table.
Obtain authority to use the table from its owner, or specify a different table.
See DSQ84300
Follow the directions in the referenced message.
Free storage failed.
Follow the directions in the referenced message.
See DSQ84300
Follow the directions in the referenced message.
Invalid function code '&1' passed to module.
Follow the directions in the referenced message.
See DSQ84300
Follow the directions in the referenced message.
Invalid function code '&1' passed to module.
Follow the directions in the referenced message.
Panel process error: panel=&1, code=&2.
Follow the directions in the referenced message.
You have too little storage space.
Your command cannot be executed because you don't have enough space in computer storage. The amount of reserved space (parameter R on the command ISPSTART) may be too large.
See your QMF administrator about increasing your amount of storage space. You cannot correct the problem through QMF.
Free storage failed.
Follow the directions in the referenced message.
Invalid function code '&1' passed to module.
Follow the directions in the referenced message.
No PREVIOUS entry exists.
Your command cannot be executed because you have not entered any data that was saved.
Key the data in the columns and use the appropriate command (ADD or SEARCH) before using the PREVIOUS command to retrieve the modified entry.
There is a data overflow for this field.
A DBCS character string was expected at the end of the input field but was keyed over which resulted in a data overflow for this field.
Enter a DBCS character string at the end of the input field.
You have caused a data overflow for this field.
You have overlaid part of a DBCS character string which resulted in a data overflow for this field.
Delete data from the end of the character string to allow the data to fit within the field.
You cannot use REFRESH now.
The contents of the displayed database row cannot be refreshed due to an unsuccessful attempt to update the row.
Continue editing the data, or return to Search mode. To refresh the currently displayed row: 1) Show Search 2) Previous 3) Search 4) If the desired row is not displayed, use the Next command until it is displayed
Panel process error: panel=&1, code=&2.
Follow the directions in the referenced message.
See DSQ85622
Follow the directions in the referenced message.
Free storage failed.
Follow the directions in the referenced message.
CANCEL does not run when SAVE=IMMEDIATE.
You have specified SAVE=IMMEDIATE, which means that additions, changes, and deletions are made permanent in the database as they are executed. Thus, the CANCEL command cannot be used to discard them.
Do not issue the CANCEL command now. Only the END command can be used to end the Table Editor session when SAVE=IMMEDIATE.
Invalid function code '&1' passed to module.
Follow the directions in the referenced message.
Panel process error: panel=&1, code=&2.
Follow the directions in the referenced message.
&V1 performed. No more rows meet your search criteria.
You have accessed all the rows meeting the search criteria you entered.
Use the PREVIOUS command followed by the SEARCH command to reaccess the set of rows, or key in a new search criteria to retrieve a different set of rows.
No rows meeting your search criteria were found.
There were no rows found which match the search criteria you entered.
Check the search criteria for errors or key in a different search criteria.
You cannot use SHOW &V1 on this panel.
SHOW &V1 is not a valid operation for this panel.
Do not attempt to use this operation on this panel. Move to a panel which allows this operation to be performed.
You cannot use SHOW FIELD for columns with non-displayable data.
SHOW FIELD can normally be used to change data in the column you selected. However, the selected column for the current row contains data which is non-displayable.
To change data in this column you must use some other means, such as SQL. You may still change data in other columns of this row or you may delete this row.
You must SEARCH for the rows you want to CHANGE.
You must perform a SEARCH to retrieve a set of rows before you can modify the rows.
Key in the search criteria to retrieve a specific set of rows, or leave the null indicator (&V1.) in all columns to retrieve all the rows in the table.
Panel process error: panel=&1, code=&2.
Follow the directions in the referenced message.
You cannot use SHOW FIELD on this wide column.
You cannot use SHOW FIELD to enter a search condition on columns that have more than 254 characters (or 127 DBCS characters). This restriction is imposed by the database you are using.
Move to a column that is 254 characters (or 127 DBCS characters) or less before entering a search condition.
You cannot use SHOW FIELD on a GRAPHIC column with this display.
You cannot use SHOW FIELD for a column that is defined as GRAPHIC or VARGRAPHIC if your display does not support the double byte character set.
Move to a column that is not a GRAPHIC type or use another display device.
Sorry, cursor must be on a column to use SHOW FIELD.
The cursor is not pointing at a column.
Move the cursor to a column entry area before using SHOW FIELD.
INTEGER: -2147483648 to 2147483647, no default, never null.
This column is an integer data type. It can contain a number in the range -2147483648 to 2147483647 (Up to 10 digits).
The reserved character for default (&V2.) is not allowed in this column in Add or Change mode.
The reserved character for null (&V1.) is not allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
INTEGER: -2147483648 to 2147483647, no default, null allowed.
This column is an integer data type. It can contain a number in the range -2147483648 to 2147483647 (Up to 10 digits).
The reserved character for default (&V2.) is not allowed in this column in Add or Change mode.
The reserved character for null (&V1.) is allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
SMALL INTEGER: -32768 to 32767, no default, never null.
This column is a small integer data type. It can contain a number in the range -32768 to 32767.
The reserved character for default (&V2.) is not allowed in this column in Add or Change mode.
The reserved character for null (&V1.) is not allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
SMALL INTEGER: -32768 to 32767, no default, null allowed.
This column is a small integer data type. It can contain a number in the range -32768 to 32767.
The reserved character for default (&V2.) is not allowed in this column in Add or Change mode.
The reserved character for null (&V1.) is allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
FLOAT: (+/-)&V1&V2&V3.E(+/-)ee, no default, never null.
In the format shown above
The exponent portion may be omitted.
The reserved character for default (&V5.) is not allowed in this column in Add or Change mode.
The reserved character for null (&V4.) is not allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
FLOAT: (+/-)&V1&V2&V3.E(+/-)ee, no default, null allowed.
In the format shown above
The exponent portion may be omitted.
The reserved character for default (&V5.) is not allowed in this column in Add or Change mode.
The reserved character for null (&V4.) is allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
DECIMAL: &V1 digits before decimal, &V2 after, no default, never null.
This column is a decimal data type. A plus or minus sign may be used before the decimal number. Plus is assumed if the sign is omitted.
The reserved character for default (&V4.) is not allowed in this column in Add or Change mode.
The reserved character for null (&V3.) is not allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
DECIMAL: &V1 digits before decimal, &V2 after, no default, null allowed.
This column is a decimal data type. A plus or minus sign may be used before the decimal number. Plus is assumed if the sign is omitted.
The reserved character for default (&V4.) is not allowed in this column in Add or Change mode.
The reserved character for null (&V3.) is allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
VARYING CHARACTER(&V1): no default, never null.
This column is a varying character data type. It can contain up to &V1 characters. Trailing blanks are stripped from the data.
The reserved character for default (&V3.) is not allowed in this column in Add or Change mode.
The reserved character for null (&V2.) is not allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
VARYING CHARACTER(&V1): no default, null allowed.
This column is a varying character data type. It can contain up to &V1 characters. Trailing blanks are stripped from the data.
The reserved character for default (&V3.) is not allowed in this column in Add or Change mode.
The reserved character for null (&V2.) is allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
CHARACTER(&V1): no default, never null.
This column can contain up to &V1 characters. The column in the database is always &V1 characters long. Blanks are added to the end of the column if you key less than &V1 characters.
The reserved character for default (&V3.) is not allowed in this column in Add or Change mode.
The reserved character for null (&V2.) is not allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
CHARACTER(&V1): no default, null allowed.
This column can contain up to &V1 characters. The column in the database is always &V1 characters long. Blanks are added to the end of the column if you key less than &V1 characters.
The reserved character for default (&V3.) is not allowed in this column in Add or Change mode.
The reserved character for null (&V2.) is allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
VARYING GRAPHIC(&V1): no default, never null.
This column can contain up to &V1 DBCS characters. Trailing blanks are stripped from the data.
The reserved character for default (&V3.) is not allowed in this column in Add or Change mode.
The reserved character for null (&V2.) is not allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
VARYING GRAPHIC(&V1): no default, null allowed.
This column can contain up to &V1 DBCS characters. Trailing blanks are stripped from the data.
The reserved character for default (&V3.) is not allowed in this column in Add or Change mode.
The reserved character for null (&V2.) is allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
GRAPHIC(&V1): no default, never null.
This column can contain up to &V1 DBCS characters. The column in the database is always &V1 characters long. Blanks are added to the end of the column if you key less than &V1 characters.
The reserved character for default (&V3.) is not allowed in this column in Add or Change mode.
The reserved character for null (&V2.) is not allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
GRAPHIC(&V1): no default, null allowed.
This column can contain up to &V1 DBCS characters. The column in the database is always &V1 characters long. Blanks are added to the end of the column if you key less than &V1 characters.
The reserved character for default (&V3.) is not allowed in this column in Add or Change mode.
The reserved character for null (&V2.) is allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
DATE: &V1, no default, never null.
The default format for the date is shown above. The correct format for entering data is "mm/dd/yyyy" or "yyyy-mm-dd" or "dd.mm.yyyy" or the local date format for your installation.
The reserved character for default (&V3.) is not allowed in this column in Add or Change mode.
The reserved character for null (&V2.) is not allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Enter your date in one of the valid formats.
DATE: &V1, no default, null allowed.
The default format for the date is shown above. The correct format for entering data is "mm/dd/yyyy" or "yyyy-mm-dd" or "dd.mm.yyyy" or the local date format for your installation.
The reserved character for default (&V3.) is not allowed in this column in Add or Change mode.
The reserved character for null (&V2.) is allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Enter your date in one of the valid formats.
TIME: &V1, no default, never null.
The default format for the time is shown above. The correct format for entering data is "hh:mm AM (or PM)" or "hh:mm:ss" or "hh.mm.ss" or the local time format for your installation.
The seconds are optional.
The reserved character for default (&V3.) is not allowed in this column in Add or Change mode.
The reserved character for null (&V2.) is not allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Enter your time in one of the valid formats.
TIME: &V1, no default, null allowed.
The default format for the time is shown above. The correct format for entering data is "hh:mm AM (or PM)" or "hh:mm:ss" or "hh.mm.ss" or the local time format for your installation.
The seconds are optional.
The reserved character for default (&V3.) is not allowed in this column in Add or Change mode.
The reserved character for null (&V2.) is allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Enter your time in one of the valid formats.
TIMESTAMP: yyyy-mm-dd-hh.mm.ss.nnnnnn, no default, never null.
In the timestamp format shown above
yyyy-mm-dd is the year, month, and day hh.mm.ss is the hour, minute, seconds nnnnnn is the microseconds
The microseconds are optional.
The reserved character for default (&V2.) is not allowed in this column in Add or Change mode.
The reserved character for null (&V1.) is not allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
TIMESTAMP: yyyy-mm-dd-hh.mm.ss.nnnnnn, no default, null allowed.
In the timestamp format shown above
yyyy-mm-dd is the year, month, and day hh.mm.ss is the hour, minute, seconds nnnnnn is the microseconds
The microseconds are optional.
The reserved character for default (&V2.) is not allowed in this column in Add or Change mode.
The reserved character for null (&V1.) is allowed in this column in Add or Change mode.
SHOW FIELD does not display the data in this column.
Use the message as a guide if you want to enter data into this column. Press enter to clear the message.
OK, VARYING CHARACTER(&1) shown, no default, never null.
OK, VARYING CHARACTER(&1) shown, no default, null allowed.
OK, CHARACTER(&1) shown, no default, never null.
OK, CHARACTER(&1) shown, no default, null allowed.
OK, VARYING GRAPHIC(&1) shown, no default, never null.
OK, VARYING GRAPHIC(&1) shown, no default, null allowed.
OK, GRAPHIC(&1) shown, no default, never null.
OK, GRAPHIC(&1) shown, no default, null allowed.
Invalid data type of '&1' encountered.
This is a system error. Please see your system administrator for assistance, or consult the Installing and Managing QMF manual for your operating system.
OK, VARYING CHARACTER(&1) shown. Search will use LIKE.
OK, VARYING GRAPHIC(&1) shown. Search will use LIKE.
Invalid data type of '&1' encountered.
Follow the directions in the referenced message.
You do not have the authority to do this.
The authority you need depends on what you are doing:
See your QMF administrator to obtain the necessary authorization.
Invalid function code '&1' passed to module.
Follow the directions in the referenced message.
See DSQ84300
Follow the directions in the referenced message.
See DSQ85723
Follow the directions in the referenced message.
&V1..&V2 is an empty table or view.
The table or view you are trying to edit is empty. Change Mode of the Table Editor cannot be used.
Choose a different table or view, or use the Table Editor Add Mode if you wish to insert rows.
Free storage failed.
Follow the directions in the referenced message.