topic Re: OPEN CURSOR WITH HOLD in Native SQL in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/open-cursor-with-hold-in-native-sql/m-p/8507550#M1654614 <HTML><HEAD></HEAD><BODY><P>HI ALL,</P><P></P><P>Native SQL checks for synatx errors in requests recieved and passes the request to database through gateway service. </P><P>depending on the DB,performance varies.</P><P></P><P>Regards,</P><P>Namitha.</P></BODY></HTML> Fri, 03 Feb 2012 04:43:51 GMT Former Member 2012-02-03T04:43:51Z OPEN CURSOR WITH HOLD in Native SQL https://community.sap.com/t5/application-development-and-automation-discussions/open-cursor-with-hold-in-native-sql/m-p/8507547#M1654611 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am fetching the data from Other SAP system by using Native SQL.</P><P></P><P>In Native SQL, I am using Open Cursor</P><P></P><P>But cursor is getting closed for second time if i wanted to fetch the data second time.</P><P></P><P>So I am planning to use WITH HOLD Option but it is not working.Could you please help us here.</P></BODY></HTML> Thu, 02 Feb 2012 16:02:33 GMT https://community.sap.com/t5/application-development-and-automation-discussions/open-cursor-with-hold-in-native-sql/m-p/8507547#M1654611 Former Member 2012-02-02T16:02:33Z Re: OPEN CURSOR WITH HOLD in Native SQL https://community.sap.com/t5/application-development-and-automation-discussions/open-cursor-with-hold-in-native-sql/m-p/8507548#M1654612 <HTML><HEAD></HEAD><BODY><P>Native SQL is dependent on your database. So it's not possible to give a good answer without knowing that.</P><P></P><P>Rob</P></BODY></HTML> Thu, 02 Feb 2012 16:09:18 GMT https://community.sap.com/t5/application-development-and-automation-discussions/open-cursor-with-hold-in-native-sql/m-p/8507548#M1654612 Former Member 2012-02-02T16:09:18Z Re: OPEN CURSOR WITH HOLD in Native SQL https://community.sap.com/t5/application-development-and-automation-discussions/open-cursor-with-hold-in-native-sql/m-p/8507549#M1654613 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P> It depends on each database. One possiblity is use FOR UPDATE statement</P><P></P><P>Best regards</P></BODY></HTML> Thu, 02 Feb 2012 16:39:50 GMT https://community.sap.com/t5/application-development-and-automation-discussions/open-cursor-with-hold-in-native-sql/m-p/8507549#M1654613 former_member214857 2012-02-02T16:39:50Z Re: OPEN CURSOR WITH HOLD in Native SQL https://community.sap.com/t5/application-development-and-automation-discussions/open-cursor-with-hold-in-native-sql/m-p/8507550#M1654614 <HTML><HEAD></HEAD><BODY><P>HI ALL,</P><P></P><P>Native SQL checks for synatx errors in requests recieved and passes the request to database through gateway service. </P><P>depending on the DB,performance varies.</P><P></P><P>Regards,</P><P>Namitha.</P></BODY></HTML> Fri, 03 Feb 2012 04:43:51 GMT https://community.sap.com/t5/application-development-and-automation-discussions/open-cursor-with-hold-in-native-sql/m-p/8507550#M1654614 Former Member 2012-02-03T04:43:51Z