topic Re: Dynamic native SQL constructs in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/dynamic-native-sql-constructs/m-p/5520783#M1261853 <HTML><HEAD></HEAD><BODY><P>Check the program, <STRONG>ADBC_DEMO</STRONG> in SE38. It will help you create dynamic native SQL queries.</P></BODY></HTML> Thu, 16 Apr 2009 10:47:30 GMT Former Member 2009-04-16T10:47:30Z Dynamic native SQL constructs https://community.sap.com/t5/application-development-and-automation-discussions/dynamic-native-sql-constructs/m-p/5520781#M1261851 <HTML><HEAD></HEAD><BODY><P>Hi Gurus,</P><P></P><P>I want to generate dynamic native sql constructs. Following is the code i am using but it genrates exception of invalid SQL statement </P><P></P><P>EXEC SQL.</P><P>OPEN c1 FOR</P><P>SELECT (l_t_code) FROM (s_tabnm) WHERE (l_t_codewhere)</P><P> ENDEXEC.</P><P></P><P>Please brief me how to create dynamic native SQL constructs .</P><P></P><P>Thanks </P><P>Sonal....</P></BODY></HTML> Thu, 16 Apr 2009 08:54:27 GMT https://community.sap.com/t5/application-development-and-automation-discussions/dynamic-native-sql-constructs/m-p/5520781#M1261851 Former Member 2009-04-16T08:54:27Z Re: Dynamic native SQL constructs https://community.sap.com/t5/application-development-and-automation-discussions/dynamic-native-sql-constructs/m-p/5520782#M1261852 <HTML><HEAD></HEAD><BODY><P>The native SQL depends on the database.</P><P></P><P>Look up a help.sap.com</P></BODY></HTML> Thu, 16 Apr 2009 09:33:48 GMT https://community.sap.com/t5/application-development-and-automation-discussions/dynamic-native-sql-constructs/m-p/5520782#M1261852 Former Member 2009-04-16T09:33:48Z Re: Dynamic native SQL constructs https://community.sap.com/t5/application-development-and-automation-discussions/dynamic-native-sql-constructs/m-p/5520783#M1261853 <HTML><HEAD></HEAD><BODY><P>Check the program, <STRONG>ADBC_DEMO</STRONG> in SE38. It will help you create dynamic native SQL queries.</P></BODY></HTML> Thu, 16 Apr 2009 10:47:30 GMT https://community.sap.com/t5/application-development-and-automation-discussions/dynamic-native-sql-constructs/m-p/5520783#M1261853 Former Member 2009-04-16T10:47:30Z Re: Dynamic native SQL constructs https://community.sap.com/t5/application-development-and-automation-discussions/dynamic-native-sql-constructs/m-p/5520784#M1261854 <HTML><HEAD></HEAD><BODY><P>Thanks!!! The Demo is great...</P></BODY></HTML> Wed, 19 Aug 2009 09:43:40 GMT https://community.sap.com/t5/application-development-and-automation-discussions/dynamic-native-sql-constructs/m-p/5520784#M1261854 fabian_otto 2009-08-19T09:43:40Z