<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic hai2 in Application Development and Automation Discussions</title>
    <link>https://community.sap.com/t5/application-development-and-automation-discussions/hai2/m-p/2363797#M523152</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;1.what is the difference between Open SQL &amp;amp;. Native SQL?&lt;/P&gt;&lt;P&gt;2. What are field symbols? &lt;/P&gt;&lt;P&gt;3.What is the use of  EXTRACT statement &lt;/P&gt;&lt;P&gt;4. Which system fields keep track of each pass in LOOP statement?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Sat, 16 Jun 2007 04:43:16 GMT</pubDate>
    <dc:creator>Former Member</dc:creator>
    <dc:date>2007-06-16T04:43:16Z</dc:date>
    <item>
      <title>hai2</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/hai2/m-p/2363797#M523152</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;1.what is the difference between Open SQL &amp;amp;. Native SQL?&lt;/P&gt;&lt;P&gt;2. What are field symbols? &lt;/P&gt;&lt;P&gt;3.What is the use of  EXTRACT statement &lt;/P&gt;&lt;P&gt;4. Which system fields keep track of each pass in LOOP statement?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Sat, 16 Jun 2007 04:43:16 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/hai2/m-p/2363797#M523152</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2007-06-16T04:43:16Z</dc:date>
    </item>
    <item>
      <title>Re: hai2</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/hai2/m-p/2363798#M523153</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Expert Forums&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Forum Search&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Use the form below to search the forum content. You can choose to search all content or restrict it to certain forums or dates. Also, you can filter the results by a username or user ID.&lt;/P&gt;&lt;P&gt;Search Forum Content&lt;/P&gt;&lt;P&gt;Search Terms: 	  Search Tips&lt;/P&gt;&lt;P&gt;Category or Forum: 	&lt;/P&gt;&lt;P&gt;Date Range: 	&lt;/P&gt;&lt;P&gt;Results Per Page: 	&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Welcome, Clemens Li 	Help&lt;/P&gt;&lt;P&gt;Your Control Panel 	Your Control Panel&lt;/P&gt;&lt;P&gt;Your Reward Points 	Your Reward Points&lt;/P&gt;&lt;P&gt;Your Questions 	Your Questions&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Search Results » Messages: 206 - Search Terms: what is the difference between open sql &amp;amp;. native sql? 	Sort by:&lt;/P&gt;&lt;P&gt;Pages: 7 &lt;A href="https://community.sap.com/Next"&gt; 1 2 3 4 5 6 7 &lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;   1. Differences between open SQL and native SQL&lt;/P&gt;&lt;P&gt;      Posted on: Apr 30, 2007 4:47 AM, by user: qiuguo wu -- Relevance: 79% -- Show all results within this thread&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;      Hi, can anyone tell me the differences between open SQL and native SQL? thanks in advance. qiuguo ...&lt;/P&gt;&lt;P&gt;   2. what is meant by open sql and netive sql?&lt;/P&gt;&lt;P&gt;      Posted on: May 18, 2007 2:17 PM, by user: ASHOK KUMAR -- Relevance: 42% -- Show all results within this thread&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;      HAI, what is meant by open sql and netive sql? THANK YOU ASHOK KUMAR&lt;/P&gt;&lt;P&gt;   3. Re: Who to use Native SQL statements in ABAP&lt;/P&gt;&lt;P&gt;      Posted on: May 14, 2007 11:44 AM, by user: Rusidar Subramani -- Relevance: 33% -- Show all results within this thread&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;      Hi Suresh, We can use native Sql, when there is no option of getting through open SQL. This is used by the programmer by the Guidance of the Technical ...&lt;/P&gt;&lt;P&gt;   4. reg: open sql&lt;/P&gt;&lt;P&gt;      Posted on: May 9, 2007 5:13 PM, by user: selva c -- Relevance: 27% -- Show all results within this thread&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;      hai friends.. in open sql.. what is the purpose of open cursor, fetch, close cursor, commit work, rollback work ? explain with eg ...&lt;/P&gt;&lt;P&gt;   5. what is the difference between conversion and interface?&lt;/P&gt;&lt;P&gt;      Posted on: Apr 4, 2007 5:56 AM, by user: sunil kumar -- Relevance: 27% -- Show all results within this thread&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;      what is the difference between conversion and interface?&lt;/P&gt;&lt;P&gt;   6. what is the difference between conversion and interface?&lt;/P&gt;&lt;P&gt;      Posted on: Apr 4, 2007 2:57 PM, by user: phani -- Relevance: 27% -- Show all results within this thread&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;      what is the difference between conversion and interface?&lt;/P&gt;&lt;P&gt;   7. what is the difference between insitialisation and default&lt;/P&gt;&lt;P&gt;      Posted on: Jun 6, 2007 7:16 AM, by user: biswa panda -- Relevance: 25% -- Show all results within this thread&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;      hi all what is the difference between insitialisation and default&lt;/P&gt;&lt;P&gt;   8. Regarding Native SQL to access Oracle Data from SAP&lt;/P&gt;&lt;P&gt;      Posted on: Apr 17, 2007 11:00 AM, by user: Neeraj K -- Relevance: 25% -- Show all results within this thread&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;      Dear Gurus, This query is regarding Native SQL. Our database is Oracle and the client's database is also Oracle. ...&lt;/P&gt;&lt;P&gt;   9. what is difference between DEFAULT and INITIALIZATION&lt;/P&gt;&lt;P&gt;      Posted on: Apr 13, 2007 10:19 PM, by user: sudhakara reddy -- Relevance: 24% -- Show all results within this thread&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;      what is difference between DEFAULT and INITIALIZATION? give simple example&lt;/P&gt;&lt;P&gt;  10. difference between se30 and st05&lt;/P&gt;&lt;P&gt;      Posted on: May 31, 2007 9:09 PM, by user: samanvi -- Relevance: 24% -- Show all results within this thread&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;      hi experts, what is the difference between runtime analysis and sql trace. Thanks, Samanvi.&lt;/P&gt;&lt;P&gt;  11. What is the difference between external subroutine and inclue?&lt;/P&gt;&lt;P&gt;      Posted on: May 18, 2007 1:08 PM, by user: ajay singh -- Relevance: 23% -- Show all results within this thread&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;      What is the difference between external subroutine and inclue?&lt;/P&gt;&lt;P&gt;  12. what is the difference between user exit and badi&lt;/P&gt;&lt;P&gt;      Posted on: Apr 24, 2007 12:51 PM, by user: jamshad ali -- Relevance: 23% -- Show all results within this thread&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;      what is the difference between user exit and badi&lt;/P&gt;&lt;P&gt;  13. what is the difference between User exit and customer exit&lt;/P&gt;&lt;P&gt;      Posted on: Mar 31, 2007 6:29 PM, by user: Ajay Kumar -- Relevance: 23% -- Show all results within this thread&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;      what is the difference between User exit and customer exit&lt;/P&gt;&lt;P&gt;  14. what r the technical difference between LSMW and BDC?&lt;/P&gt;&lt;P&gt;      Posted on: Apr 4, 2007 6:03 AM, by user: sunil kumar -- Relevance: 23% -- Show all results within this thread&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;      what r the technical difference between LSMW and BDC?&lt;/P&gt;&lt;P&gt;  15. What is difference between enjoy transactions and Normal transactions&lt;/P&gt;&lt;P&gt;      Posted on: Apr 20, 2007 11:58 AM, by user: ilam ilam -- Relevance: 23% -- Show all results within this thread&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;      What is difference between enjoy transactions and Normal transactions Ex:- ME22 &amp;amp; ME22N What is ...&lt;/P&gt;&lt;P&gt;  16. What is the difference between UPLOAD and WS_UPLOAD?&lt;/P&gt;&lt;P&gt;      Posted on: Apr 25, 2007 1:12 PM, by user: Guest -- Relevance: 22% -- Show all results within this thread&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;      Hi, What is the difference between UPLOAD and WS_UPLOAD? Best Regards, Gopal&lt;/P&gt;&lt;P&gt;  17. what is the difference between ws_upload and gui_upload&lt;/P&gt;&lt;P&gt;      Posted on: Apr 10, 2007 7:13 AM, by user: kumar jami -- Relevance: 22% -- Show all results within this thread&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;      what is the difference between ws_upload and gui_upload what is the difference between ws_download ...&lt;/P&gt;&lt;P&gt;  18. Dynamic Open SQL Question&lt;/P&gt;&lt;P&gt;      Posted on: Apr 4, 2007 12:26 PM, by user: James Xie -- Relevance: 21% -- Show all results within this thread&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;      tips in this forum and some example given fetches the whole line from the database. Obviously this is what I intend to avoid. Could anyone show me the rope on how to write such a dynamic sql statement? ...&lt;/P&gt;&lt;P&gt;  19. Re: Open Sql Insert&lt;/P&gt;&lt;P&gt;      Posted on: Jun 7, 2007 8:51 AM, by user: Sudheer Junnuthula -- Relevance: 21% -- Show all results within this thread&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;      Hi, The Open SQL statement for inserting data into a database table is: &lt;B&gt;&lt;/B&gt;&lt;/P&gt;&lt;P&gt;INSERT INTO .&lt;/P&gt; It allows you to insert one or more lines into the database table ...&lt;P&gt;&lt;/P&gt;&lt;P&gt;  20. Parameters in Open SQL&lt;/P&gt;&lt;P&gt;      Posted on: May 22, 2007 6:27 PM, by user: Óscar Alconchel -- Relevance: 20% -- Show all results within this thread&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;      Hi, I have defined a parameter: PARAMETERS: p_param1 LIKE table-cod_param1 I need to use this parameter in a SQL Sentence and this parameter isn´t obligatory. How I can build de sentence ?? ...&lt;/P&gt;&lt;P&gt;  21. What are difference between domain and data element?&lt;/P&gt;&lt;P&gt;      Posted on: Apr 25, 2007 12:46 PM, by user: Guest -- Relevance: 20% -- Show all results within this thread&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;      Hi, Difference between domain and data element? What are aggregate object? Regards, Kishore&lt;/P&gt;&lt;P&gt;  22. What is the difference between Subcontracting PO and External refurbishment&lt;/P&gt;&lt;P&gt;      Posted on: May 2, 2007 7:54 PM, by user: Shrikant Saitawdekar -- Relevance: 20% -- Show all results within this thread&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;      What is the difference between Subcontracting PO and External refurbishment? How it affects valuation ...&lt;/P&gt;&lt;P&gt;  23. Difference Between EQ &amp;amp; IN&lt;/P&gt;&lt;P&gt;      Posted on: May 2, 2007 6:06 AM, by user: narayana murthy -- Relevance: 20% -- Show all results within this thread&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;      Hi Frnds , Iam having one doubt in Sql Querys i.e. Wat is the difference between EQ &amp;amp; IN When validating with sql Querys ... Regs , Narayana Murthy ...&lt;/P&gt;&lt;P&gt;  24. what is the difference between DME and smartforms?&lt;/P&gt;&lt;P&gt;      Posted on: May 11, 2007 10:55 AM, by user: kumar kumar -- Relevance: 20% -- Show all results within this thread&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;      gives option to generate DME files. Why could SAP not have provided smartforms for all three countires? What is the difference between DME and smartform?Can you have pictures and logos in a DME file? Message ...&lt;/P&gt;&lt;P&gt;  25. what is difference between 4.7c BW and R/3 s/w&lt;/P&gt;&lt;P&gt;      Posted on: Jun 12, 2007 9:29 AM, by user: Jagrut BaharatKumar Shukla -- Relevance: 19% -- Show all results within this thread&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;      what is difference between 4.7c BW and R/3 s/w&lt;/P&gt;&lt;P&gt;  26. what is Difference between batch input method &amp;amp; session method&lt;/P&gt;&lt;P&gt;      Posted on: May 7, 2007 8:15 AM, by user: praveen kumar -- Relevance: 19% -- Show all results within this thread&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;      what is Difference between batch input method &amp;amp; session method. Advance thanx&lt;/P&gt;&lt;P&gt;  27. what is difference between sy-index and sy-tabix and where both are using ?&lt;/P&gt;&lt;P&gt;      Posted on: Apr 2, 2007 2:39 PM, by user: nagaraju tedlapu -- Relevance: 19% -- Show all results within this thread&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;      what is difference between sy-index and sy-tabix and where both are using ?&lt;/P&gt;&lt;P&gt;  28. difference between sapscripts and BDCs&lt;/P&gt;&lt;P&gt;      Posted on: Apr 24, 2007 1:55 PM, by user: r k reddy -- Relevance: 19% -- Show all results within this thread&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;      what is the difference between sapscripts and BDCs&lt;/P&gt;&lt;P&gt;  29. How to implement the concat functionality in open sql&lt;/P&gt;&lt;P&gt;      Posted on: Jun 13, 2007 9:21 AM, by user: Ray Lei -- Relevance: 19% -- Show all results within this thread&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;      eg, I want to get sys_id,sys_client combined into a string from a table, how can I write the open sql just like the functionality of 'concat(sys_id,sys_client)' in mysql sql,thanks. ...&lt;/P&gt;&lt;P&gt;  30. Open Sql! Update &amp;amp; Modify!&lt;/P&gt;&lt;P&gt;      Posted on: Jun 7, 2007 9:02 AM, by user: Rahul -- Relevance: 19% -- Show all results within this thread&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;      database from internal table. Can i use Modify i hope it ll modify changes &amp;amp; insert record what about Update command have effect in the above issue Pls tell me guys what will happen when we ...&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Pages: 7 &lt;A href="https://community.sap.com/Next"&gt; 1 2 3 4 5 6 7 &lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Sat, 16 Jun 2007 20:32:13 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/hai2/m-p/2363798#M523153</guid>
      <dc:creator>Clemenss</dc:creator>
      <dc:date>2007-06-16T20:32:13Z</dc:date>
    </item>
  </channel>
</rss>

