Prevent Access to System Request Menu

May 18, 2005 Shannon O'Donnell

The code for this article is available for download.

I was looking over the back issues of Four Hundred Guru recently and came across a tip by Ted Holt on preventing access to the System Request Menu. In that tip, a reader asked how to prevent his users from gaining access to the System Request Menu and inadvertently logging off the system before his cleanup code executed. Ted’s response was to monitor for the system message ID CPF1907, which is fired when the user attempts to bring up the System Request Menu. I have another solution that might appeal

Use SQL to Send Database Files via FTP

May 18, 2005 Hey, David

I am looking for a way to send a native iSeries database file to a Unix system. The file needs to be sent in tab-delimited format. The end of line delimiter is variable (potentially different for each target system, which I already have defined in a file.) I need to take the output file and FTP it back to the Unix server. By default, when I FTP a (flat) file from the iSeries to a Unix box in ASCII mode, FTP adds CR/LF to the end of the record. I can use Copy To Import File (CPYTOIMPF) to create a

Admin Alert: Configuring an i5/OS-based EIM Table for Single Sign-On

May 18, 2005 Joe Hertvik

In previous columns, I introduced several concepts and configurations for enabling IBM‘s Single Sign-On (SSO) technology, in which Windows domain users access a Kerberos server to automatically authenticate and authorize themselves to use i5/OS applications without entering an OS/400 user profile and password. While previous articles focused on network configuration, this week I’ll look at how you create and use an Enterprise Identity Mapping (EIM) domain to tell Kerberos which i5/OS user profiles to use to automatically sign a user on to an i5 or iSeries partition.

Please note that this article is the next installment of a group