Archive for the ‘DB2’ Category
Table Conversion from Oracle to DB2
Posted by: Chyne on: August 5, 2008
- In: DB2| Oracle
- Leave a Comment
Oracle
Connect the Oracle database through Toad (Download from: http://www.toadsoft.com/, Toad for Oracle)
Save the result (data retrieval) based from the SQL statement in Fixed Field Spacing (Untick column headers, Tick ‘Include NULL text’)
• Save the result with the filename: testing.txt
DB2
Create a database
• Create a table
• Create the fields with the same attributes as the table in Oracle
Right click the [...]
DB2 Basic Commands
Posted by: Chyne on: July 30, 2008
- In: DB2
- Leave a Comment
Open command line
> db2cmd
Catalog the DB2 server node
> db2 catalog tcpip node [NODE_NAME] remote [HOST_NAME] server [PORT] remote_instance [db2inst1]
List the database
> db2 list database directory
List the command
> db2 ?
Procedures of Creating Database
Create a database
> db2 create database dbusr
Access to the location of the database
Connect to the new database
> connect to dbusr
Import the tables
> db2move [DATABASENAME] [...]
Search
- The BASEDIR environment variable is not defined correctly. This environment variable is needed to run this program
- The Reason behind Oracle 11g: SEVERE: Error while registering Oracle JDBC Diagnosability MBean
- How to Reset Postgres Forgotten Password?
- Installation of Subversion 1.6.5 on Ubuntu 8.10
- Why Windows Subsystem Process Terminated Unexpectedly?
- Chapter 7: Arrays (Exercise 7.13)
- Installation of Bugzilla in Ubuntu Environment
- Too many open files
- Chapter 7: Arrays (Exercise 7.12)
- Cannot convert value '0000-00-00 00:00:00' from column XX to TIMESTAMP
- blackhawk: Nice tip -- thanks for sharing
- steven: -hlocalhost can be omitted for localhost
- Tony Locke: Thanks, it worked!
RSS - Posts