Actian X 11.1 | Using Tab or Newline

Was this helpful?

Using Tab or Newline

If you want to insert a real tab or newline, use \t for tab or \n for newline.

For example, the "sel" macro reads a string and uses the "get" macro to substitute the word SELECT for get.

The resulting string is used with the "sel" parameter "n", which is the name of a table, as follows:

{define;get;SELECT}\eval

{define;sel $n\n; \

get table_name FROM iitables WHERE \

table_name LIKE '$n'}\eval

To get all tables_name in iitables with a name that includes "index":

sel ‘%index%'\g

Last modified date: 11/09/2022