try SELECT FBNK.CUSTOMER.POSITION WITH @ID LIKE '..."MIAJL01A"...'
the string used should be with in double quotes which is the correct way for these type of SELECT's On Tue, Dec 14, 2010 at 2:44 PM, JOSE L MARTINEZ-AVIAL <[email protected]>wrote: > Hello all, > We are having some issue with the following select: > SELECT FBNK.CUSTOMER.POSITION WITH @ID LIKE '...MIAJL01A...' > > We do know that there are records that fits that condition, but the > select does not return anyhting. It is curious, because the same select, but > without the 'A' at the end, works > > SELECT FBNK.CUSTOMER.POSITION WITH @ID LIKE '...MIAJL01...' > > In fact, all the records returned by that select have MIAJL01A in the > @ID, so they should be returned also with the first select, but we don't get > anything. Any idea why the first select does not work? > > Thanks > > jsh nasprd ~ -->jdiag > jdiag - jBASE diagnostic '$Revision: 1.15 $' > > System Information > ================== > > System : SunOS Nasux01 5.10.Generic_142900-02 sun4u > OS Release : This is a secured system. Unauthorized access > prohibited. All activity is logged. > UNIX User : nasprd (uid 106, euid 106) > Tty name : /dev/pts/5 > Time : Tue Dec 14 09:40:32 2010 > > Environment > =========== > > JBCPORTNO : Not Set > JBCRELEASEDIR : '/opt/jbase5' > JBCGLOBALDIR : '/opt/jbase5' > JBCDATADIR : '/globusprd/nasprd/bnk/bnk.run/../bnk.data' > HOME : '/globusprd/nasprd/bnk/bnk.run' > JEDIFILEPATH : '/globusprd/nasprd/bnk/bnk.run' > JEDIFILENAME_MD : '/globusprd/nasprd/bnk/bnk.run/VOC' > JEDIFILENAME_SYSTEM : '/opt/jbase5/src/SYSTEM' > SYSTEM File is (DICT) : '/opt/jbase5/src/SYSTEM]D' > RELEASE Information : Major 5.0 , Minor 22 , Patch 0373 (Change > 87455) > Spooler dir (JBCSPOOLERDIR) : '/globusprd/nasprd/bnk/bnk.run/jspooler' > JBCEMULATE : 'prime' > WARNING: Cannot access Library path '/opt/jbase5/jdk/jre/lib', error 2 > Object path (JBCOBJECTLIST) : > '/globusprd/nasprd/bnk/bnk.run/globuspatchlib:/globusprd/nasprd/bnk/bnk.run/lib:/globusprd/nasprd/bnk' > jBASE Compiler Run-time : '/opt/jbase5/config/system.properties' > Program dir (JBCDEV_BIN) : '/globusprd/nasprd/bnk/bnk.run/bin' > Subroutine dir (JBCDEV_LIB) : '/globusprd/nasprd/bnk/bnk.run/lib' > Max open files : 2048 > > -- > Please read the posting guidelines at: > http://groups.google.com/group/jBASE/web/Posting%20Guidelines > > IMPORTANT: Type T24: at the start of the subject line for questions > specific to Globus/T24 > > To post, send email to [email protected] > To unsubscribe, send email to [email protected] > For more options, visit this group at > http://groups.google.com/group/jBASE?hl=en > -- Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
