• DAYOF WEEK

    richg,

     I’ll get all this terminology down one day, I'm just grateful for people like yourself to lean a hand.

     

     

     

     

    Originally Posted By Liz Williams

  • test reply

    This is just a test reply

    Originally Posted By jdaugherty

  • Date Range in Report Heading

    I assume these data ranges are from variables to prompt the user for the beginning and ending date values.  To place these on the report, you first need to add the variables as new columns in the view.  So right clicking on a new column, you would choose Expression Editor.  Place your first variable in the window (i.e.: "&&BEGIN") and then give that column a name.  Do the same thing in another column for the other variable and give that column a name.   Then in the Report tab,  you can slide those new fields on the report anywhere you want to see them.

    David Gilson

    Research Technical Consultant

    SEQUEL Software

    A Help/Systems Company

    Phone:  (952)-933-0609

    [email protected]

    www.sequel-software.com

     

    Originally Posted By Daveg

  • Pass CL parameter to view

    there are a couple of ways of doing this. Either use a SEQUEL script which I likethe most because it has more capabilities.

     

    for the CL, I am not sure which command you are using to run your view. But if you use the EXECUTE command you can scroll down to the "Set Variables" parameter

    variable name is the variable in your view

    variable value is the variable in your CL

    hope this helps.

     

    Ron

    Originally Posted By huskerron

  • Single Record Display

    When a view displays a single record, the defualt is to still show the columns of data horizontally.  You need to double click on the reord to get the display to show the fields.columns stacked vertically.  Double clicking places them back horizontally.  There is not a Viewpoint Defautl setting to allow you to change the single record display default.

    David Gilson

    Research Technical Consultant

    SEQUEL Software

    A Help/Systems Company

    Phone:  (952)-933-0609

    [email protected]

    www.sequel-software.com

     

    Originally Posted By Daveg

  • Cursor substitute.

     

    Derek,
      Here is what I did.  I pulled all of the records from the base table that I needed with an ACCUM field.  This gave me a distinct value that I could reference for each line.  I then did a while loop that incremented each time to allow me to reference the next value.
     
    DCL VAR(&OUTPUT) TYPE(*CHAR) LEN(30)
    CHGVAR VAR(&OUTPUT) VALUE("QTEMP/CHILDREN") /* CHANGE this to the Output File name */
    DCL VAR(&PARTLVL) TYPE(*DEC) LEN(3 0)
    DCL VAR(&CHILDCNT) TYPE(*DEC) LEN(5 0)
    DCL VAR(&CURRCNT) TYPE(*DEC) LEN(5 0)
    DCL VAR(&PRNTSEQ) TYPE(*CHAR) LEN(30)
    CHGVAR VAR(&CHILDCNT) VALUESQL('SELECT char(Count(1)) FROM rmsfiles#/pspsp100(m015) where parnt ="&&UPLVL"')
    CHGVAR VAR(&PARTLVL) VALUE(1)
    IF COND(&childcnt >0)
    EXECUTE SQL('SELECT "&&UPLVL" name(UPLVL),parnt, digits(cseqn) len(20) name(seqno), accum(1,parnt) len(5,0) name(ord), child, psreq FROM rmsfiles#/pspsp100(m015) where parnt ="&&UPLVL"') OUTFILE(&OUTPUT) REPLACE(*YES)
    DOWHILE COND(&CHILDCNT>=&partlvl)
    /* Enter your commands here */
    CHGVAR VAR(&PARTLVL) VALUE(&partlvl+1)
    ENDDO
    ENDIF
     
    I hope this helps.  Please contact me with questions.
    jpyatt at flowserve.com

    Originally Posted By jpyatt

  • 1. I use the following

    1. I use the following command to create a file.

    SEQUEL/DSPVIEWD VIEW(your_library/*ALL) ATTRIB(*ALL) TYPE(*SQL) OUTPUT(*OUTFILE) OUTFILE(your_library/afilename)                                       

     

    2. Create a view over the new file you created.  The field called SQL is sequel statement for a view. 

    Your Where clause would look something like this...

    Where SQL contains 'file name your searching for"... etc.  

     

    Originally Posted By [email protected]

  • Excel Headers

    Hi there,

    In SEQUEL ViewPoint, on the Files and Fields tab, you see all of your fields listed. There is a section there in each field column called Header 1, 2 and 3. There you can type in whatever you want for your header when it comes over into Excel, or you could blank it out as well. Hope that helps!

     

     

    Jackie Daugherty

    Technical Consultant

    SEQUEL Software - A Help/Systems Company

    Phone: 952.933.0609

    Fax: 847.273.1050

     

    Originally Posted By jdaugherty

  • Script within a Script

    Hi there,

    Yes this is possible to do. We would need your script print definition(s) to troubleshoot further.

    You can email them to [email protected], and we would be happy to help you with this question.

    Thanks

    Originally Posted By jdaugherty

  • Check the authority on the

    Check the authority on the iSeries on SEQUEL. *Public requires *RWX.

    Originally Posted By jdaugherty