Hello,
I want to create one virtual view that uses the same tables from different DBs.
My problem is with the numeric columns, each DB returns different type for the same column.
for example this view:
CREATE VIEW test_view(
column_id bigdecimal
)
AS(
select
column_id
FROM test
);
when i deploy the VDB and the Data source is oracle it is ok, for MSSQL or DB2 for example, it throws an exception that the expected type is bigdecimal and the actual was long. It would save me alot of effort if i have one type for whole numbers. Is there some kind of manipulation i can do in the VDB to achieve this. i want something like:
CREATE VIEW test_view(
column_id number
)
AS(
select
column_id
FROM test
);
So that it would work for all DBs whole numbers types.
Thanks
Hend
Assuming long is wide enough, you would just use:
CREATE VIEW test_view(
column_id long
)
AS(
select
cast(column_id as long)
FROM test
);