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

How to check Application Client installed or not in Solaris?

P: n/a
Hi All,

I'm new to DB2, I have installed DB2 UDB V8 on Solaris machine. And i
tried to create a stored proc.But, gives the following error..

-- LOG FILE P2093405.log FOR PROCEDURE DB2INST1.PROC1

-- DB2_SQLROUTINE_PREPOPTS=

-- PREP/BIND MESSAGES FOR
/export/home/db2inst1/sqllib/function/routine/sqlproc/SAMPLE/DB2INST1/tm
p/P2093405.sqc

LINE MESSAGES FOR P2093405.sqc
------ --------------------------------------------------------------------
SQL0060W The "C" precompiler is in progress.
SQL0091W Precompilation or binding was ended with "0"
errors and "0" warnings.

-- DB2_SQLROUTINE_COMPILER_PATH=/export/home/db2inst1/sqllib/function/routine/sr_cpath

-- DB2_SQLROUTINE_COMPILE_COMMAND=gcc
-I/export/home/db2inst1/sqllib/include SQLROUTINE_FILENAME.c
-shared -o SQLROUTINE_FILENAME -L/export/home/db2inst1/sqllib/lib
-ldb2

-- CONTENTS OF /export/home/db2inst1/sqllib/function/routine/sr_cpath

#!/bin/sh
PATH=$PATH:/opt/SUNWspro/bin:/usr/local/bin
export PATH

db2set DB2_SQLROUTINE_COMPILE_COMMAND="gcc
-I/export/home/db2inst1/sqllib/include SQLROUTINE_FILEN
AME.c -shared -o SQLROUTINE_FILENAME
-L/export/home/db2inst1/sqllib/lib -ldb2"
-- CONTENTS OF /export/home/db2inst1/sqllib/function/routine/sqlproc/SAMPLE/DB2INST1/tmp/P2093405.
sh

SQLROUTINE_FILENAME=P2093405
export SQLROUTINE_FILENAME

-- COMPILATION COMMAND:

gcc -I/export/home/db2inst1/sqllib/include P2093405.c -shared -o
P2093405 -L/export/home/db2inst
1/sqllib/lib -ldb2

-- CONTENTS OF /export/home/db2inst1/sqllib/function/routine/sqlproc/SAMPLE/DB2INST1/tmp/P2093405.
exp

pgsjmp
-- COMPILATION MESSAGES FOR
/export/home/db2inst1/sqllib/function/routine/sqlproc/SAMPLE/DB2INST1/
tmp/P2093405.c
DB2SET processing complete, rc = -4400, SQLCODE = 0
P2093405.c:14:21: sqladef.h: No such file or directory
P2093405.c:16: error: variable `sqla_rtinfo' has initializer but
incomplete type
P2093405.c:17: error: extra brace group at end of initializer
P2093405.c:17: error: (near initialization for `sqla_rtinfo')
P2093405.c:17: warning: excess elements in struct initializer
P2093405.c:17: warning: (near initialization for `sqla_rtinfo')
P2093405.c:17: error: `wchar_t' undeclared here (not in a function)
P2093405.c:17: warning: excess elements in struct initializer
P2093405.c:17: warning: (near initialization for `sqla_rtinfo')
P2093405.c:17: warning: excess elements in struct initializer
P2093405.c:17: warning: (near initialization for `sqla_rtinfo')
P2093405.c:17: error: extra brace group at end of initializer

When i searched in the forums, Someone told to check whether the
Application Development Client is installed or not. I have only one .h
file in my /export/home/db2inst1/sqllib/include directory. can anyone
please tell how to check whether it is installed or not in solaris
machine?

Thanks in advance,
Praveen
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Praveen wrote:
Hi All,

I'm new to DB2, I have installed DB2 UDB V8 on Solaris machine. And i
tried to create a stored proc.But, gives the following error..
[snip]
When i searched in the forums, Someone told to check whether the
Application Development Client is installed or not. I have only one .h
file in my /export/home/db2inst1/sqllib/include directory. can anyone
please tell how to check whether it is installed or not in solaris
machine?


In DB2 v8, you no longer need the Application Development client
installed to the get the Application Development tools. You can bring
up db2setup again and select a custom install, and select the
Application Development Tools. You may need to reinstall your fixpak
after this, if you've installed any fixpak.

Hope this helps,

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.