-
RE: Sequel Scripts: Close & Reprompt available?
If you wish to create a prompted script that can be reprompted.  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
  <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.  For complete information about Sequel Auditing, see the attached Sequel manual that describes the green screen interface.  Sequel Auditing interface is also available with the ViewPoint client.  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>