• RE: Sequel Scripts: Close & Reprompt available?

    If you wish to create a prompted script that can be reprompted.&#160; Consider using a SCRIPTVIEW.<br> <br> See page-385 if the ViewPoint user guide installed in the /sequel viewpoint directory on your pc.<br> <br> Script Views<br> By combining the multi-step processing power of a standard script with the output flexibility of a<br> Sequel View, a script view can run almost any multi-step process behind the scenes, and provide<br> single-click output to display, print, create files and more. (In standard script you have to hard<br> code the output using a command at the end of the script like DISPLAY, PRINT, EXECUTE, and so<br> on)<br> Using the new command SCRETURN as the final statement, a script view will return a single, final<br> result set of data—just like a view. Because a script view ‘acts’ like a view, you can direct its<br> output from the Viewpoint Explorer with the same ease that you can with a Sequel view. Rightclick<br> a script view and select display or print, create IBM i or remote database tables, save PC<br> results locally or on the IFS and more. This gives your scripts a level of flexibility they never had<br> before.<br> In addition to the output options above, you can:<br> l Easily join data from across multiple supported databases to bring all of your enterprise<br> data together in one object.<br> l Add a script view to a Dashboard and it acts like a view by displaying the results—even<br> after processing multiple steps or joining across databases like a script.<br> l Add powerful presentation capabilities to results by designing host or client reports over a<br> script view.<br> l View script output in Sequel Web Interface just as you would a view.
  • RE: How to set the FROM TO Email address on the Sequel EXECUTE command

    &#160; <table cellpadding=4 cellspacing=2 height="100%" width="100%"> <tbody> <tr> <td>Where does ESEND get the from address when sending emails?</td> </tr> <tr> <td></td> </tr> <tr> <td>Summary</td> </tr> <tr> <td><br> Subject:<br> Where does ESEND get the 'from' address when sending emails?<br> <br> <br> Solution:<br> ESEND uses several sources for deriving this 'From' or return address for the messages it sends; it always searches these sources in the order discussed below.<br> 1 - Data area named ESNDADTA in QTEMP.<br> 2 - ESEND address database maintained using the ESNDADR command.<br> 3 - System Alias Table<br> 4 - Derived by concatenating the USER ID with the system Domain Name entered in the TCP/IP configuration.<br> <br> Note:<br> For further information, see Appendix C (Defining the 'Return' Address) in the ESEND User Guide.<br> The file that is used for the ESNDADR command is: ESNDADRP in ESEND</td> </tr> </tbody> </table>
  • RE: Want to know the significance of the command SEQUEL/SETAUDDFT (Work with Audit profiles)

    The SETAUDDFT command is used with Sequel Auditing function.&#160; For complete information about Sequel Auditing, see the attached Sequel manual that describes the green screen interface.&#160; Sequel Auditing interface is also available with the ViewPoint client.&#160; And a discussion about Sequel auditing can be found in the ViewPoint Administrator Guide (available in the manuals section of this portal).<br> If you have any additional questions about Sequel products, please call support at 952-933-0609, or send us an email at: [email protected]<br> <br> See Chapter-6 of the attached user guide.<br> <br> SETAUDDFT (Set Audit Default) Command<br> The Set Audit Default (SETAUDDFT) command gives you an easy way to view and<br> modify the audit switch for SEQUEL users. Through an interactive program, you can<br> review and change the setting for each user. It also gives you an easy way to set the<br> switch for all users on or off. You can also use the Set Default (SETDFT) command to<br> change a user’s switch value, but you will probably prefer to use the displays described<br> below.<br> The SETAUDDFT command can be run from command entry or by selecting option 3<br> from the audit menu. The command has no parameters. Because it invokes an<br> interactive program, it cannot be run in a batch environment.<br> When the command is run, a display similar to the one below will appear. It shows the<br> auditing status for each SEQUEL
  • RE: Sequel Viewpoint 11 Query Halting

    Hi Zach,<br> When ViewPoint is installed, there should be a ViewPoint icon in the System tray.<br> This icon appears after a ViewPoint job is started and can be used to end IBIi server jobs that are active for the session.<br> <br> Also, if end user has Administrator Module installed, it can be selected from the TOOLS menu, and there is an option to work with ViewPoint active jobs in that mode.<br> <br> See attached image for system tray icon.<br> <br> Regards,<br> Rich Galeba<br> <br> <br> &nbsp;