Coalesce db2function to join three different tables?

building semantic layer
1

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)

2

Hi,

Are you defining the join in a universe? If yes then the topic will be moved to the proper forum. Please let us know.

Thanks.

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

3

Moved to Semantic Layer forum

Dave Rathbun :us: (BOB member since 2002-06-06)