PH20344: SQLENGINE DATE AND TIME FUNCTION DAYOFYEAR RETURNS 0

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SELECT DAYOFYEAR() function returns the value of 0 instead of
  the expected numeric value.
  

Local fix

Problem summary

• ****************************************************************
  * PROBLEM DESCRIPTION: SQLEngine Date and Time                 *
  *                      function DAYOFYEAR returns 0            *
  ****************************************************************
  SQLEngine Date and Time function DAYOFYEAR returns 0
  

Problem conclusion

Temporary fix

Comments

APAR Information

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

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

Modules/Macros

• AVZ$461E AVZ$461M AVZ$462E AVZ$462M AVZ$IA40 AVZ$IA42 AVZ$IAL1
  AVZ$IAO1 AVZ$K610 AVZ$K611 AVZ$K612 AVZ$K613 AVZ$K614 AVZ$K615
  AVZ$K616 AVZ$K617 AVZ$K620 AVZ$K621 AVZ$K622 AVZ$K623 AVZ$K624
  AVZ$KE32 AVZ$KE33 AVZ$KFE1 AVZ$ME20 AVZ$MEP0 AVZ$N830 AVZ$N850
  AVZ$N860 AVZ$N870 AVZ$N880 AVZCCAPR AVZCDSPS AVZCDSTZ AVZCMQIO
  AVZCSPTB AVZCSQMM AVZMFMIG AVZOIO31 AVZOPPA  AVZOPRUT AVZPB
  AVZSQ29D AVZSQ29N AVZSQ2AD AVZSQ2AN AVZSQ2BD AVZSQ2BN AVZSQ2CD
  AVZSQ2CN AVZSQ2DD AVZSQ2DN AVZSQL9D AVZSQL9N AVZSQLAD AVZSQLAN
  AVZSQLBD AVZSQLBN AVZSQLCD AVZSQLCN AVZSQLDD AVZSQLDN AVZWSIMP
  

Fix information

• Fixed component name

  DATA VIRT MGR Z

• Fixed component ID

  5698DVM00

Applicable component levels

• R110 PSY UI68240

     UP20/03/10 P F003

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.