I found no issues running the statement as you have entered it.
Where are you processing this cursor?
If you are executing the statement in an SQLRPGLE program you can look at the SQLERRD array.
SQLERRD(5) Contains the position or column of a syntax error.
Chris Hiebert
Senior Programmer/Analyst
Disclaimer: Any views or opinions presented are solely those of the author and do not necessarily represent those of the company.
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jose Perez
Sent: Tuesday, February 7, 2017 11:53 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Using regular expression in SQL give error SQLCODE=171 and SQLSTATE=42815
Anyone using regular expression in sql has faced this issue?, I'm trying to catch a string pattern inside a string, the string pattern should be like this (it contain 2 dashes and the pattern ###-#######-#) or it contain the pattern I##### or IMP##### using the below sql
Declare C0 Cursor for
Select
IFNULL(REGEXP_SUBSTR(PLDESCB,'I[0-9]{5}'),'N'),
IFNULL(REGEXP_SUBSTR(PLDESCB,'IMP[0-9]{5}'),'N'),
IFNULL(REGEXP_SUBSTR(PLDESCB,'[0-9]{3}-[0-9]{7}-[0-9]{1,}'),'N')
From SESSION.T1
Where
(REGEXP_MATCH_COUNT(PLDESCB,'-')=2 And
REGEXP_like(PLDESCB,'[0-9]{3}-[0-9]{7}-[0-9]{1}[^0-9]')) or
REGEXP_LIKE(PLDESCB,'I[0-9]{5}') OR
REGEXP_LIKE(PLDESCB,'IMP[0-9]{5}')
but when opening the cursor I'm getting error SQLCODE=171 and SQLSTATE=42815 What Am I doing wrong? if anyone could point me to the right direction I will appreciate it.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
As an Amazon Associate we earn from qualifying purchases.