Well for a start that LIKE operand should be in quotes and secondly do not hijack threads - please start your own thread for a new question. Third, please read the posting guidelines and supply more information about your version of jBASE and so on. Fourth, did you check the SQL manual for jBASE, perhaps it does not support the LIKE clause.
Jim From: [email protected] [mailto:[email protected]] On Behalf Of Mujtaba Khan Sent: Wednesday, January 20, 2010 3:07 AM To: [email protected] Subject: Re: SQL Error in Jbase Hi, can any one Help i am also stuck up at jsh ~ -->SQLSELECT * FROM FBNK.CUSTOMER WHERE CUSTOMER.NO LIKE 100300 Error in Statement "SELECT * FROM FBNK.CUSTOMER WHERE CUSTOMER.NO LIKE 100300" Parse Error: unrecognized alias. On Thu, Aug 7, 2008 at 10:24 PM, Daniel Klein <[email protected]> wrote: On Thu, Aug 7, 2008 at 11:59 AM, Sankararam K <[email protected]> wrote: Hi All, I was trying to run this command from jsh SQLSELECT MAX(OVDATA) FROM F.FSMD.OVERDRAFT and was getting Parse error:.. Any Ideas how to get rid of this error. Thanks for the Help Cheers Sankar SQLSELECT offers limited SQL functionality and one of those 'limits' is that it does not support using functions against the data. Dan --~--~---------~--~----~------------~-------~--~----~ 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
