FWD » Core Development » Database

09/29/2017

02:26 PM Feature #3296: misc db features

The following is needed:
* -#3257-67 possible table parameter issue documented in #2000-74 which would convert and... Greg Shah

02:23 PM Feature #3296: misc db features

Both #3257-35 and #3257-54 have been found to be not needed. These can be ignored. Greg Shah

02:22 PM Feature #3296: misc db features

Eric reports that the BY-REFERENCE support for conversion and runtime does need to be added. Greg Shah

09/20/2017

08:11 AM Bug #3324 (Closed): Incorrect handling of temp tables with the same name makes translated code no...

Branch 3330a was merged to trunk as revision 11164. It is expected to be released as FWD v3.1 in the next few days.
... Greg Shah

09/06/2017

08:43 PM Feature #3319: investigate viability of using the Progress database as a back-end

You are correct in your assumption. I was just trying with both the UDF support and the schema to try and see what m... Christopher Cotter

08:11 PM Feature #3319: investigate viability of using the Progress database as a back-end

Christopher Cotter wrote:
> I am working on getting the hotel table and index ddl files applied to OE 11.7.
>
> I... Eric Faulhaber

09/05/2017

07:38 PM Feature #3319: investigate viability of using the Progress database as a back-end

OE SQL Reserved Words List
http://knowledgebase.progress.com/articles/Article/000049334
Christopher Cotter

06:50 PM Feature #3319: investigate viability of using the Progress database as a back-end

I am working on getting the hotel table and index ddl files applied to OE 11.7.
It's mostly working with the excep... Christopher Cotter

09/02/2017

09:57 PM Feature #3319: investigate viability of using the Progress database as a back-end

Christopher Cotter wrote:
> Changing "double precision" to "decimal" and "datetime2" to "timestamp" seemed to do the... Eric Faulhaber

09/01/2017

07:52 PM Feature #3319: investigate viability of using the Progress database as a back-end

Changing "double precision" to "decimal" and "datetime2" to "timestamp" seemed to do the trick. What are the potenti... Christopher Cotter

06:37 PM Feature #3319: investigate viability of using the Progress database as a back-end

I am having some success but running into this error. Maybe something to do with the "double precision" datatype? I ... Christopher Cotter

04:15 PM Feature #3319: investigate viability of using the Progress database as a back-end

Something like this works. Different syntax but similar idea.
How much effort would be needed to add a progress o... Christopher Cotter

02:03 PM Feature #3319: investigate viability of using the Progress database as a back-end

BTW, I don't know if you're just interested in the SQL Server DDL FWD generates, or if you actually want to get Hotel... Eric Faulhaber

01:30 PM Feature #3319: investigate viability of using the Progress database as a back-end

Christopher Cotter wrote:
> So it sounds like these constructs are custom java work needed to support SQL Server?
Y... Eric Faulhaber

01:11 PM Feature #3319: investigate viability of using the Progress database as a back-end

So it sounds like these constructs are custom java work needed to support SQL Server?
3. the p2j2clr.dll assembly ... Christopher Cotter

12:47 PM Feature #3319: investigate viability of using the Progress database as a back-end

Ok, so there is a second "shim" layer in the @p2j.dll@ assembly that we don't have for the "pure Java" UDF implementa... Eric Faulhaber

12:24 PM Feature #3319: investigate viability of using the Progress database as a back-end

I am not sure whether SQL Server has a @CREATE ALIAS@ statement, but the FWD mechanism that replaces the overloaded f... Ovidiu Maxiniuc

12:00 PM Feature #3319: investigate viability of using the Progress database as a back-end

Christopher Cotter wrote:
> Is the CREATE ALIAS really necessary? Is there a reason all of the UDF parameters could... Eric Faulhaber

11:41 AM Feature #3319: investigate viability of using the Progress database as a back-end

Does this use the same runtime mapping as we use for UDFs overloaded with CREATE ALIAS (i.e., to map an undecorated U... Eric Faulhaber

11:26 AM Feature #3319: investigate viability of using the Progress database as a back-end

Eric Faulhaber wrote:
> Ovidiu, didn't you have to deal with UDF overloading without CREATE ALIAS for SQL Server?
... Ovidiu Maxiniuc

11:16 AM Feature #3319: investigate viability of using the Progress database as a back-end

Looks like on OE there is a CREATE SYNONYM rather than CREATE ALIAS
https://documentation.progress.com/output/ua/O... Christopher Cotter

11:15 AM Feature #3319: investigate viability of using the Progress database as a back-end

Question via email:
> Looks like on OE there is a CREATE SYNONYM rather than CREATE ALIAS
>
> https://documentatio... Eric Faulhaber

05:56 AM Bug #3324: Incorrect handling of temp tables with the same name makes translated code non-compilable

This is not a bullet-prof solution. There are still cases when this kind of name collisions can occur. We need to thi... Ovidiu Maxiniuc