Fetching and updating cursors dating software 7 1 2

Rated 3.85/5 based on 722 customer reviews

So you also supply a list of COBOL Variables corresponding to each SQL Data-value received.

For the SQL Type DECIMAL(7,2), 7 is the total width, 2 is the digits after the decimal point.Similarly, the is the place in the COBOL Program, from where the data departs and is output to the File, here for the OUTPUT-FILE it is EMPLOYEE-OUTPUT-RECORD.So, when you do a WRITE EMPLOYEE-OUTPUT-RECORD, whatever’s stored in EMPLOYEE-OUTPUT-RECORD is written to the file.The 200-FETCH Paragraph is performed over and over again, till you’ve read the last row, until SQLCODE= 100.The 2nd FETCH will store 2 in EMPLOYEE-ID, RAJ in EMPLOYEE-NAME, 2000 in EMPLOYEE-SALARY and 2005-01-03 in EMPLOYEE-JDATE.

Leave a Reply