IBM Power Ideas Portal


This portal is to open public enhancement requests against IBM Power Systems products, including IBM i. 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 Not under consideration
Workspace IBM i
Categories Db2 for i
Created by Guest
Created on Oct 4, 2020

RELATED IDEAS

CPYTOSTMF

The CPYTOSTMF does not have the functionality to create a "Native Excel" XLS or XLSX file when the FROMFILE is an Physical file . Currently the CPYTOSTMF creates a delimited file separating fields using a comma, tilde, semicolon, etc.

Suggest the CPYTOSTMF include the functionality to create a "Native Excel" XLS or XLSX file in the same way the IBM\ClientSolutions Data Transfer does.


Use Case:

CPYTOIMPF FROMFILE(FOXFILOBJ/FPF2000W *FIRST) + TOSTMF(&IFSFILE) BROPT(*REPLACE) + STMFCCSID(*PCASCII) STMFAUT(*INDIR) +
RCDDLM(*CRLF) DTAFMT(*DLM) STRDLM(*NONE) +
FLDDLM('~') ADDCOLNAM(*SYS)

When running this command the end user gets a delimited file. To get the delimited file into Excel column format the user must use the "Text to Columns" function. Users complain and ask why doesn't the IBM create the Excel so I don't have an extra step?

I opened support case TS004289804 and was advised to use the RFE.


Idea priority High
  • Guest
    Reply
    |     Jan 20, 2021

    IBM does not intend to provide a solution to this request at this time, so it is being closed. Since there are existing solutions for generating spreadsheets, we see limited value investing in a CPYTOSTMF enhancement.

    Db2 Web Query appears to be a good fit for your need.
    Here are links that describe some other potential solutions:
    https://www.ibm.com/support/pages/node/6340297/
    https://www.ibm.com/support/pages/acs-data-transfer-download-excel-spreadsheet
    https://www.youtube.com/watch?v=RMV6LUCsIRU
    There are IBM i Open Source solutions as well.

  • Guest
    Reply
    |     Oct 7, 2020

    When the output file uses a comma for the field separator and the file name ends with a .csv extension, then the file will usually open in Excel with the columns separated, unless your PC is configured to open a CSV file with another application. There are still some limitations, but it should at least save a step.

  • Guest
    Reply
    |     Oct 7, 2020

    pnicolay,
    I understands FoxPools point. The program extracting the data can mail
    a file directly to the user in the XLS format without manual intervention.

    Your approach requires that somebody does something manually to get the data in the right format.

    Perhaps IBM should consider commands to convert between most common formats today.
    It could be open source formats that is supported by the most common products today.
    And here I am not only thinking about spreadsheet formats but also formats for editors etc.

  • Guest
    Reply
    |     Oct 5, 2020

    Due to processing by IBM, this request was reassigned to have the following updated attributes:
    Brand - Servers and Systems Software
    Product family - Power Systems
    Product - IBM i
    Component - Db2 for i
    Operating system - IBM i
    Source - Client

    For recording keeping, the previous attributes were:
    Brand - Servers and Systems Software
    Product family - Programming Languages
    Product - Developer for Power Systems
    Component - Other
    Operating system - IBM i
    Source - Client

  • Guest
    Reply
    |     Oct 5, 2020

    You can use the IBM i ACS Data Transfer functions which run native on IBM i as well.

    http://www.web400.com/downloads/ACS/RunIBMiAccessClientDataXfers.pdf

  • Guest
    Reply
    |     Oct 5, 2020

    You can use the IBM i ACS Data Transfer functions which run native on IBM i as well.

    http://www.web400.com/downloads/ACS/RunIBMiAccessClientDataXfers.pdf

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.