Of course it tells. It was just a reply to Mr.Jai Jagadish, suggesting to replace dots with underscores. Anyway, It seems that SQLSELECT doesn't like dots in field names.
On Jan 21, 3:56 pm, Daniel Klein <[email protected]> wrote: > Parse Error: unable to access dict column: CUSTOMER_NO. > > Doesn't that tell you something? > > DanOn Thu, Jan 21, 2010 at 3:35 AM, Vlad <[email protected]> wrote: > > 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 > > athttp://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
