Page 1 of 1

Maifnrame DB2 'Relative', 'Sensitive' and DB2 UDB.

Posted: Mon Sep 28, 2015 11:51 am
by WendyH
I've a COBOL code which has an SQL like this:

Code: Select all

EXEC SQL 
FETCH SENSITIVE RELATIVE -1 SAM_CURSOR 
INTO :SAM-LOC-TRXN-CD 
,:SAM-LOC-TRXN-DESC 
,:SAM-LOC-CAT-CD 
END-EXEC. 
I need to test this in MFE Tool, which is replica of Mainframe environment and am testing the code in "Net express" which is set-up in windows. The problem is that keywords 'Relative' and 'Sensitive' are not supported in UDB. Are there equivalent for these in UDB?