IBM Z Software


This portal is to open public enhancement requests against IBM Z Software products. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).


Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,

Post your ideas

  1. Post an idea.

  2. Get feedback from the IBM team and other customers to refine your idea.

  3. Follow the idea through the IBM Ideas process.


Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

Add a new idea Subscribe
Status Is a defect
Workspace COBOL Compilers
Created by Guest
Created on Aug 5, 2015

RELATED IDEAS

Cobol V5 - STGOPT does'nt optimize SQL--* variables created par SQL option

Cobol V5 compiler, as Cobol V4 compiler, can process DB2 SQL commands through the integrated coprocessor (instead of a pre- compilation) .

When the SQL compiler option is enabled, the "automatic" variables SQL - * are created.

We identified a difference in behavior between V4 Cobol and V5 Cobol :
? Cobol V4 with options SQL and OPTIMIZE(FULL) : SQL variables - * are deleted if they are not referenced.
? Cobol V5 with options SQL and STGOPT : SQL variables - * are not deleted even if they are not referenced , which causes a loss of memory space .

Idea priority Medium
  • Guest
    Reply
    |     Oct 26, 2015

    This is being considered as a defect. The RFE will be updated, once a fix is available.

  • Guest
    Reply
    |     Sep 14, 2015

    Due to processing by IBM, this request was reassigned to have the following updated attributes:
    Brand - Servers and Systems Software
    Product family - Programming Languages
    Product - COBOL Compilers

    For recording keeping, the previous attributes were:
    Brand - Rational
    Product family - Design & development
    Product - COBOL Compilers

  • Guest
    Reply
    |     Sep 2, 2015

    Thanks for the files. We are investigating them.

  • Guest
    Reply
    |     Sep 1, 2015

    DB2 V10

    See samples "INFOPROG" in Attachments.

  • Guest
    Reply
    |     Sep 1, 2015

    Attachment (Description): Sample programme compiled with Enterprise Cobol V5 and option STGOPT : SQL--* variables are not discared

    INFOPROG_COBV5_...
    INFOPROG_COBV5_STGOPT.txt
    Open full size
    INFOPROG_COBV5_STGOPT.txt
  • Guest
    Reply
    |     Sep 1, 2015

    Attachment (Description): Sample program compiled with Enterprise Cobol V4 and option OPTIMIZE(FULL) : SQL--* variables are discared.

    INFOPROG_COBV4_...
    INFOPROG_COBV4_OPT(FULL).txt
    Open full size
    INFOPROG_COBV4_OPT(FULL).txt
  • Guest
    Reply
    |     Aug 27, 2015

    I checked stgopt with integrated CICS transalator. In this this case, the allocation of unused DFH-fields is properly suppressed.

  • Guest
    Reply
    |     Aug 26, 2015

    Attachment (Description): Two compile listings

    cob-sql.zip
    cob-sql.zip
    Open full size
    cob-sql.zip
  • Guest
    Reply
    |     Aug 26, 2015

    We are running DB2 V10. Attach compile listing of simple sql program.

  • Guest
    Reply
    |     Aug 25, 2015

    Can we get an example of this issue? and the difference between V4 and V5. Also, what version of DB2 is being used?
    Also listing file of options would be helpful. Thanks.

  • Guest
    Reply
    |     Aug 25, 2015

    I observe more than 4K unused storage in the Working-Storage, which is ignored by STGOPT.

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.