SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 07:37 AM
| ||||
| ||||
 SQL procedure tracing 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      |
|
02-27-2008, 07:37 AM
| |||
| |||
| Re: SQL procedure tracing 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/ |
|
02-27-2008, 07:38 AM
| |||
| |||
| 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/ |
|
02-27-2008, 07:38 AM
| |||
| |||
| Re: SQL procedure tracing 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/ |
|
02-27-2008, 07:38 AM
| ||||
| ||||
| Re: SQL procedure tracing 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/ |
 |
« Could I use a host variable for replacing the table name in SQC program?
|
Tablespace - mysteriously lost pages. »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 03:04 AM.
