This website is not affiliated with, sponsored by, or approved by SAP AG.

SAP Open SQL message size

Basis (Basis Technology Modules: Basis Component/System Administration, GUIs)

Moderators: Snowy, thx4allthefish

SAP Open SQL message size

Postby DrSidewalk » Mon Jul 14, 2014 7:44 am

Many years back I remember getting our Basis team to extend the size of the SAP SQL statement size. I can't remember whether this was a SAP change or an SAP/Oracle change. I also remember change the number of entries that can appear in the 'FOR ALL ENTRIES IN' clause as well. Again I can't remember how that is done either and our SAP Basis team (off-shore) have been unable to find this.

At present anything over 5 entries in the 'FOR ALL ENTRIES IN' clause are pushed into another SQL statement and UNION'ed together. So if we have 100 materials in itab identified in the FOR ALL ENTRIES IN itab then we'll get 20 SQL statements Union'ed together. WHich is not nice.

Can anyone be of help?. I think we have something like 500 characters at the maximum SQL size in characters, and I believe we can go up as far as 2Kb (2048 chars).

Dr Sidewalk
DrSidewalk
 
Posts: 180
Joined: Thu May 03, 2012 9:35 am

Re: SAP Open SQL message size

Postby DrSidewalk » Tue Jul 15, 2014 4:28 am

Anyone?.
DrSidewalk
 
Posts: 180
Joined: Thu May 03, 2012 9:35 am

Re: SAP Open SQL message size

Postby Gothmog » Tue Jul 15, 2014 6:58 am

Maybe the following OSS notes can help you:
48230 - Parameterization of SELECT ... FOR ALL ENTRIES statement
634263 - Selects with FOR ALL ENTRIES
68 74 74 70 3a 2f 2f 74 69 6e 79 75 72 6c 2e 63 6f 6d 2f 62 64 6f 37 6d 77 67
Gothmog
 
Posts: 1943
Joined: Wed Sep 12, 2007 4:46 am
Location: Probably not home

Re: SAP Open SQL message size

Postby Snowy » Tue Jul 15, 2014 3:23 pm

what is your SAP product and version?
and this is with Oracle version?
SapFans Moderator

Search: http://www.sapfans.com/forums/search.php
Notes: http://service.sap.com/notes
Help: http://help.sap.com
Rules: http://www.sapfans.com/forums/viewtopic.php?t=344127
Snowy
 
Posts: 28768
Joined: Mon Oct 21, 2002 2:33 pm
Location: 3.1415926535

Re: SAP Open SQL message size

Postby DrSidewalk » Wed Jul 16, 2014 10:22 am

Have mentoned that our Database is Oracle, in my posting. I don't think the version/Release of SAP would make that much difference, but we are SAP_BASIS/SAP_ABAP Release 702.

I think the postings by Gothmog will be of some help.
Although I keep seeing postings in various places to say that in the later versions the SQL statement can be increased to 1Mb from the 4Kb it used to be. But they never say how this can be achieved, just that it can be achieved.
DrSidewalk
 
Posts: 180
Joined: Thu May 03, 2012 9:35 am


Return to Basis

Who is online

Users browsing this forum: No registered users and 8 guests



cron


This website is not affiliated with, sponsored by, or approved by SAP AG.