UPCASE (JANUS DEFINE parameter): Difference between revisions
m (1 revision) |
m (remove displaytitle) |
||
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
<span class="pageSubtitle">Convert client "names" to uppercase</span> | |||
<span class="pageSubtitle" | |||
<var>UPCASE</var> is a parameter on <var>[[JANUS DEFINE]]</var>, which defines and sets characteristics of a Janus port. | <var>UPCASE</var> is a parameter on <var>[[JANUS DEFINE]]</var>, which defines and sets characteristics of a Janus port. | ||
| Line 8: | Line 7: | ||
Note that it is possible to have lower case userids and passwords in <var class="product">Model 204</var>. For example, the userids <code>HOMER</code>, <code>homer</code>, and <code>Homer</code> would be treated as three separate userids by <var class="product">Model 204</var>. The <var>UPCASE</var> parameter simplifies the interaction between clients (where names tend to be in lowercase) and <var class="product">Model 204</var> (where they tend to be in uppercase). | Note that it is possible to have lower case userids and passwords in <var class="product">Model 204</var>. For example, the userids <code>HOMER</code>, <code>homer</code>, and <code>Homer</code> would be treated as three separate userids by <var class="product">Model 204</var>. The <var>UPCASE</var> parameter simplifies the interaction between clients (where names tend to be in lowercase) and <var class="product">Model 204</var> (where they tend to be in uppercase). | ||
'''Note:''' The <var>UPCASE</var> parameter never results in data being converted to uppercase. That is, if a client sends variable <code>@customer</code> with a value of <code>Dolly Dinkle</code>, and <var>UPCASE</var> is active for the connection, the <var class="product">User Language</var> application would see a variable called <code>@CUSTOMER</code> with a value of <code>Dolly Dinkle</code>. | <p class="note">'''Note:''' The <var>UPCASE</var> parameter never results in data being converted to uppercase. That is, if a client sends variable <code>@customer</code> with a value of <code>Dolly Dinkle</code>, and <var>UPCASE</var> is active for the connection, the <var class="product">User Language</var> application would see a variable called <code>@CUSTOMER</code> with a value of <code>Dolly Dinkle</code>. </p> | ||
For <var>[[JANUS DEFINE#type|SDS]]</var> ports, the <var>UPCASE</var> parameter means that all table and column names passed from the Adaptive Server will be converted to uppercase. This means that when defining the columns and tables (using <var>[[JANCAT (JANUS DEFINE parameter)|JANCAT]]</var>), the names must all be uppercase. It also means that if an <var>SDS</var> port has the <var>UPCASE</var> parameter set but has mixed case table and column names, those tables and columns will be inaccessible. | For <var>[[JANUS DEFINE#type|SDS]]</var> ports, the <var>UPCASE</var> parameter means that all table and column names passed from the Adaptive Server will be converted to uppercase. This means that when defining the columns and tables (using <var>[[JANCAT (JANUS DEFINE parameter)|JANCAT]]</var>), the names must all be uppercase. It also means that if an <var>SDS</var> port has the <var>UPCASE</var> parameter set but has mixed case table and column names, those tables and columns will be inaccessible. | ||
Latest revision as of 17:51, 27 January 2016
Convert client "names" to uppercase
UPCASE is a parameter on JANUS DEFINE, which defines and sets characteristics of a Janus port.
This parameter indicates that all client "names" are to be converted to upper case. "Names" includes userids and passwords, variable names for OPENSERV ports, column names for SDS ports and header parameters, header values, cookie names, and form field names for WEBSERV ports. By setting UPCASE as a port parameter, the userid and password can be specified by the client in case insensitive form, that is, it can be specified in lower case.
Note that it is possible to have lower case userids and passwords in Model 204. For example, the userids HOMER, homer, and Homer would be treated as three separate userids by Model 204. The UPCASE parameter simplifies the interaction between clients (where names tend to be in lowercase) and Model 204 (where they tend to be in uppercase).
Note: The UPCASE parameter never results in data being converted to uppercase. That is, if a client sends variable @customer with a value of Dolly Dinkle, and UPCASE is active for the connection, the User Language application would see a variable called @CUSTOMER with a value of Dolly Dinkle.
For SDS ports, the UPCASE parameter means that all table and column names passed from the Adaptive Server will be converted to uppercase. This means that when defining the columns and tables (using JANCAT), the names must all be uppercase. It also means that if an SDS port has the UPCASE parameter set but has mixed case table and column names, those tables and columns will be inaccessible.
The UPCASE parameter is the opposite of NOUPCASE. The default is for all ports to have UPCASE set.
Valid for WEBSERV, OPENSERV and SDS port types.