• Date Timestamp Conversion

    I'm a new born SEQUEL user€¦ we had class back on the 10th of September and the instructor show us an example of a date conversion, but I don't recall how it was done.

    Here's an example of the data I need to convert to Date: 09242012 Time: 14:57:00 from the following timestamp.

    Library File Field

    Time Stamp Type Length Dec
    20120924145700 P 14 0

    Liz W.

  • Passing a Date for Caluculation

    I need to pass a date value to view which then uses it to calculate age of a invoice. However, the date passed is converted to a decimal value. Date 01/09/12 (dd/mm/yy) is displayed as .009259259259250. Ie 1 divided by 9 and then divied by 12. How do I stop this ?
    Attchment shows variable definition and details.

    Many Thanks in Advance.


    when using CVTDATE on a field with the value of 20501231 it outputs ????????//
    If I convert 20120701 it returns 07/01/12 so I'm not sure what the issue is.
    Thanks in advance for any date conversion/prompting help


    Having issue with CVTDATE CYMD format as I am receiving errors on date of 1680603. Is there a sequel solution?

  • Time Subtraction Calculations

    I'm currently in need of a method to subtract iSeries dates and times. I have experimented, read and searched through help for best practices for such operations but have yet to find a method that isn't a nested case statement which includes converting hours to minutes and adding the minutes using conversions from one data type to another.

    If you have a method that you use to subtract dates and times I would appreciate your ideas and thoughts.




    Why do I get a message OPNQRYID(003) FILE(FILENAME) when I run my sequel script in QBATCH on iseries?
    It does not happen all the time but happens frequently.
    Can someone please help?
    We use green screen for SEQUEL not VIEWPOINT.


  • Option authority on the WRKSPLFE

    On the WRKSPLFE command, once a user sees the list of spooled files, is there any way to easily limit which options a given user can see and subsequently, execute? For example, I want somebody to have the authority to "E=ESndMail" but do not want anybody to use "I=CpytoIFS", from the WRKSPLFE command. I want to be able to limit who can do what intereactivly, without affecting any batch jobs that they submit jobs where our programmers have embedded a ESEND command.

    Thanks in advance,

    Jim Staub
    Perform Group LLC

  • Import of iSeries QRY view with join file

    I am getting the following error when attempting to import a QRY view that has join files in it:
    Additional Message Information

    Message ID . . . . . . : QRY2303 Severity . . . . . . . : 00
    Message type . . . . . : Diagnostic
    Date sent . . . . . . : 08/05/12 Time sent . . . . . . : 09:48:45

    Message . . . . : Identifier LEFT preceeding ' OUTER JOI' follows proper SQL
    A valid SQL statement could be interpreted from the string you provided if
    Identifier LEFT and all subsequent characters (' OUTER JOI'...) were to be
    ignored. Change the statement and try again. If you are using *SEQUEL
    object authority checking, the problem may be caused by unsupported usage of
    runtime variables.

    Has anyone else encountered this?