i am using TERADATA SQL assistant and IBM Mainframes. using that i wanted to update a column value to '['. the query liiks like:
UPDATE ABC_TABLE SET COULMN_C = '[' WHERE COLUMN_A = '07' AND COLUMN_B = 'CBC';
where COLUMN_A and COLUMN_B are the Primary indexes of table ABC_TABLE.
when i tried to run the above mentioned queries using a JCL job, the changes were not incorporated though the the job ran successfully. But if i run the same query in SQL assistant, the updates are incorporated successfully. and i am not sure of the reason. kindly let me know the neccessary information regarding the same.