DSNTIAR & DSNTIAC–SQLCA formatter for Batch & CICS

We must check for the SQLCODE before we issue commit on a table in DB2, handle the errors- Display description or whatever. handling/remembering reason for each and every sqlcode every time is a time pressing task always. There is DSNTIAR and DSNTIAC comes in picture. DSNTIAR and DSNTIAC are two assembler routine which helps to […]

CURSORS in DB2

When we are using the DB2 in our applications we can only have one row of data at a time. So what we will do if we don’t know which row exactly we need?, what if we have more than 1 row to work with? well the answer is “CURSORS”. Cursor is used when more […]