Move your mouse round the image for details.

This Meta-Update script makes a CSV from an SQL Query on arschema and adds a few count columns for records and workflow elements.

[Main] declares script arguments and usage.

[Do]'s AssignInit will build a SQL where clause if -ptn was used. [Do] will then issue QuerySql= iteration statement.

Rather than use $Tbl, 1$ like Remedy, we will interpret columns into fields defined by [AsSchV].

The Output= makes a new row in an output file defined by [F-out] using the assignments in [asg-CsvRow].

Usage examples:

ArSchema.ini   Do
	-fout arschema.dev.csv
ArSchema.ini   Do
	-ptn  HPD:%
	-fout dev-HPD-tables.csv

Move your mouse round the image for details.

All Meta-Update Sample Scripts have plenty of comments. Feel free to edit. Use the debugger to single-step through the scripts.

[Main] is used to describe arguments, set up server connections, do initial and terminating assignments, and give usage information.

Here, we have one required argument and one optional argument: -fout, and -ptn.

-ptn, if used, will generate a where clause for [Do]'s QuerySql.

-fout is used on [Do]'s Output= to specify the file name to open.

Interestingly, [Do]'s AssignInit could be be moved to [Main] and have the same effect.

Move your mouse round the image for details.

All Meta-Update Sample Scripts have plenty of comments. Please feel; free to take a copy and edit. Use the debugger to single-step through the scripts.

[Main] is used to describe arguments, set up server connections, have initial and terminating assignments, and give usage information.

Here we have one required argument and one optional argument: -fout and -ptn.

The AssignInit could be either here in [Main] or in [Do] below.

Do's AssignInit sets up a where clause if the argument -ptn was used.

It then issues a QuerySql containing a reference after the "from arschema" that evaluates to nothing or to a like exporession.

Move your mouse round the image for details.

[Do] uses a QuerySql that specifies a Field section so that

• References like $Tbl, name$ can be used instead of $Tbl, 1, and
Field Value transformations can be applied to the SQL data.

For example, the SQL field time, corresponding to the select's timestamp column, is converted from an integer to a date.

With each iteration, we Launch another section [Do-File] to output the file.

Move your mouse round the image for details.

[Do] AssignInit=

Before [Do] starts, all AssignInit sections are processed.

We set a reference variable to either one of

• $ENV, Path$, or,
• use @val to extract the environment variable specified as the argument $Arg, var$ —a double reference.

Note: This AssignInit could be moved to [Main]. An AssignInit can be used repeatedly if a section is Launched repeatedly.

[ Do x6 ]

[ Do ] is a Control Section in this case iterating through a list of semi-colon separated strings.