Coalesce db2function to join three different tables?

[system]

I am using the Coalesce db2 function to join the three tables. suppose t1.id=coalesce(t2.id,t3.id)

left outer join t1.AGtID=COALESCE(t2.AGNTID,t3.AGNTID)
while parsing it is throughing the error like Agentid doesnot have the authority to change the database manager configuration file.

can anyone suggest for alternate solution.

---

venkatcsit (BOB member since 2009-11-11)

[system]

Duplicated post. The original is here:

120×120 10.4 KB

I am using the Coalesce db2 function to join the three tables. suppose t1.id=coalesce(t2.id,t3.id) left outer join t1.AGtID=COALESCE(t2.AGNTID,t3.AGNTID) while parsing it is throughing the error like Agentid doesnot have the authority to change the database manager configuration file. can anyone suggest for alternate solution. venkatcsit (BOB member since 2009-11-11)

Closing this topic.

---

Marek Chladny (BOB member since 2003-11-27)