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

RDBMS from IBM and IBM's Hierarchical DBMS and Transaction Manager (IMS DC).
Post Reply
WendyH
New Member
Posts: 2
Joined: Fri Feb 06, 2015 2:11 pm

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

Post 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?
Post Reply

Create an account or sign in to join the discussion

You need to be a member in order to post a reply

Create an account

Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute

Register

Sign in

Return to “IBM DB2 and IMS DB/DC”