Hi everyone.
I need to create an interface with dynamic values on the interface definition.
I will give an example to show what I mean:
Normally an interface is created this way:
CREATE OR REPLACE INTERFACE VIEW i_inventory_50 (
productpartnumber_0:text,
locationlocationidentifier_0:text,
inventorytype:text,
quantity:text,
quantityunits:text,
value:text,
valuecurrency:text,
reservationorders:text,
daysofsupply:text,
shelflife:text,
reorderlevel:text,
expectedleadtime:text,
quantityupperthreshold:text,
quantitylowerthreshold:text,
daysofsupplyupperthreshold:text,
daysofsupplylowerthreshold:text,
expiringthreshold:text,
plannercode:text,
velocitycode:text,
inventoryparenttype:text,
class:text,
segment:text
)
SET IMPLEMENTATION dv_inventory_50
**** What I´m trying to do looks something like this:
CREATE OR REPLACE INTERFACE VIEW i_inventory_50 (
Cast(<SELECT STATEMENT> as text)
)
SET IMPLEMENTATION dv_inventory_50
Is it possible?
Thanks in advance for anyone kind enough to respond.
