For accessing the MS SQL Server database Sqoop requires an additional JDBC driver which can be downloaded from Microsoft. The following steps will install MSSQL Server JDBC driver to Sqoop:
wget 'http://download.microsoft.com/download/0/2/A/02AAE597-3865-456C-AE7F-613F99F850A8/sqljdbc_4.0.2206.100_...
Transaction using JDBC driver is used to control how and when a transaction should commit and rollback. Connection to MySQL server is created using JDBC driver
JDBC driver for MySQL can be downloaded here
Lets start with getting a connection to database using JDBC driver
Class.forName("com.m...
db2 connect to {databaseName}
db2 drop table {schema}.{table}
db2 connect reset
The schema is not necessary if it matches the current user name.
The "db2" prefix is not necessary if you are already in a DB2 command prompt.