Skip to Content
0
Jun 22, 2015 at 09:56 AM

How to assign SQL query for an Object in IDT - DF

279 Views

Dear Experts,

We are creating an Relational Universe based on SQL queries given by the user, need to assign SQL query for an object in IDT- Data foundation layer

Below is the code...

E.EFFDT=(Select Max(E_ED.EFFDT) From Table

Where E.SETID = E_ED.SETID

AND E.ACCOUNT = E_ED_ACCOUNT

AND E_ED.EFFDT <=SYSDATE)

Can any one help me on this how to assign the above SQL query for an Object(EFFDT)

Regards

Ravi Shankar