Db2 load API options

[Tom Cartmel]

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

[Tom Cartmel]

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?