After retrieving records using cursors, can perform update

sandhyamf · New User Joined: 07 Feb 2007 Posts: 3 Location: hyderabad

Hi,

After retrieving records using cursors,how can perform update?
What is the max size of working storage section?
What is onsize error in cobol?

Regards,
Sandhya.

manihcl85 · New User Joined: 11 Jan 2007 Posts: 52 Location: chennai

Hi,

U have to use update cursor cursorname set fieldname = value where "record u want to update" or "current of cursor for updating the current record"

Regards,
Mani

manihcl85 · New User Joined: 11 Jan 2007 Posts: 52 Location: chennai

Hi,

onsize error is an function to say what to do in case if any overflow or error due to size of an variable occured.

Regards,
Mani

mmwife · Super Moderator Joined: 30 May 2003 Posts: 1592

You can also get a SIZE ERROR dividing by zero or when using windowed date fields (I've never used these date fields, so I have no details.)

hanu_010 · New User Joined: 25 Jan 2007 Posts: 9 Location: hyd

FOR UPDATE OF IS DECLARED IN DECLARE CURSOR

AFTER FETCH

WE UPDATE THE COLUMNS AND SHOULD CODE WHERE CURRENT OF

hanu_010 · New User Joined: 25 Jan 2007 Posts: 9 Location: hyd

ON SIZE ERROR IS USING TO TRAP THE SIZE ERRORS

01 A PIC 99.
01 B PIC 99.
01 C PIC 99.

COMPUTE C = A + B.

A=90
B=10

AFTER CALUCLATION A + B = 100,

BUT C HAS A PIC 99.

SO FINAL RESULT WILL BE 00

SO THERE IS SIZE ERROR

TO AVOID THIS WE HAVE TO USE ON SIZE ERROR

COMPUTE C = A +B ON SIZE ERROR DISPLAY ' SIZE ERROR'