View Single Post

   
  #3 (permalink)  
Old 02-27-2008, 07:38 AM
Prashant Sogarwal
 
Posts: n/a
Default Re: SQL procedure tracing

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/


Reply With Quote