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
