Is the SHRLEVEL parm on the RC/EXTRACT JCL control card ignored for an SQL type extract?
Release: R20
Component: RCX
Yes. It is only used if Fast Unload is used to extract the data.
On the RC/EXTRACT SQL Extract Options these options can be seen. The SHRLEVEL parm is not there.
--------------- RC/EXTRACT SQL Extract Options -------------- yyyy/mm/dd hh:mm
Command ===>
Advanced Options:
Keys mode ==> 1 (0-private, 1-1 dataspace, 2-n dataspaces)
Dup elimination ==> U (N-None, X-Sort only, S-System only, U - User RI)
Extract Options:
Isolation level ==> RR (CS-Cursor Stability,UR-Uncommitted Read,
RS-Read Stability,RR-Repeatable Read)
It can be seen on the Fast Unload Extraction Options....
--------------- RC/Extract PFU Extract Options -------------- yyyy/mm/dd hh:mm
Command ===>
Extract Options:
Share level ==> C (C - Change, I - Ignore, R - Reference)
Use Image Copy ==> Y (Y-Yes, P-Parts, T-Template, N-No)
Advanced Options:
Keys mode ==> 1 (0-private, 1-1 dataspace, 2-n dataspaces)
Split extract ==> N (N-No, Y-Yes, U-Update default allocations)
Dup elimination ==> U (N-None, X-Sort only, S-System only, U-User RI)
Unit count ==> 01 (01-59) This value is used when Split extract=Y