topic Using Native SQL in ABAP for DB2 database in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/using-native-sql-in-abap-for-db2-database/m-p/2921909#M688123 <HTML><HEAD></HEAD><BODY><P>I have 500K records in ITAB(Internal table) which needs to insert in 'Z' transparent table. Currently it is taking hours of time for insertion and commit. </P><P></P><P>Does using Native SQL helps in performance or any suggestions? If so please send the code. Our database is DB2.</P><P></P><P>Your immediate reply is appreciated. Thanks in advance.</P><P></P><P>-Rama</P></BODY></HTML> Fri, 19 Oct 2007 21:01:17 GMT Former Member 2007-10-19T21:01:17Z Using Native SQL in ABAP for DB2 database https://community.sap.com/t5/application-development-and-automation-discussions/using-native-sql-in-abap-for-db2-database/m-p/2921909#M688123 <HTML><HEAD></HEAD><BODY><P>I have 500K records in ITAB(Internal table) which needs to insert in 'Z' transparent table. Currently it is taking hours of time for insertion and commit. </P><P></P><P>Does using Native SQL helps in performance or any suggestions? If so please send the code. Our database is DB2.</P><P></P><P>Your immediate reply is appreciated. Thanks in advance.</P><P></P><P>-Rama</P></BODY></HTML> Fri, 19 Oct 2007 21:01:17 GMT https://community.sap.com/t5/application-development-and-automation-discussions/using-native-sql-in-abap-for-db2-database/m-p/2921909#M688123 Former Member 2007-10-19T21:01:17Z Re: Using Native SQL in ABAP for DB2 database https://community.sap.com/t5/application-development-and-automation-discussions/using-native-sql-in-abap-for-db2-database/m-p/2921910#M688124 <HTML><HEAD></HEAD><BODY><P>This is a duplicate pst please close - I will answer the other one.</P><P></P><P>Rob</P></BODY></HTML> Fri, 19 Oct 2007 21:02:45 GMT https://community.sap.com/t5/application-development-and-automation-discussions/using-native-sql-in-abap-for-db2-database/m-p/2921910#M688124 Former Member 2007-10-19T21:02:45Z