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
