bcp using SQL Server2000

/* create a batch file export4backup.bat 內容如下 */

d:
isql -U sa -P sa -d ysbknewbak -i exp4bk.sql -o exp4bk.bat -n -h-1 -w500 -b -s
call exp4bk.bat
exit


/* exp4bk.sql 使用 isql執行,exp4bk.sql內容如下*/

SET NOCOUNT ON
SELECT 'd:'
SELECT 'BCP ' + DBNAME + '.dbo.' + TABLENAME + ' OUT ' +
'd:\' + RTRIM(TABLENAME) + '.bcp -c -U intech -P intech -S ' +
RTRIM(SERVERNAME)
FROM N_BACKUP_TABLE
WHERE STATUS = 'Y'
SET NOCOUNT OFF


Data movement from SQL Server to DB2


c:\>BCP Northwind.dbo.D_N_USER OUT D_N_USER.bcp -c -t, -q -U sa -P exim999 -S IBM-63AB93AA2BF


/*using DB2 CLP*/

connect to db2

C:\>db2 load client from D_N_USER.bcp of del modified by nochardel keepblanks insert into D_N_USER