Abstract: A method and system for servicing a data query in a relational database management system (RDBMS). Access path security corresponding to a user originating the data query is configured. The data query requests data from the RDBMS pursuant to a received configuration query associated with the user. The data query requests a value stored in a result field by specifying the result field and a result table of a database in the RDBMS. The configuration query specifies a usable index field associated with the result table. The access path security mandates the user to provide a search key in the data query in searching the result table. The search key includes a name identical to the usable index field specified in the configuration query such that the access path security enables users to search the result table only when the users specify the usable index field in the data query.

Abstract: In an approach for limiting mass deletions from database tables, a computer receives a deletion request corresponding to data in a database table. The computer determines whether the database table includes a restriction of a mass deletion. Responsive to determining the database table includes a restriction of a mass deletion of data from a database table, the computer determines whether the quantity of data in the deletion request exceeds the restriction of a mass deletion. Responsive to determining the quantity of data in the deletion request exceeds the restriction of a mass deletion, the computer prevents execution of the deletion request.

Abstract: A system and associated method for improving efficiency and data security of a relational database management system (RDBMS). Access path security is configured for respective users of the RDBMS, having either access-by-key or access-by-scan value. The access-by-key access path security requires an end user to specify a search key in a query as configured for the end user to service the query. Only few users with administrative capacity are configured with the access-by-scan access path security, which permits servicing queries in conventional ways without screening queries by scanning database. The RDBMS calculates the most efficient access path for the query received from the end user, and retrieves data requested by the query only when the calculated access path is permitted by the access path security for the end user.

Abstract: A system and associated method for improving efficiency and data security of a relational database management system (RDBMS). Access path security is configured for respective users of the RDBMS, having either access-by-key or access-by-scan value. The access-by-key access path security requires an end user to specify a search key in a query as configured for the end user to service the query. Only few users with administrative capacity are configured with the access-by-scan access path security, which permits servicing queries in conventional ways without screening queries by scanning database. The RDBMS calculates the most efficient access path for the query received from the end user, and retrieves data requested by the query only when the calculated access path is permitted by the access path security for the end user.

Abstract: An enhancement and preprocessor to native file tailoring functions such as ISPF's File Tailor utilities. A set of control parameters and input data is processed according to specified options to prepare one or more tables of data compatible with the native file tailoring functions, and the native file tailoring functions are called one or more times to achieve the desired tailored files. Use of the invention obviates the need for custom programming or manual file editing to format source data into one or more tables which are compatible with the input requirements of the native file tailoring functions.

Abstract: A system and method for testing and promoting database update code is presented. A programmer uses a SPUFI machine that enables him to test SPUFI code on error prone data that is copied from a customer's actual database. The SPUFI machine sends an access request to the customer prior to copying the actual database. Once the programmer has the SPUFI code working properly, the SPUFI machine sends the SPUFI code to a staging area. The staging area does not allow code changes prior to executing the SPUFI code on the customer's actual database. The customer is informed whether the SPUFI code corrects the actual database.

Abstract: An enhancement and preprocessor to native file tailoring functions such as ISPF's File Tailor utilities. A set of control parameters and input data is processed according to specified options to prepare one or more tables of data compatible with the native file tailoring functions, and the native file tailoring functions are called one or more times to achieve the desired tailored files. Use of the invention obviates the need for custom programming or manual file editing to format source data into one or more tables which are compatible with the input requirements of the native file tailoring functions.