All Forums Database
praveen_reddy 22 posts Joined 10/11
02 Jan 2014
Regarding dbc.qrylogsql table's sqltextinfo

Hi All,
I am using the column sqltextinfo in dbc.qrylogsql table and its giving .txt files. Can i get plain text in the table itself.
Regards,
Praveen.

Raja_KT 1246 posts Joined 07/09
02 Jan 2014

Hi Praveen,
As far as I know, no. However, I think you cna do this way:

create table tmp as(select sqltextinfo from dbc.qrylogsql ) with data;

 

Cheers and Happy New Year,

Raja

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

praveen_reddy 22 posts Joined 10/11
02 Jan 2014

Hi Raja,
 
Thanks for the quick response... If i am joining with dbc.qrylog its getting plain txt but if i joined with dbc.qrylogtbl i am getting .txt files.
 
Regards,
Praveen.

Raja_KT 1246 posts Joined 07/09
02 Jan 2014

I am not sure of plain text and .txt .Maybe your settings in SQL Assistant. Can you cast it to a varchar 64000 maybe and see if it works.
Cheers,
Raja

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.