ASCII

Database
Enthusiast

ASCII

hi all

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.

let me know if you need any more information.
1 REPLY
Enthusiast

Re: ASCII

Can you paste the tabled definition ?

Any chance that column_A is an integer or so ?

Also you can try using DBQL to log the SQLs being fired ... might get something out of it if you are lucky !