Tagged Questions
1
vote
3answers
50 views
Transfer data from DB2 to Oracle
I want to transfer data from an old DB2 system to a new Oracle database.
How should I go about doing this?
4
votes
2answers
2k views
SQL Server Express vs. Oracle Express Edition vs DB2 Express-C
I have been trying to compare the features of the SQL Server Express, Oracle XE and DB2 Express-C, but find it difficult to compile all the differences into one place. Especially the current ...
1
vote
4answers
371 views
Backup and restore of RDBMS(Oracle, DB2, SQL Server) from Perl
What could be the best approach ?
Till now could figure out the following (Oracle)
Calling exp.exe and imp.exe utilities in Oracle client using Java and inturn call it from Perl.
Calling exp.exe ...
2
votes
1answer
292 views
Does DB2 have equivalents for Oracle's UTL_ENCODE and UTL_RAW modules?
I'm looking for something similar to:
utl_smtp.command(conn, utl_encode.base64_encode(utl_raw.cast_to_raw(<username>)));
I couldn't find any reference among the DB2's system-defined modules ...
0
votes
1answer
232 views
Preloading a Java library in DB2, similar to ORACLE's loadjava
Edit to add details to clarify, based on Chris' comment:
A Java stored procedure depends on external libraries. Locally it compiles successfully, since they are added to the classpath. But when ...
-1
votes
1answer
263 views
Important distinctions between DBMSs [closed]
DBA is a career I'm strongly considering after school, but my limited experience mostly involves some PL/SQL Oracle web programming, some basic PHP/MySQL web pages, and some queries in SQL Server. ...
10
votes
1answer
205 views
Term for a one-row table?
Is there a specific term to describe a relation with a cardinality of one?
I'm thinking particularly of RDBMS "special" one-row tables, for example, DUAL (Oracle), SYSIBM.SYSDUMMY1 (DB2, Derby) and ...
6
votes
2answers
845 views
Is DB2 more reliable and stable compared to PostgreSQL or MySQL?
Always i was using MySQL or PostgreSQL for my projects such as Web/Desktop apps.
I had data loss few times and thanks to old backup i was always up and running.
But for a recent project for Airport, ...
1
vote
1answer
420 views
What specific tests need to be performed under Database migration from DB2 to Oracle?
Currently I am going to be testing (I am a Data Analyst) of a larger migration project where they are planning to migrate from DB2 to Oracle.
My question may be little broader; however any ...
