SAP Knowledge Base Article - Preview

2931086 - NFR to honor newline characters when logging SQL into a request log - SAP IQ

Symptom

IQ servers don't honor newline characters when logging SQL into a request log.

For example, if I have an sql like:

declare @var1 int,
@var2 int,
@var3 int
select @var1=1
select @var2=2
select @var3=@var1+@var2
select @var3 as a

In sqllog file it shows as:

0522 183708.402,<,215,EXEC_ANY_IMM, declare @var1 integer, @var2 integer, @var3 integer select @var1 = 1 select @var2 = 2 select @var3 = @var1+@var2 select 'a'=@var3


Read more...

Environment

  • SAP IQ 16.1
  • SAP IQ 16.0

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

CR821790, CR#821790, 821790, sqllog, zrlog , KBA , BC-SYB-IQ , Sybase IQ , Product Enhancement

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.