AIX | HP-UX | Linux | OS/2 | OS/390 | OS/400 | PTX | SUN | Win NT |
X | X | X | X |
| X | X | X | X |
Purpose
Provides access to protected data by passing a user ID to the database language environment. Use this variable with PASSWORD to incorporate the security algorithms of DB2.
OS/400 Users: OS/400 ignores both LOGIN and PASSWORD if the DATABASE variable is not defined or if it is set to a value of "*LOCAL". Database access is routed through the user profile under which Net.Data is running.
Security tip: While you can code this value in the Net.Data macro, it is preferable to have the application user enter user IDs in an HTML form. Additionally, using the default value of the Web server ID provides a level of access that might not meet your security needs.
Specify the value of this variable using a DEFINE statement or with the @DTW_ASSIGN() function.
Values
LOGIN="database_user_id"
Values | Description |
---|---|
database_user_id | A valid database user ID. The default is to use the user ID that started the Web server. |
Examples
Example 1: Restricting access to the user ID, DB2USER
%DEFINE LOGIN="DB2USER"
Example 2: Using an HTML form input line
USERID: <input type="text" name="login" size=6 />
This example shows a line you can include as part of an HTML form for application users to enter their user IDs.