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)
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)
<< Home