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

STRIP: Expected tokens may include: "<strip_spec>"

P: n/a
Hello,
(Using DB2/LINUX 8.2.0)

After compiling the STRIP migration UDF (found at
http://www-106.ibm.com/developerwork...db2/0205udfs/),
if I try to execute:

values char(STRIP('0000345.50','L','0'),20)
@

....I get the following error:

SQL0104N An unexpected token "'L'" was found following
"(STRIP('0000345.50',". Expected tokens may include: "<strip_spec>".
SQLSTATE=42601

What's "<strip_spec>" ???

Thanks!

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Gustavo Randich wrote:
Hello,
(Using DB2/LINUX 8.2.0)

After compiling the STRIP migration UDF (found at
http://www-106.ibm.com/developerwork...db2/0205udfs/),
if I try to execute:

values char(STRIP('0000345.50','L','0'),20)
@

...I get the following error:

SQL0104N An unexpected token "'L'" was found following
"(STRIP('0000345.50',". Expected tokens may include: "<strip_spec>".
SQLSTATE=42601

What's "<strip_spec>" ???

Thanks!

Hah! This is funny. You ran into some internal code that's not enabled
yet. But because STRIP in the SQL Standard has all these ugly keywords
the grammar can't hide it.
Anyway, to make a long story short, rename your STRIP function or
qualify it with the schema name.

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #2

P: n/a
Funny, it works. Thanks.

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.