Kbase P5392: What is -tok parameter ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/03/2011 |
|
Status: Verified
GOAL:
What is -tok parameter ?
GOAL:
Does the -tok startup parameter have a maximum value?
GOAL:
What is -tok refered in error 136?
GOAL:
** More than <value> items in a single statement. Use the -tok parameter. (136)
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
FIX:
-tok paramter is a client-session parameter specify the maximum number of tokens allowed in a single ABL statement.
Each word or special character, such as parenthesis, plus sign, and minus sign, counts as one token.
When the tokens in a single statement are exceeded, error 136 is triggered.
The default number of tokens per statement is 1024 for OpenEdge 10.1A and below.
The default number of token has increased to 3000 on OpenEdge 10.1B or later.
The maximun number of tokens per statement is 1600 for Progress 8.3B and below.
Starting on Progress 8.3C, Progress 9.x and above, it is limited only by available memory on the system.
A token is tiny ? something less than 50 bytes.
Notes:
For dynamic queries, we don?t use the session token array, but rather we alloc and free for each query. However, only one can happen at a time, and we do use ?tok for it too.
Increasing ?tok a lot can run into limitations on ?inp (the size of the input string).That is, it wont help to allow twice as many tokens if the input string does not have room for the statement as a whole.