Suppose, my embeded sql is fetching two rows.(Iam not using cursors).
I will get -811 sql error, my question is what value will come to host variables.
ex: SELECT ename INTO : HV_ename FROM emp WHERE sal = 5000;
suppose, in a update/insert SQL query for vachar field, I given/moved length = 10, text = 20 chars. what will happen while updating/inserting.
is only 10 chars of the text is updated/inserted or 20 chars of the text.
plz clarify ........
Is it possible to code a direct sql update query in COBOL- DB2 pgm.
ex: update emp_table set sal = 6000 where sal = 5000;
Eagarly waiting for ur valuble correct answers......