467,118 Members | 985 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,118 developers. It's quick & easy.

Db2 load API options

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
  • viewed: 2283
Share:
1 Reply
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.

Similar topics

4 posts views Thread by RootChaos | last post: by
reply views Thread by mathlec | last post: by
reply views Thread by giovanni gherdovich | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.