Hi,
I am trying to insert data from prod to dev by using TPT Update operator. By mistake i have deleted all error tables including work table, log table.
Agin when i submit the script am got TPT10508: RDBMS error 2583 error in teradata tpt Error. Can you please suggest me how  resolve this issue.
Error :

Hi,
 
I have to create a trigger on table A so that whenever there is any insert or delete in table A, there should be same insert and Delete in Table B.
Please let me know if it is possible. If you can provide the syntax as well that will be great.
 
Thanks.

Hi -
I have req such that , i need to call a procedure inside another using dynamic sql.
there is permanent table, which has procedure column, which will be loaded from java.
 
Once it is loaded a report procedure will be called through perl script.

SELECT a.cas_pkeyb.amt
FROM vt_notdisp_ship_to a,
scref_bvws.b_curr_trans b
WHERE (a.ship_to_addr <>'''' AND a.ship_to_addr LIKE ('%b.ship_to_addr%'))
OR (a.ship_to_code <> '''' AND a.ship_to_code LIKE ('%b.ship_to_code%'))
QUALIFY ROW_NUMBER() OVER (ORDER BY a.amount DESC) <=10;
 

Hi,
I am trying to executed a procedure having dynamic cursor which returning result set from a unix script.
Whenever i run the script, it give a warming message  as below
*** Procedure has been executed.
*** Warning: 3212 The stored procedure returned one or more result sets.