Hello Everything, 
How can i capture all insert, update and delete records from a given teradata table. Will some permanent journal tables help? i know we cannot read records from journal tables directly. Is there anyway to extract such information from teradata internal tables?
 

Hi All,
I am have a table with undergoes CDC type 2. With the column Effective start date used for previous/inactive record.
Now i need a record with columns ACTIVE_PREV and ACTIVE_CURR (examples) along with their previous values as shown below.

I'm attempting to develop a stored procedure that takes a table name as a parameter, and performs column-by-column updates to whatever table is passed in.

I have the dynamic SELECT query working correctly:

SET CURSOR_SQL = 'SELECT * FROM ' || P_TABLE_NAME || ' ORDER BY rsid;';
PREPARE CURSOR_STATEMENT FROM CURSOR_SQL;
OPEN CDC_CURSOR;
/* logic */
CLOSE CDC_CURSOR;

Now I'm at the point where I need to fetch the cursor data into local variables...but I can't create table-specific local variables because I don't know what tables will be passed into this procedure.