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.