I am working on TD 12 and noticed that DBC QRYLOG view and underlying DBQL table have incomplete query string in QueryText column ( around 200 chars ) even though datatype shows VARCHAR(10000) .
Is there any other table we can retrieve this information from or is there a property which can be tuned for this ?
It depend on the query log settings. So you can define how much chars should be logged in the qrylog table.
If SQL logging is enabled - which is often the case if the SQL is shorten for the qrylog table - you might find the SQL text in the corrosponding SQL table.
Otherwise you can ask your DBA to extend the SQL text logging for you