Ww:Rename SQL implementation name: Difference between revisions

From Remain Software
Jump to navigation Jump to search
No edit summary
No edit summary
(No difference)

Revision as of 05:51, 24 July 2025

Back.gif

Rename SQL implementation name (RNMSQLIMPN)

This command is used to rename an object's system-assigned name to a custom user-defined name. It is typically used when the original object name exceeds 10 characters. In such cases, the system assigns a shortened internal name, and this command allows the user to replace it with a more meaningful, custom name. This command can be used both from the command line and within SQL scripts.

Long object code

Specify the long object name.

character value
Enter a long object code.

Object library

Specify the library of object.

*LIBL
Use this value to rename the object mentioned in the Long Object name field within the current library list.
character value
Enter the library of the object mentioned in the Long object name field.

Object type

Specify the type of object.

character value
Enter the type of the object of which system generated name is to be renamed.

New Object code

Specify the New object code.

character value
Enter the new object code to be used for renaming the system-generated name of the object mentioned in the Long Object Name field.

Prerequisite for using RNMSQLIMPM in an SQL script

In order to use it in an SQL script, use the default CREATE command as below:

CRTPFSQL.png

The Create command can be configured using the Command Start Type Maintenance (STRTCM).

Example to use in Sql script

RNMSQLIMPN.png