We have a DB2 database that has multiple schemas that represent different environments for us. In Universe Designer, I have a Universe that I would like to have @Prompt('Schema','N','Secured Prompts\SchemaList',MONO,CONSTRAINED) for the Table Schema Owner.
In other words, when I add a table using Table Browser, I'm adding a particular schema owner.table, and I'd like to rename the table to owner=@Prompt('Schema','N','Secured Prompts\SchemaList',MONO,CONSTRAINED).
When I do the above procedure, I get "" double quotes around the newly renamed table (e.g., "@Prompt('Schema','N','Secured Prompts\SchemaList',MONO,CONSTRAINED).TableA"). This isn't correct. I inheireted a universe that has some tables setup this way, so I know it can be done. I just can't find any documentation on how to do it.
Thanks!
In other words, when I add a table using Table Browser, I'm adding a particular schema owner.table, and I'd like to rename the table to owner=@Prompt('Schema','N','Secured Prompts\SchemaList',MONO,CONSTRAINED).
When I do the above procedure, I get "" double quotes around the newly renamed table (e.g., "@Prompt('Schema','N','Secured Prompts\SchemaList',MONO,CONSTRAINED).TableA"). This isn't correct. I inheireted a universe that has some tables setup this way, so I know it can be done. I just can't find any documentation on how to do it.
Thanks!