• Schedule VPCLEANUP

    VPCLEANUP is a SEQUEL script so can be run from a job scheduler by doing:

    SEQUEL/RUNSCRIPT SCRIPT(SEQUEL/VPCLEANUP)

    Originally Posted By squinlan

  • Schedule VPCLEANUP

    VPCLEANUP is a SEQUEL script so can be run from a job scheduler by doing:

    SEQUEL/RUNSCRIPT SCRIPT(SEQUEL/VPCLEANUP)

    Originally Posted By squinlan

  • Enhanced VPCLEANUP

    VPCLEANUP now prompts for the number of days or the number of hours old or older for the Viewpoint jobs that you want to end.

    To run without prompting (as in a scheduled job) , use the following syntax:

    RUNSCRIPT SCRIPT(SEQUEL/VPCLEANUP) SETVAR((&DAYS 1)(&TIME 0))

    This will end all ViewPoint jobs that are 1 day old or older.

    RUNSCRIPT SCRIPT(SEQUEL/VPCLEANUP) SETVAR((&DAYS 0)(&TIME 0))

    This will end all ViewPoint jobs, regardless of age.

    Originally Posted By Danc

  • Delimiter

    Yes, you need to issue the command WRKPCFMT and add a new delimited format.

    The settings are:

    Text __________________________ (give this new format a name)

    Delimiter:  (type in the pipe character here)

    String start: *NONE

    String end: *NONE

    Record end: x '0D0A'      (those are zeroes)

    Heading record:  *NONE

    Numeric edit: *NUMBER

    Originally Posted By jdaugherty

  • Hi there Vern,   If you give

    Hi there Vern,

     

    If you give the application an explicit link and make sure to name your option files, this should give you what you need...

    Thanks

    Originally Posted By jdaugherty

  • omit leading/trailing text

    When you use *all in variable definitions you have eliminate the exist IN code ("r427c in(&cls)").  To do this use the omit leading text and omit trailing text fields of the variable in the view.  So for you the omit leading text line would look like "r427c in (" and the omit trailing text would be just the closing ).

    Originally Posted By jpyatt

  • Hi there, You can simply use

    Hi there,

    You can simply use this for year and month:

    YEAR(CURRENT DATE -1 DAY)

    MONTH(CURRENT DATE -1 DAY)

    Let us know if you need anything else~~

     

    Jackie Daugherty

    Technical Consultant

    SEQUEL Software

    Originally Posted By jdaugherty

  • Thanks

    Thanks Jackie for your response.

    This did not work. The reason is I am using a Oracle table in the sequel view.I tried TO_CHAR funtion and it worked.

    Thanks again!

    Originally Posted By aag

  • I ended up taking a different approach

    I actually decided that if I couldn't get the variables to function like I wanted, I would setup a prompted view that would build the variables and place them into a physical file on the as400.

    After dooing this, I setup the script to default the variables from the physical file and not prompt them at that point. By doing this, I was able to get both the date range and substitutable variables into my script so that it would run correctly.

    Originally Posted By jec031360

  • Date in File Name

    It is possible to declare a variable as part of a save file name in the TOSTMF parameter of the EXECUTE command.  When using the command in a Script, that variable can also be set up as a "NO PROMPT" variable, so the user does not see the prompt value when the script runs.  The prompt can then be substituted with a special system value of current date.  The date is returned without separators, which omits the slash problem. See the help text for no prompt variables or give support a call to discuss the process.

    Originally Posted By richg