Parse Error: unable to access dict column: CUSTOMER_NO. Doesn't that tell you something?
Dan On 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 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
