Dismiss
InnovationQ will be updated on Sunday, Oct. 22, from 10am ET - noon. You may experience brief service interruptions during that time.
Browse Prior Art Database

SQLUSER Environment Parameter

IP.com Disclosure Number: IPCOM000034847D
Original Publication Date: 1989-Apr-01
Included in the Prior Art Database: 2005-Jan-27
Document File: 1 page(s) / 12K

Publishing Venue

IBM

Related People

Buquoi, GH: AUTHOR [+4]

Abstract

A method is described which enables a Database Manager function to override an OS/2 environment parameter. The authorization parameter, SQLUSER, is defined for the Database Manager via the OS/2 Environment Parameters. OS/2 allows for the definition of an Environment Parameter, however, neither OS/2 or the C Language allow enough flexibility in updating this parameter from a program. OS/2 provides a SET command to establish the Environment Parameter. This command must be issued from the OS/2 Command Line and cannot be issued inside an application program. An application can determine the current setting of an Environment Parameter via the DOSSCANENV function call.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 59% of the total text.

Page 1 of 1

SQLUSER Environment Parameter

A method is described which enables a Database Manager function to override an OS/2 environment parameter. The authorization parameter, SQLUSER, is defined for the Database Manager via the OS/2 Environment Parameters. OS/2 allows for the definition of an Environment Parameter, however, neither OS/2 or the C Language allow enough flexibility in updating this parameter from a program. OS/2 provides a SET command to establish the Environment Parameter. This command must be issued from the OS/2 Command Line and cannot be issued inside an application program. An application can determine the current setting of an Environment Parameter via the DOSSCANENV function call. The C Language has commands which can be used for retrieving the current value and setting a new value for an Environment Parameter, but the way in which these commands are used is restricted. The C Language GETENV and PUTENV commands use a memory address from the last time one of these functions is called.

If these commands are not issued within the same routine, then the address of the previous GETENV or PUTENV may no longer be a valid memory location. C does not change the original OS/2 Environment Parameter, but simply overrides the OS/2 definition in another area of memory. This memory is not located at a permanent shared address. With the new method, the Database Manager provides two new internal functions, PUT AUTHID and GET AUTHID. It defines a global memory area whi...