ID Number: Q80399
1.11 4.20
OS/2
buglist1.11 buglist4.20
Summary:
Problem ID: PRSQL9201006
SYMPTOMS
While running an operation that generates more than 511 lines of
error messages in the result window, SAF (the System Administration
Facility) incorrectly displays the following message:
The maximum number of lines (511) has been exceeded.
The input file has been truncated.
<OK>
This message is incorrect because in the above case, it is the
output message window that has more than 511 lines, not the query
or input file.
CAUSE
The above message is displayed as a result of query execution, for
each message generated after 511 message lines in the result
window. Therefore, choosing OK in the message box apparently may
not remove the message box if the number of messages generated is
large.
WORKAROUND
To work around this problem, do one of the following:
- Use ISQL to run the query.
-or-
- Run the query so that fewer than 511 lines of messages are
generated.
This can be done by breaking up the query to operate on smaller
batches.
STATUS
Microsoft has confirmed this to be a problem in SQL Server versions
1.11 and 4.2. We are researching this problem and will post new
information here as it becomes available.
Additional reference words: 4.20