#@#@#@!!!!!!

As technical consultant, I learn new stuff everyday. My goal here to collect those day-to-day findings and organized them for future reference.

#@#@#@!!!!!!

Tuesday, June 13, 2006

How to register tables and columns in AOL?

eg.SQL> EXEC AD_DD.REGISTER_TABLE (‘SQLGL’, ‘EXAM’,’T’)

where SQLGL is aplication short name and EXAM is the table name and T stands for Transaction Data

SQL> EXEC AD_DD.REGISTER_COLUMN (‘SQLGL’, ‘EXAM’,’SNO’, 1, ‘NUMBER’, 5, ‘N’, ‘Y’);

‘EXAM’ – Table Name

‘SNO’ – Column Name

1- Sequence one or column one

‘NUMBER’- Number Data type

5-Size

‘N’ – Null able

‘Y’ – Translate (Y/N)