Bajaj,

We use INT for role column in DB2. I am using appfuse 1.9.3 but i doubt there is a permission column in 2.0. Btw, regarding generation of DDL, i suggest that you should setup your own db2 development environment, make sure everything is working fine first. After that, you can use db2 facility(specifically , db2look) to generate the table schema at once.

Best regards,
Jonathan

Bajaj, Deepak wrote:
That's ok. How do I create the appropriate and correct tables in DB/2 to
suppor the user and role in DB2.
Presently MYSQL is using bitmap columns for permissions, DB2 does not
have this as a datatype. I wonder, how do I get or generate the right and appropriate script for table creation for DB2.
Table creation needs to be done by a different deptt, and we need to
provide a DDL script for same. Rgds, Deepak

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to