Skip to main content

JR30054: FUNCTION MIDNIGHTSECONDSFROMTIME SHOULD BE AVAILABLE IN THE DROP DOWN LIST


Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • Environment
    Server Solaris 2.10
    Information Server 8.01
    
    Client
    Windows XP 2002 SP2
    
    Problem
    
    The function MidnightSecondsFromTime (gives second in the day
    (0-86400)
    from a time field) should be available in the drop down list of
    Transformer functions under the Date & Time category. It is
    missing in
    the functions presented. It does, however, exist in the DSParams
    file.
    The entry in the DSParams file is:
    
    MidnightSecondsFromTime\Returns the number of seconds from
    midnight to
    the given time\Date &
    Time\dfloat\time\midnight_seconds_from_time
    Note that the second '\' delimited field should be the number of
    arguments the function expects. It is missing. The line should
    read:
    
    MidnightSecondsFromTime\1\Returns the number of seconds from
    midnight to
    the given time\Date & Time\df
    loat\time\midnight_seconds_from_time
    The function then correctly appears in the drop-down list in the
    Transformer stage.
    
    Workaround
    
    Edit the line as above and save. Save also the the DSParams file
    in the
    Template directory in $DSHOME/../Template
    
    Severity
    
    This is a critical issue for customers who are unaware of the
    problem.
    As here, they may find themselves writing external parallel
    functions in
    C to code around a problem that already has a solution!.
    Additionally,
    future releases of the product may well overwrite the 'fixes' to
    DSParams that could easily be overlooked.
    

Local fix

  • Workaround
    
    Edit the line as above and save. Save also the the DSParams file
    in the
    Template directory in $DSHOME/../Template
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    Users requiring MIDNIGHTSECONDSFROMTIME function
    ****************************************************************
    PROBLEM DESCRIPTION:
    Function is incorrectly specified in DSPARAMS
    ****************************************************************
    RECOMMENDATION:
    See workaround documented in the Error Description field.
    Will be fixed in a future release.
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    JR30054

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    801

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-07-30

  • Closed date

    2009-01-07

  • Last modified date

    2009-01-07

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

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

Modules/Macros

  • CLIENT
    

Fix information

Applicable component levels

  • R801 PSN

       UP

Rate this page:

(0 users)Average rating

Copyright and trademark information

IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.

Rate this page:


(0 users)Average rating

Add comments

Document information

InfoSphere DataStage


Software version:
8.0.1


Reference #:
JR30054


Modified date:
2009-01-07

Translate my page

Content navigation