[attr := ] OUTPUT(recordset, [ format ] ,file ,JSON [ (jsonoptions) ] [,ENCRYPT( key ) ] [, CLUSTER( target ) ] [, OVERWRITE ][, UPDATE] [, EXPIRE( [ days ] ) ] )
| CLUSTER | Optional. Specifies writing the file to the specified list of target clusters. If omitted, the file is written to the cluster on which the workunit executes. The number of physical file parts written to disk is always determined by the number of nodes in the cluster on which the workunit executes, regardless of the number of nodes on the target cluster(s). |
| target | A comma-delimited list of string constants containing the names of the clusters to write the file to. The names must be listed as they appear on the ECL Watch Activity page or returned by the Std.System.Thorlib.Group() function, optionally with square brackets containing a comma-delimited list of node-numbers (1-based) and/or ranges (specified with a dash, as in n-m) to indicate the specific set of nodes to write to. |
| ENCRYPT | Optional. Specifies writing the file to disk using both 256-bit AES encryption and LZW compression. |
| key | A string constant containing the encryption key to use to encrypt the data. |
| OVERWRITE | Optional. Specifies overwriting the file if it already exists. |
| UPDATE | Specifies that the file should be rewritten only if the code or input data has changed. |
| EXPIRE | Optional. Specifies the file is a temporary file that may be automatically deleted after the specified number of days. |
| days | Optional. The number of days after which the file may be automatically deleted. If omitted, the default is seven (7). |
This form writes the recordset to the specified file as JSON data with the name of each field in the specified format becoming the JSON tag for that field's data. The valid set of jsonoptions are:
'rowtag'
HEADING( headertext [, footertext ] )
| rowtag | The text to place in record delimiting tag. |
| HEADING | Specifies placing header and footer records in the file. |
| headertext | The text of the header record to place in the file. |
| footertext | The text of the footer record to place in the file. |
| TRIM | Specifies removing trailing blanks from string fields before output. |
| OPT | Specifies omitting tags for any empty string field from the output. |
If no jsonoptions are specified, the defaults are:
JSON('Row',HEADING('[',']'))Example:
R := {STRING10 fname,STRING12 lname};
B := DATASET([{'Fred','Bell'},{'George','Blanda'},{'Sam',''}],R);
OUTPUT(B,,'fred1.json', JSON); // writes B to the fred1.json file
/* the Fred1.json file looks like this:
{"Row": [
{"fname": "Fred ", "lname": "Bell "},
{"fname": "George ", "lname": "Blanda "},
{"fname": "Sam ", "lname": " "}
]}
*/
OUTPUT(B,,'fred2.json',JSON('MyResult', HEADING('[', ']')));
/* the Fred2.json file looks like this:
["MyResult": [
{"fname": "Fred ", "lname": "Bell "},
{"fname": "George ", "lname": "Blanda "},
{"fname": "Sam ", "lname": " "}
]]