...
Reference file types are located in the src/main/reference/file/fml/name.fml folder in the project. Any named file type will be located in this folder first. The next step is to search the classpath for reference/file/fml/name.fml.
The Reference File Type
Reference file types are stored as json objects in files named with '.fml' extensions. This is a sample reference file type:
| Code Block | ||||
|---|---|---|---|---|
| ||||
{
"flat-file" : {
"format-type" : "delimited",
"row-delimiter" : "\n",
"column-delimiter" : "\t",
"null-token" : null,
"columns" : [ {
"id" : "SEQ_",
"type" : "INTEGER",
"length" : -1,
"basic-type" : "integer"
}, {
"id" : "FLOAT_",
"type" : "DOUBLE",
"length" : -1,
"basic-type" : "numeric"
}, {
"id" : "DECIMAL_",
"type" : "DECIMAL",
"length" : -1,
"basic-type" : "numeric"
}, {
"id" : "DOUBLE_",
"type" : "DOUBLE",
"length" : -1,
"basic-type" : "numeric"
}, {
"id" : "REAL_",
"type" : "DOUBLE",
"length" : -1,
"basic-type" : "numeric",
"default-value": 1
}, {
"id" : "NUMERIC_",
"type" : "NUMERIC",
"length" : -1,
"basic-type" : "numeric"
"read-only": true
} ],
"primaryKey" : [ "SEQ_" ],
"orderBy" : [ "SEQ_", "FLOAT_", "DECIMAL_", "DOUBLE_", "REAL_", "NUMERIC_" ]
}
} |