IBM Support

PH46806: DSCLIENT SPUFI OUTPUT OF VARCHAR FIELDS CREATE EXTRA SPACES

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When SQL Query invoked from SPUFI via DSClient, there are extra
    in the output for contents of columns with VARCHAR data type.
    Adding the following options do not resolve the issue.
    ++SET NONULLIND=Y|N
    ++SET NOVARLEN=Y|N
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: ALL USERS                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: PH46806                                 *
    *                      Extra spaces in DSClient output         *
    ****************************************************************
    * RECOMMENDATION: APPLY PTF                                    *
    ****************************************************************
    PH46806
    Extra spaces in DSClient output
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH46806

  • Reported component name

    DATA VIRT MGR Z

  • Reported component ID

    5698DVM00

  • Reported release

    110

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2022-05-27

  • Closed date

    2022-08-04

  • Last modified date

    2022-09-01

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Modules/Macros

  • AVZ1PROC AVZCCLMR AVZCNWPL AVZDSNRL AVZMFMIG AVZOBJ   AVZOINAS
    AVZOINSQ AVZOMABR AVZOPPA  AVZPB    AVZSQ29D AVZSQ29N AVZSQ2BN
    AVZSQ2CN AVZSQ2DN AVZSQL9D AVZSQL9N AVZSQLBN AVZSQLCN AVZSQLDN
    

Fix information

  • Fixed component name

    DATA VIRT MGR Z

  • Fixed component ID

    5698DVM00

Applicable component levels

  • R110 PSY UI81807

       UP22/08/05 P F208

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"110"}]

Document Information

Modified date:
01 September 2022