Regarding dbc.qrylogsql table's sqltextinfo

Database
Enthusiast

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.

3 REPLIES
Enthusiast

Re: Regarding dbc.qrylogsql table's sqltextinfo

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

Enthusiast

Re: Regarding dbc.qrylogsql table's sqltextinfo

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.

Enthusiast

Re: Regarding dbc.qrylogsql table's sqltextinfo

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