A QUESTION ABOUT DB2 IN AIX ?

[rufillo]

rufillo (Programmer) Dec 18, 2002
hi :
i have a problem , i have a machine with Aix and db2 and i want to make a program that insert in the bd of db2 but when i compile the program , this send me a message of error, and i don't know that i must do, the messages are :

Undefined :
# make adhoc
cc -O adhoc.c -o adhoc
ld: 0711-317 ERROR: Undefined symbol: .sqlastrt
ld: 0711-317 ERROR: Undefined symbol: .sqlaaloc
ld: 0711-317 ERROR: Undefined symbol: .sqlasetd
ld: 0711-317 ERROR: Undefined symbol: .sqlacall
ld: 0711-317 ERROR: Undefined symbol: .sqlastop
ld: 0711-317 ERROR: Undefined symbol: .SqlInfoPrint
ld: 0711-317 ERROR: Undefined symbol: .TransRollback
ld: 0711-317 ERROR: Undefined symbol: .init_da
ld: 0711-317 ERROR: Undefined symbol: .sqlastls
ld: 0711-317 ERROR: Undefined symbol: .sqlausda
ld: 0711-317 ERROR: Undefined symbol: .alloc_host_vars
ld: 0711-317 ERROR: Undefined symbol: .display_col_titles
ld: 0711-317 ERROR: Undefined symbol: .display_da
ld: 0711-317 ERROR: Undefined symbol: .free_da
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information.
make: 1254-004 The error code from the last command is 8.

i hope your answer .

 

[OHANA]

Heys,
I´ve already had that same problem.

What you should do is the following. Take a look at the "Application Building Guide" and "Application Development Guide" (if you don´t have any of those, download them at the IBM site -

http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v7pubs.d2w/en_main).

I´ll give you a tip that might save you a lot of time, but I still suggest you download those books.

Go to the "$Home/sqllib/samples/c" where $home is the directory where your database is installed.
There you´ll find lots of sample programs in C programing language and also 5 scripts: bldapp, bldevm, bldmt, bldsrv, bldudf

In your case, you have to use the "bldapp". Read it first to prevent errors, and go to a directory where you have the right privileges.
If you want, you can use that shell-script to build your application or you can get the command lines and execute them manually. And be sure that the includes are pointing to the right directory.

Hope this helps.

Fernando