SQL procedure tracing

[Prashant Sogarwal]

Hi

I am trying to debug a stored procedure by using the source code given
by Serge in one of the DW article about SQL procedure tracing
(http://www-128.ibm.com/developerwork...dm-0409rielau/)

I am unable to get rid of these errors while linking the sqlpltrc
program using sqlpltrc.exp file on AIX 5.2, any help is appreciated.

xlc_r $EXTRA_CFLAG -qmkshrobj -o $1 $1.o -ldb2 -ldb2psmd
-L$DB2PATH/$LIB -bE:$1.exp
ld: 0711-319 WARNING: Exported symbol not defined: L
ld: 0711-244 ERROR: No csects or exported symbols have been saved.

Thanks
Prashant

[Serge Rielau]

Prashant Sogarwal wrote:

Hi

I am trying to debug a stored procedure by using the source code given
by Serge in one of the DW article about SQL procedure tracing
(http://www-128.ibm.com/developerwork...dm-0409rielau/)

I am unable to get rid of these errors while linking the sqlpltrc
program using sqlpltrc.exp file on AIX 5.2, any help is appreciated.

xlc_r $EXTRA_CFLAG -qmkshrobj -o $1 $1.o -ldb2 -ldb2psmd
-L$DB2PATH/$LIB -bE:$1.exp
ld: 0711-319 WARNING: Exported symbol not defined: L
ld: 0711-244 ERROR: No csects or exported symbols have been saved.

I'm far from an expert on the compiler, but are you sure
$DB2PATH/$LIB is set?

Cheers
Serge

PS: I thought I provided the binary for AIX (??)

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/

[Prashant Sogarwal]

Hi Serge,

Yes It is set, the error is same if you hard code the $DB2PATH/$LIB.

But Interestingly, I was able to compile by removing -bE:$1.exp, but I
don't know how valid the executable file is after removing the -bE
parameter.

Serge Rielau wrote:

Prashant Sogarwal wrote:

Hi

I am trying to debug a stored procedure by using the source code given
by Serge in one of the DW article about SQL procedure tracing
(http://www-128.ibm.com/developerwork...dm-0409rielau/)

I am unable to get rid of these errors while linking the sqlpltrc
program using sqlpltrc.exp file on AIX 5.2, any help is appreciated.

xlc_r $EXTRA_CFLAG -qmkshrobj -o $1 $1.o -ldb2 -ldb2psmd
-L$DB2PATH/$LIB -bE:$1.exp
ld: 0711-319 WARNING: Exported symbol not defined: L
ld: 0711-244 ERROR: No csects or exported symbols have been saved.

I'm far from an expert on the compiler, but are you sure
$DB2PATH/$LIB is set?

Cheers
Serge

PS: I thought I provided the binary for AIX (??)

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/

[Prashant Sogarwal]

PS: The binaries are there for Windows32-bit and Linux Intel 32-bit

-Prashant
Serge Rielau wrote:

Prashant Sogarwal wrote:

Hi

I am trying to debug a stored procedure by using the source code given
by Serge in one of the DW article about SQL procedure tracing
(http://www-128.ibm.com/developerwork...dm-0409rielau/)

I am unable to get rid of these errors while linking the sqlpltrc
program using sqlpltrc.exp file on AIX 5.2, any help is appreciated.

xlc_r $EXTRA_CFLAG -qmkshrobj -o $1 $1.o -ldb2 -ldb2psmd
-L$DB2PATH/$LIB -bE:$1.exp
ld: 0711-319 WARNING: Exported symbol not defined: L
ld: 0711-244 ERROR: No csects or exported symbols have been saved.

I'm far from an expert on the compiler, but are you sure
$DB2PATH/$LIB is set?

Cheers
Serge

PS: I thought I provided the binary for AIX (??)

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/

[Serge Rielau]

Prashant Sogarwal wrote:

PS: The binaries are there for Windows32-bit and Linux Intel 32-bit

Tsk, tsk... now why did I do that??
Anyway the exp-file exports the symbols so without it I fear you will
get a SQLCODE -444 becaue the entry point is missing.
If you send me an email I should be able to bounce you back the executable.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/