>>I have a .txt file that has a few fields delimited by a ~
>>
>>What is the syntax to import that .txt file into a cursor (or a temp table) ??
>
>APPEND FROM should give you what you need (you can experiment with the WITH DELIMITER or WITH CHARACTER clauses).

I tried this:

APPEND FROM myfile.txt DELIMITED WITH '~'

...but all I get is data in the 1st column (there are 14).

same thing happens if I try this:

APPEND FROM myfile.txt FIELDS column1, column2 delimited WITH '~'