2.1.210: Replacement of ALIAS_COLUMN_NAME=true?

96 views
Skip to first unread message

t603

unread,
Apr 7, 2022, 12:00:20 PM4/7/22
to H2 Database
Hello, I used to use ALIAS_COLUMN_NAME=true  in JDBC URL in H2 1.x version permanently. It is dropped now in 2.x. I would like to use it in 

create linked table "linked_MY_TABLE" (..., ..., ..., ..., '(select trim(MY_COLUMN) as "COL_A" from "MY_TABLE")'); 

So I wold like to get column "MY_COLUMN" from "linked_MY_TABLE". How can I achieve it in H2 2.1.x version? Using some mode like Db2 is not welcome, it has other unwelcome effects. 

Thank You in advance for help, Stepan 
Reply all
Reply to author
Forward
0 new messages