1. Oracle rownum in db2 - Java data archiving stackoverflow.comI have a data archiving process in java that moves data between db2 and sybase. FYI - This is not done through any import/export process because there are several conditions on ... |
2. IBM data movement tool. oracle JDBC connection problem stackoverflow.comto give a bit more background about my problem. I am using DB2 9.7 and Oracle Express 10g. In the IBM data movement tool I connected to DB2 sucessfully. But I ... |
3. Transfer db2 data to SAP's oracle database coderanch.com |
4. Want to do data transfer from DB2 on OS390 to Oracle database on solaris coderanch.comHi, I have to do some data transfer from DB2 on OS390 to Oracle database on Sun Solaris.This is a more of a batch process where at some time this process will be triggered and data transfer will take place. I have a doubt here like which stratergy to follow for this like I perceive two options for this : 1. ... |
5. Oracle or DB2 coderanch.comHello there, I'm trying to practice with a relational database (DBMS). Designing databases and writing Java programs that depends on this database. I have some background in this with Access and SQL Server, but i prefer to use/learn with another one. I am seeing that i have one of two choices, IBM DB2 or Oracle. If someone can enlighten me of ... |
6. db2 and oracle XA problem coderanch.comIn WebSphere, connecting to different XA datasources (all oracle) is ok. For discussion purposes, let's call it connectionA and connectionB. However, when I mix the connection wherein one datasource is db2 and the other is oracle (connectionA=DB2, connectionB=oracle), I keep on having this error no matter how the connection pool or the RDBMS (oracle) is set: WTRN0078E: An attempt by the ... |
7. Copy whole table from DB2 to Oracle coderanch.comYes data conversion is another area which need to be addressed, In SQL loader we can also convert the Data in desired format before inserting into table, also in term of performance I have very good experience with SQL loaders. I used to insert approx 2 million records in oracle within 5 minutes. Thanks, Shailesh |
8. store Procedure of Oracle, Mysql, DB2, etc?? coderanch.com |
9. DB2 Oracle incompatibility coderanch.comOur application supports 3 types of databases- oracle, db2 and sql. I have an sql statement that was written keeping oracle as the main database- SELECT '' AS rcrd_dt .... Idea was to select blank in the rcrd_dt (column is of type Date) column since it was not required to be displayed on the page (cannot remove it from the query ... |
10. Moving from Oracle to DB2 coderanch.comHibernate supports DB2 so that aspect should be OK without any changes (though you don't say which version of DB2 - DB2 390 is a very different beast). The only issue is your direct SQL. Typically, direct SQL is used in circumstances where the logic is too specialized to use Criteria or HQL so its probably going to be an issue. ... |
11. Connection to DB2 as400 from ORACLE dbforums.comHI!! I have an application developed in Oracle 8.1.5 and now I need to access data in AS400 I have a JDBCdriver to connect AS400 from Java but when I try lo load in Oracle some of the classes after loaded are in status INVALID This because there are some classes that are expected in JAVA.LANG.* and there aren't I think ... |