Change the partition integer dynamically in COBOL DB2 pgm

shrinivasabharathi_b · New User Joined: 04 Nov 2008 Posts: 11 Location: Chennai

EXEC SQL
LOCK TABLE WRKSHT PART integer IN EXCLUSIVE MODE
END-EXEC

Is there a way to change the partition integer dynamically in COBOL DB2 program?

dbzTHEdinosauer · Posted: Thu Nov 13, 2008 1:05 pm

in db2 you do not 'change' anything, you UPDATE or ALTER. Try using those words in your searches.

shrinivasabharathi_b · New User Joined: 04 Nov 2008 Posts: 11 Location: Chennai

I need to get the exclusive lock for 50 partitions in a table as shown below.

Part1:
EXEC SQL .
LOCK TABLE WRKSHT PART 1 IN EXCLUSIVE MODE
END-EXEC

Part2:
EXEC SQL
LOCK TABLE WRKSHT PART 2 IN EXCLUSIVE MODE
END-EXEC

--
--
--

Part50:
EXEC SQL
LOCK TABLE WRKSHT PART 50 IN EXCLUSIVE MODE
END-EXEC

Is there any possibility of using the working storage variable in the place of partition number or
Is there a way to give ranges.
for ex: 1 to 7, 7 to 15....