Hi If your environment doesn't work well with SQL, then you can use SELECT in jBase
Customer, Account, ... and many other tables have over 100 fields and plus the locally added maybe. In that case you can use (S)SELECT FBNK.CUSTOMER WITH @ID LIKE '...XXX...' ALL or if you need some fields then you can (S)SELECT FBNK.CUSTOMER WITH @ID LIKE '...XXX...' FIELD1 FIELD2 ... at the end make SAVE.LIST list_name or SAVE-LIST list_name, and you have the data in &SAVEDLIST& directory. But in case you obtain that data, then you have to write a routine to process that data additionally, if necessary, so a query in jBase is completely different from a query in SQL and you'd better use a routine for all that. Regards IM On Wed, Jan 20, 2010 at 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 > > -- Igor Micev
-- 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
