RE: LIKE and Regular Expressions AKA regex in SQL

If the scheduler is not running you will have to install the REGEX blade manually using the API function for installing datablades. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. ------Original Message------ Art cautioned: > Calling the REGEX_MATCH() function will cause the engine to auto-install the regex datablade that supplies the function. I wonder who will notice that? I added it to my FragmentList.pm Perl module (not yet on iiug, I think) but afterward got my hands on the latest Extensions guide (2016, thanks, Andreas) and there are SO MANY caveats on its use that I thought I would have to revert to the clumsier "^sbstest%" construct. Or add so much intelligence to the module that it can tell is the regex blade is usable and then decide what clause to include in the SQL. Fortunately I read a bit closer. Server requirement: The Scheduler must be running. (When is it not running? Question for another thread.) I'm playing with simple strings so the issue of CLOB and and SBspace is irrelevant for me. Database requirements: Database MUST be logged. (Most are..) Since my utility feeds off sysmaster, this is not a problem. Database MUST NOT be ANSI. Same lucky break in my case. I think I've had exactly one client who uses ANSI mode for an Informix database. ------------------------------ Jacob Salomon --- Nobody goes there anymore, it's too crowded. --Attr: Yogi Berra ------------------------------ #Informix