SQL Statements compatibility with jBase

Hi All,
Can any one give me a document which has got the corresponding jQL statements for the SQL statements supported by Universe. Thanks in advance.
_________________
With Smile,
Sairam.B

Hi sairam....

I think you are doing big R&D.....

If you post any UNIVERSE SQL statements here, then we can find its equallant jQL.
_________________
M A L A I

Can you convert these commands in JQL?

Here are some of the SQL commands

1) Select * from <tablename> where <fieldname>='Value'(displays the records from the specified table that matches the condition)
2) Select * from sys.objects where type='u'(which shows all the table name list in the specified database)
3) Delete from <tablename> where <fieldname>='Value'(delete the records from the specified table that matches the condition)
4) Insert into <tablename> [<fieldname1,fieldname2>]Values[value1,value2](Insert records into the specified field of a table)
5) Delete from <tablename> where <fieldname>='Value'(deletes the records from the specified table that matches the condition)

Hi jpb,
Can you expain in more detail? What is jql command to display all the table name(or file name) resides in particular database in jBase?

Dear jpb,

For this SQL query what is the equivalent JQL.

SELECT * FROM FBNK_ACCOUNT WHERE ROWNUM <= 100 ;

If im not mistaken, can we use the below

SELECT FBNK.ACCOUNT SAMPLE 100

Thanks & Regards,
Durairaj. N

Hi all,
What is ORDER BY and GROUP BY equivalent command in JQL?

Dear Experts,

Can anyone provide the JQL command used to count T24 records with criteria involving multiple values and sub-values within DBTools?

Thank you.

Hi
if you use regular "EQ" etc it will work transparently, e.g. SELECT FBNK.ACCOUNT WITH OTHER.OFFICER EQ '10' will find records with:
- OTHER.OFICER = 1, 10, 100
- OTHER.OFFICER = 10, 50, 60

"NE", "LIKE" is another story...