HSQLDB

@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

@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.

Hi Rendou,

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

Regards

Guido

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

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