TMI Script


This task allows Dex to call out to TMI scripts. TMI is a programming language specifically designed and developed for manipulating the Dex data stream.


OPTION DESCRIPTION
TMI Script The TMI Script to be run.
Load Load a TMI script from disk.
Save Save a TMI script to disk.

INPUT

There are no special input requirements, however, the script itself may have dependencies.

OUTPUT

At the end of execution, whatever the TMI table value "dex" becomes, is returned as the Dex output data stream after having executed the TMI script.

EXAMPLES

The best way to learn TMI quickly is by example. Since TMI is a synthesis of SQL, Perl, with some intrinsically supported CSV/table operations, manipulating Dex data within TMI is a snap.

Creating a Dataset

dex = [ [ NAME, AGE ] [["Bob", 39],["Sally", "22"]]];

Creates the Dex output datastream represented by the table:

NAME AGE
Bob 39
Sally 22

Selecting From A Dataset

Given a table named T1:

NAME AGE GENDER
Bob 39 Male
Sally 22 Female
Pat 45 Male
Jan 49 Female
Select only Name and age
T2 = select NAME, AGE from T1;
Setting the Dex Data Stream

Any assignment to "dex" will be reflected in the data output stream.

dex = T2;

Will send the results from the previous example to the Dex data output stream.

Returning only Males
dex = select NAME, AGE from dex where GENDER == "Male";

results matching ""

    No results matching ""