Underscore does not work. CUSTOMER_NO Error in Statement "SELECT * FROM FBNK.CUSTOMER WHERE CUSTOMER_NO = '100300'" Parse Error: unable to access dict column: CUSTOMER_NO.
--- RELEASE Information : Major 5.0 , Minor 16 , Patch 0323 (Change 78410) System : AIX 6.1.2.0 --- On Jan 20, 5:58 pm, Jai Jagadish <[email protected]> wrote: > Hi Mujtaba, > > Find below the Query : you need to replace ' . ' by Underscore ' _ ' > in SQL Queries.. > > SQLSELECT * FROM FBNK.CUSTOMER WHERE CUSTOMER_NO LIKE 100300 > > this will work . > > Regards, > > Jai Jagadish > > On Wed, Jan 20, 2010 at 4:37 PM, Mujtaba Khan <[email protected]> wrote: > > 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
-- 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
