Here is a quote from an IBM Redbook "Packages
"Example: A-21 CURRENTDATA usage for packages
WHEN 'A' THEN 'A-CURRENTDATA-YES-ALL-CURSORS'
WHEN 'B' THEN 'B-CURRENTDATA-NO -AMBIGUOUS-CURSOR'
WHEN 'C' THEN 'C-CURRENTDATA-YES-AMBIGUOUS-CURSOR'
WHEN ' ' THEN 'D-PRE-CURRENTDATA'
END AS USAGE
,COUNT(*) AS NUMBER_OF_PACKAGES
WHERE DEFERPREP IN ('A','B','C',' ')
GROUP BY DEFERPREP,ISOLATION
For local packages, CURRENTDATA only applies if the package is bound with CS. For remote packages, CURRENTDATA applies with RR, RS and CS."
Now for my question. I asked some colleagues by mail and got no answer. So maybe it's not so easy?
How are the 3 values above, A, B and C obtained? O.K. I am very used to receiving value 'B' for Packages bound with CURRENTDATA(NO), but I thought CURRENTDATA(YES) probably produced value 'A'.
How does value 'C' come about? Is it abnormal? I thought I don't normally see that unless Alzheimer's is setting in. Does CURRENTDATA(YES) with ISOL(CS) and non-remote Package normal produce value 'A' or value 'C'?
DB2 Application Performance Specialist
CPT Global Ltd
Michael Hannan[Organization Members] @ Feb 07, 2018 - 11:49 AM (Europe/Berlin)
Michael Hannan[Organization Members] @ Feb 07, 2018 - 11:53 AM (Europe/Berlin)