If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Dynamic Column name in where clause - DB2

Started by meeecog, 29 Jun 2015 11:21:13 AM

Previous topic - Next topic

meeecog

Hello All

This is in DB2
I have below requirement ..I want to implement in FM (possible) ..any idea's

Need to select level number from table A and get required columns from table B based on the value from Table A

Select emplid, level_number from table A ..example level is 2

In table B we have different columns like this level1 , level2 , level3 ..

now .select * from table B where level2 ='xxxx' ..
pls help me out on this