Current Position:Home > Differences between DB2 and Oralce

Differences between DB2 and Oralce

Update:11-30Source: network consolidation
Advertisement
hello gurus,
i am an abaper working on oracle database..
i have got a requirement (abaper)wherein they need a person who has DB2 experience...
can anyone elucidate the main diffenreces of having SAP on oracle and DB2?(in ABAP programmer context)
thanks in advance.

The Best Answer

Advertisement
Usually ABAP is agnostic of the underlying operating system and database. However, there are cases, where you use OS or DB specific commands.
If your ABAPs contain OpenSQL, they are database dependent.
SAP uses usually standard SQL commands (remember: ABAP is NOT SQL) as database language.
Markus
  • Differences between DB2 and Oralce Update:11-30

    hello gurus, i am an abaper working on oracle database.. i have got a requirement (abaper)wherein they need a person who has DB2 experience... can anyone elucidate the main diffenreces of having SAP on oracle and DB2?(in ABAP programmer context) than

  • JDBC receiver adapter for AS/400 DB2 Update:10-11

    Hi guys, We have developed an Idoc to JDBC scenario for inserting data in a Z-table of SAP R/3 that sits on an AS/400 DB2. When testing it, message Mapping is executed successfully, but in communication channel monitoring, we get the following error

  • Query on AS400/DB2 Update:11-30

    Hello, I am using kodo2.5.0 with the DB2 for OS/400 JDBC Driver. The following simple code return empty result. Transaction tran = pm.currentTransaction(); tran.begin(); Query qry = pm.newQuery(Customer.class, "name == \"Mark\""); Coll

  • IBM DB2 Migration Update:11-30

    Does anyone here have experience with IBM DB2 Migration to Oracle? If so, what information can you tell me? I've read the IBM DB2 Migration Guide, but reading real success stories here would be great. My company is exploring a couple of home-grown so

  • XQuery and Oracle XE ... Update:11-30

    Hi all, One of the major differences between "DB2 Express-C" and "Oracle XE" seems to be, support for XML and XQuery in particular. If I read this right "Oracle XE" is a purely "relational database" whereas "DB

  • Date difference between Java and db2 Update:11-30

    Hello, I am quite puzzled. I have the following environment: -iseries DB2 -Jdk 1.5 -Hibernate 3 (jpa) -Tomcat 5.5 When I have "31st December 2006" in the database, the webapp displays "30th December 2006" and so on. I don't understand

  • Oralce Vs. DB2 Features Update:11-30

    I need to present the advantages for Selecting Oralce against DB2 for my Customer. Could any one please give the comparative features of Oralce Vs DB2 ? Thanks and Regards Subbaraju nullI'm not clear which features you mean? QTVR does allow hot-spots

  • DB2 fixpack's difference Update:11-30

    Hi, All What is the difference between general IBM DB2 Fixpack's and special fixpack's for SAP , e.g. DB2 9 FP2 and DB2 9 FP2SAP ? And why SAP is strongly recommend to use special FPxSAP instead of general IBM DB2 fixes ? With best regards, DmitryHi,

  • DB2 UDB - Oracle 10g Size Difference Update:11-30

    Hi - We are looking to migrate a production database from DB2 UDB to Oracle 10g. Can anyone provide any insight as to what kind of size changes we can expect? Thanks!I don't know even the a b c of DB2 but still I can say that it must be saving some s

  • Difference between implicit cursor and explicit cursor. Update:10-11

    hi all, i have used explicit cursor, i know the way of using implicit cursor, but i don't what the difference between both. Is they both are different. if yes y? which cursor is most reliable to use. please tell me.. Thanks..OK, 1- An IMPLICIT cursor