Did you know you can create delimited data files from a UniQuery (InfoTrieve)?

When you use a lower-case verb like “sort” or “list”, UniQuery supports the “TO DELIM” option that allows you to define both the file name and delimiter used in the output. For example:

list LS.MASTER CUST.NAME ACTIV.DATE PYMTS.RECEIVED TO DELIM "^" /tmp/contract_list.txt

Also, don’t forget to execute the “UDT.OPTIONS 91 ON” command at TCL to force your output to be in external format: Dates, Times, and Decimals.

Refer to the UniData “Using UniQuery” or “UniQuery Command Reference” PDFs for more details and other options!

 
Written by

Tamarack

Tamarack Technology, Inc. is a leading provider of independent software, operational, and technology services supporting the equipment finance industry for more than 20 years.

« Back

Contact us

  • Should be Empty: