Combination of dense mode and insert mode

Hello Benedikt,

Indeed, the combination insert mode and dense mode is not supported.

Perhaps a long shot, but using indexed database tables might provide an alternative.

Let me explain using the following example:

Data is kept per day, per product, per region. This data is updated monthly. So when writing the data, we want to update all data for that month, but leave the data for other months alone.

The database table is declared something like this, note that it is indexed per day.

DatabaseTable db_tableSelectedDay {

    IndexDomain: i_day;

    DataSource: sp_datasource;

    TableName: "TableAB";

    Mapping: {

        "pr"    --> i_product,

        "reg"   --> i_region,

        "date"  --> i_day,

        "price" --> p_price( i_product, i_region, i_day ),

        "sold"  --> p_sold( i_product, i_region, i_day )

    }

}
 

Next, when updating for a month, we use the following for loop:

Procedure pr_writeSelectedMonthDataToDatabase {

    Body: {

        

        for i_sday do

            write p_price( i_product, i_region, i_sday ), p_sold( i_product, i_region, i_sday ) 

                to table db_tableSelectedDay( i_sday ) in dense replace mode ;

        endfor ;

        

        CloseDataSource( sp_datasource );

    }

}
 

Does this provide an acceptable alternative?

With kind regards,

Chris