Hi,
Santhosh's advice is ok, so please try it :)
01A seems to be interpreted as in MATCHES jBASE operator and system does not treat literal '01A' as constant (string). It looks for 1 alpha (letter) character instead I belive. That is why your selection criteria fails and does not bring expected result.
To avoid such problems you should always use "...'constant'..." value expressions in your SELECT ... LIKE statements.
BTW: T24 core follows this rule when building SELECT expressions.
Kind regards
Pawel
Dnia 14-12-2010 o godz. 18:38 Santhosh C. Nair napisał(a):
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
