The Text field gets truncated using a Select .
The online help says that DBTEXTLIMIT could
be limiting it ..... I am also aware of SET TEXTSIZE.
How can I see or change the value of DBTEXTLIMIT
which is in DB-LIBRARY.
Is there any way to fix it in the query analyzer ...
It seems some records dont get truncated and
others do ...I dont understand why ....Different
kind data is being displayed tho
Then use the 'Current Connection Options'-MenuItem in the
'Query'-Menu of the Query Analyzer
and in the Advanced-box you can modify
the 'Maximum characters per column'
Query analyzer has an option that is user settable. It is the result set maximum characters per column. Check out the option in QA. Terry L. Broadbent - DBA
Computing Links:
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.