HSQLDB

6 Posts
2 Users
0 Likes
189 Views
(@rendou)
Member
Joined: 1 year ago
Posts: 3
Topic starter  

I am using HSQLDB with DBEAVER but this database is not fully supported by SQLINFORM extension. Some keywords such as ATOMIC, SPECIFIC, LANGUAGE SQL NOT DETERMINISTIC etc... are not recognized as such. Even the RETURN keyword is pasted to other keywords on the same line. Can you add support for this database.


   
Quote
Guido
(@admin)
Member Admin
Joined: 2 years ago
Posts: 159
 

@rendou, Hi, thanks for your great idea.

I am happy to add HSQLDB to the formatter. I already started looking to the docs. Do you have a few examples to help me testing the missing keywords.

Regards

Guido


   
ReplyQuote
(@rendou)
Member
Joined: 1 year ago
Posts: 3
Topic starter  

@admin, hi, thanks for your response.
I inform you that I use DB2 as model for the formatting. This is the closest thing to HSQLDB. However, some keywords are not supported. As requested I am attaching 2 example where you can see how some HSQLDB specific keywords are formatted
ATOMIC, SPECIFIC etc... do not seem to be recognized.
No line break for RETURNS.
RETURNS, SPECIFIC, LANGUAGE are on the same line. TABLE(RUB1 CHARACTER(3),BS1 DECIMAL(9,2),TX1 DECIMAL(6,3),MT1 DECIMAL(9,2))
should have one field per line for clarity.
Regards.
Rendou.


   
ReplyQuote
Guido
(@admin)
Member Admin
Joined: 2 years ago
Posts: 159
 

Hi Rendou,

did you attach the 2 files to the post? I cannot find them

Regards

Guido


   
ReplyQuote
(@rendou)
Member
Joined: 1 year ago
Posts: 3
Topic starter  

Hi Guido.
I attached the two files but apparently that was not done. so I am attaching the code for both examples. I hope this will help you.

CREATE FUNCTION PUBLIC.RETENUE_IRG(IN BASE_IMPOSABLE_I DECIMAL(9,2),
                                   IN HRES_ABSENCES    DECIMAL(5,2),
                                   IN HRES_AUTRES      DECIMAL(5,2),
                                   IN HRES_MOIS        DECIMAL(5,2),
                                   IN HANDICAP         SMALLINT) RETURNS DECIMAL(128) SPECIFIC RETENUE_IRG_10399 LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL CALLED ON NULL INPUT
        BEGIN
            ATOMIC DECLARE BASE_IMPOSABLE DECIMAL(9,2);
            DECLARE NBRE_TRANCHES         DECIMAL(9,2);
            DECLARE IRG_CALCULEE          DECIMAL(9,2);
            DECLARE ABATTEMENT            DECIMAL(9,2);
            DECLARE IRG_BASE              DECIMAL(9,2);
            DECLARE PLANCHER              DECIMAL(9,2);
            DECLARE TAUX                  DECIMAL(9,2);

-------------------------------------------------------------------------------------------------------

CREATE FUNCTION PUBLIC.LIST_RUBS_3(IN MAT CHARACTER(4)) RETURNS TABLE(RUB1 CHARACTER(3),BS1 DECIMAL(9,2),TX1 DECIMAL(6,3),MT1 DECIMAL(9,2)) SPECIFIC LIST_RUBS_03 LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA CALLED ON NULL INPUT
        BEGIN
            ATOMIC DECLARE TABLE VALO2(RBX2 CHAR(3),BASE2 DECIMAL(9,2),TAUX2 DECIMAL(6,3),MONTANT2 DECIMAL(9,2));
            FOR
            SELECT
                PUBLIC.DONNEES.MATRIC ,
                PUBLIC.DONNEES.RUBRIC ,
                PUBLIC.DONNEES.TYP_RUB,
                PUBLIC.DONNEES.BASE   ,
                PUBLIC.DONNEES.TAUX   ,
                PUBLIC.DONNEES.MONTANT
            FROM

Regards.

Rendou


   
ReplyQuote
Guido
(@admin)
Member Admin
Joined: 2 years ago
Posts: 159
 

Thanks!

A first version for HSQLDB is ready and I am doing some tests.

Will publish it next week

If you have adiitonal examples, just post them here or send them to info @ sqlinform . com

 

Regards

Guido


   
ReplyQuote
Share: