By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,557 Members | 1,067 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,557 IT Pros & Developers. It's quick & easy.

Db2 load API options

P: n/a
The db2load api requires a connection to the database. In the Db2
sample programs, they use embedded SQL to CONNECT to the database
first.

I typically use ODBC (CLI) for client apps and have not used embedded
SQL. I don't know how easy or difficult embedded SQL will be since
I'm using Borland C++ Builder. Are there other ways of CONNECTING to
the database without using embedded SQL if I want to use the db2load
api?

Other options I've explored at doing a load:

1) load can be done through the CLI api. however, the input data
cannot come from an IXF file that was exported. data must be passed
as parameters like an SQL statement

2) spawning a db2cmd process and piping commands/results to/from it
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Using db2set I configured it so that an implicit connection would be
done when I first do a db2load(). However, now it complains about
invalid userid/password which I don't know how to supply implicitly.
Doing an instance attach first with valid userid/password does not
help either.

n9***@arrl.net (Tom Cartmel) wrote in message news:<92**************************@posting.google. com>...
The db2load api requires a connection to the database. In the Db2
sample programs, they use embedded SQL to CONNECT to the database
first.

I typically use ODBC (CLI) for client apps and have not used embedded
SQL. I don't know how easy or difficult embedded SQL will be since
I'm using Borland C++ Builder. Are there other ways of CONNECTING to
the database without using embedded SQL if I want to use the db2load
api?

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.