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

Add comments

Document information


More support for:

InfoSphere DataStage

Software version:

8.0.1

Reference #:

JR30054

Modified date:

2009-01-07

Translate my page

Machine Translation

Content navigation