Data Pump to DB2

#1

Hi all,

I am trying to move data from Excel to a DB2 database. My
DB2 connection is a UDL on top of ODBC. I have Create
priveleges on DB2. What syntax do I need to use to push
the data across? I.e. Schema.DB.

#2

I don't work with DB2 but to insert data into a DB2 table I would have
though you need the equivalent of INSERT permissions

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Mark Frank" <mark.a.frank (AT) wellsfargo (DOT) com> wrote

Quote:

Hi all,

I am trying to move data from Excel to a DB2 database. My
DB2 connection is a UDL on top of ODBC. I have Create
priveleges on DB2. What syntax do I need to use to push
the data across? I.e. Schema.DB.

#3

Putting data into DB2 or Oracle using DTS will be very slow anyway
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Quote:

I don't work with DB2 but to insert data into a DB2 table I would have
though you need the equivalent of INSERT permissions

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Mark Frank" <mark.a.frank (AT) wellsfargo (DOT) com> wrote in message
news:07b601c38eb4$d723a200$a301280a (AT) phx (DOT) gbl...
Hi all,

I am trying to move data from Excel to a DB2 database. My
DB2 connection is a UDL on top of ODBC. I have Create
priveleges on DB2. What syntax do I need to use to push
the data across? I.e. Schema.DB.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Data Pump to DB2

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Data Pump to DB2 - 10-09-2003 , 05:29 PM

Re: Data Pump to DB2 - 10-10-2003 , 12:22 AM

Re: Data Pump to DB2 - 10-12-2003 , 10:23 PM