How to add new column in database in Siebel Development Environment

I know its really a simple topic to discuss but recently i have such requirement and i got stuck. And this solution might not be as per standard but this works for me.

Case: On a screen, I am getting SQL error saying “An error has occurred executing a Sql statement. Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00105)“

Root Cause: I have generated spool and go that screen. Now, check in spool file and find that some new column (imported by seed data) not found error in sql query. I have checked in Tools and find that this column is available in Table. That means, its not applied in database. So, all i need to Apply/DDL this column to database.

Problem: I was getting permission error while Apply/DDL using DB User/Pass.

Solution: Use SIEBEL as username and user passw as password. see below screen:

Twist: You might get an error if you are setting default value for that column.

Twist solution: You have to generate DDL and use alter query by removing its default value. Later, we can update that column to that default value.

Thats all. Please feel free to have your comments below. 

Thanks for subscribing to SimplySiebel.