Skip to Content
0

IQ 16 SP11 PL03 - sql slow

Dec 14, 2016 at 04:56 PM

70

avatar image
Former Member

Disable for varchar and varbinary the use of maximum width ever inserted, rather than the declared maximum width

set temporary option dml_options14=8 ;

Apply this setting, SQL report runs fast; it has nothing to do data insert, a report SQL.

Where to find detail info for option dml_options14=8?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

John Ting
Dec 15, 2016 at 08:21 AM
0

Rey

I remember seeing a related problem in Cr 799266

https://launchpad.support.sap.com/#/notes/2324233/E

Regards

John

Share
10 |10000 characters needed characters left characters exceeded
Roland Kramer
Jan 31, 2017 at 11:52 AM
0

Hi,

See the latest SAP IQ Updates in the following Document - SAP First Guidance – SAP-NLS Solution with SAP IQ

Best Regards Roland

Share
10 |10000 characters needed characters left characters exceeded