• Sequel Sign on

    The connection method for Sequel ViewPoint is determined by the connection settings configured in IBM Client Access.  Review the connection properties on your pc client by right clicking on the iSeries system name in the client access navigator window and selecting properties.  In the properties section, there is a connection tab that is used to specify how user connections are established from the PC.  Sequel ViewPoint uses the same configuration settings.

    Originally Posted By richg

  • Are you looking to export it

    Are you looking to export it in this format, like a .csv format?

    Originally Posted By jdaugherty

  • Hi there, Yes. This is

    Hi there,

    Yes. This is definitely a possibility, most likely using our dashboard object.

    Please contact SEQUEL support, at 952-933-0609, or [email protected] or chat in for more information...

    Thanks

    Originally Posted By jdaugherty

  • Hi there~ Yes this is

    Hi there~

    Yes this is possible.

    Easiest way is using the SPLIT function:

    Here is an example you can plug into your SQL statement:

     

     SELECT       'Jackie Daugherty' NAME(myname), Split(myname, " ") NAME(first) LEN(15), Split(myname, " ", 2) NAME(last) LEN(25)
     FROM          sqlexec
     

    Originally Posted By jdaugherty

  • Hi there~~ Best thing to do,

    Hi there~~

    Best thing to do, would be to call, email or chat in on this problem, so we can look at your specific data more closely.

    Phone: 952-933-0609

    Email: [email protected]

    Chat available on our Web site at www.sequel-software.com

     

    Thanks!

    Originally Posted By jdaugherty

  • Hi there, You can do this

    Hi there,

    You can do this using the SPLIT function:

    SPLIT

    Extract delimited values from a string

     

    SPLIT(charexp, charexp, int) or (charexp, charexp)

     

    This example view:

    SELECT TRIM(cname) NAME(str),

    split(str," ") LEN(15) COLHDG("First" "name"),

    split(str," ",2) LEN(15) COLHDG("Second" "name"),

    split(str," ",3) LEN(15) COLHDG("Third" "name")

    FROM sequelex/custmast

     

    Will produce the following:

    First Second Third

    STR name name name

    NBCO Corporation Inc. NBCO Corporation Inc.

    Obell Group Sales Obell Group Sales

    PCE Corp. PCE Corp. n/a

    UCE Corp. UCE Corp. n/a

    Xcme Corp. Xcme Corp. n/a

    State Corp. State Corp. n/a

    Lim-Equipment Co. Lim-Equipment Co. n/a

    Please let us know if you need anything else!

    Jackie Daugherty

    Originally Posted By jdaugherty

  • Hi there! Make sure in your

    Hi there!

    Make sure in your script you have your SETVAR (see below) setup. It should be setup the same way as the variable in the view.

    If you are using a multiselect, you need to also select quote values in the variable tab of the script.

    Please let me know if you need more information...

     

    Thanks

    Jackie Daugherty

    Technical Consultant

     

    Placing Variables in a Script

    Variables can be used in a script in many different ways to provide user input for almost anything. When placing a variable in a script, the variable name must be proceeded by an ampersand(&).The variable can be the same name as the view variable or be unique. Once a variable is placed in the script, it must be defined before the script can be run.

    Below are some example script lines that show three areas where variables are most commonly used: SETVAR, SQL and Command Parameters.

    Each of the examples is followed by some general rules or guidelines for the syntax of the variable. These are not ‘hard and fast’ rules. There are many ways syntactically to use the variable, but these guidelines will help to avoid errors in most cases.

     

    SETVAR

    A very powerful use of variables is the ability to pass user input into a Sequel view using the Set Variable (SETVAR) parameter. Most Sequel commands that generate output (Display, Execute, Print, Report, etc.), have a SETVAR parameter for this purpose.

    The SETVAR parameter will contain pairs of variables. The first variable in the pair is a variable defined in the view – the variable user input will be passed to. The second variable is the variable defined in the script – the value that will set the view variable. For example, &TEXT is the view variable and &EXPR is the script variable.

    DISPLAY VIEW(SEQUELEX/CUSTLISTX2) SETVAR((&TEXT '&&EXPR') (&FILE '&&NAME')

    (&CUSNO '&&NMBR') (&CSTTE '&&QSTNG') (&DTE '&&DTE'))

     

    The SETVAR above has five pairs of variables. Each represents the five different prompt types. Quoted String and Number type prompts are used most often to pass input to the WHERE clause of the view for record selection purposes.

    As a general rule, it is best to use single-quotes around the variable in case the value has spaces or punctuation, inside the SETVAR parameter. When a script variable is enclosed in quotes, two ampersands(&&) are required to ensure substitution.

    Originally Posted By jdaugherty

  • You should be able to just

    You should be able to just subtract the two timestamp fields from each other.

     

    Timestamp Field 1-Timestamp Field 2

    Originally Posted By jdaugherty

  • SQL Server and Timestamp

    Hi there,

    We would need a joblog to assist with the SQL Server question. You can email that to [email protected].

    As far as the timestamp question is concerned, if you perform the DATE function on the timestamp field, you will end up pulling the date out of the timestamp. You may need to do further formatting once that is done if the date is not in the format you need. DATE(field) --- field is your timestamp field.

    Feel free to respond to this forum or contact us at [email protected]

    Thanks

    Originally Posted By jdaugherty

  • Hi Joe, Hopefully I am not

    Hi Joe,

    Hopefully I am not oversimplifying this, but you can right click on your connection and there should be a choice of different "lists" of libraries you can choose to load.

    Let me know if you need further help,

    Thanks,
    Jackie Daugherty

    Technical Consultant

    Originally Posted By jdaugherty