Environment & System Variables - Embedding Parameters in SQL Code

Using System Variables in SQL Code

The following example (see figure below) illustrates the use of System Variables in SQL code. The first System Variable in this example is surrounded by single upper quotes to be returned as a string from a SELECT statement. The second System Variable is used to call a stored procedure using a fully qualified object name.

Figure 102.16a:  Example of using System Variables in SQL code.

© 2001-2018 JNetDirect, Inc. All Rights Reserved.