IC5Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.
Topic
  • 1 reply
  • Latest Post - ‏2013-02-26T15:59:47Z by SystemAdmin
SystemAdmin
SystemAdmin
3105 Posts

Pinned topic DB2 V10 z/OS CONCENTRATE STATEMENTS via Perl DB2

‏2013-01-23T14:17:57Z |
DB2 v10 for z/OS provides a new Dynamic Cache enhancement feature with the use of attribute "CONCENTRATE STATEMENTS WITH LITERALS". The use of the feature results
in more sharing and reuse of cached statements.

Could someone help provide a example that sets the attribute via perl db2 code. I am using perl 5.8 and perl 5.10 version. I have been able to use the feature via Rexx.
Updated on 2013-02-26T15:59:47Z at 2013-02-26T15:59:47Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    3105 Posts

    Re: DB2 V10 z/OS CONCENTRATE STATEMENTS via Perl DB2

    ‏2013-02-26T15:59:47Z  
    can you post the code you tried and the error you get?
    I never used perl but you should be able to specify that in the prepare command