DDL function

When the DDL function in the IP is called, the DDL function should perform the following steps:

1. Get information about the table (name, owner, qualifier).

   pList = dam_getSchemaObjectList(hstmt, DAMOBJ_TYPE_TABLE);

   damobj_table pTableObj = getFirstSchemaObject(pList);

2. Get column definitions.

   pList = dam_getSchemaObjectList(hstmt, DAMOBJ_TYPE_COLUMN);

   damobj_column pColumnObj = dam_getFirstSchemaObject(pList);

   while ( pColumnObj ){

   pColumnObj = dam_getNextSchemaObject(pList);

   /* get the column attributes */

   }

3. Get the index definition.

   pList = dam_getSchemaObjectList(hstmt, DAMOBJ_TYPE_STAT);

   damobj_stat pStatObj = dam_getFirstSchemaObject(pList);

   while ( pStatObj ){

   /* get the index information from pStatObj */

   pStatObj = dam_getNextSchemaObject(pList);

   }

4. Get foreign keys information

   pList = dam_getSchemaObjectList(hstmt, DAMOBJ_TYPE_FKEY);

   damobj_stat pFkeyObj = getFirstSchemaObject(pList);

   while ( pFkeyObj ){

   pFkeyObj = dam_getNextSchemaObject(pList);

   /* get the foreign key attributes */

   }

5. Use the supplied table, columns and foreign keys information to create your table.