Syntax for identifiers in ij commands Syntax Identifier [ @ connectionName ]
Description

Some ij commands require identifiers. These ij identifiers are case-insensitive. They must begin with a letter in the range A-Z, and can consist of any number of letters in the range A-Z, digits in the range 0-9, and underscore (_) characters.

An identifier can optionally use an at sign (@) followed by a connectionName. Spaces on either side of the @ sign are optional. If you specify a connectionName, you can refer to databases on different connections. This capability enables you to perform tasks such as copying data from one database to another. For an example of copying data between databases, see . For other examples, see , , and .

These identifiers exist within the scope of ij only and are distinct from any identifiers used in SQL commands, except in the case of the Get Cursor command. The Get Cursor command specifies a cursor name to use in creating a result set.

ij does not recognize or permit delimited identifiers in ij commands. They can be used in SQL commands.

Example These are valid ij identifiers: foo1 exampleIdentifier12345 another_one myId@connection0 id2 @ connection1