Search found 2 matches

by teebag
Tue Jul 05, 2011 8:47 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Data Reader with Comma at EOL
Replies: 4
Views: 3657

Re: Data Reader with Comma at EOL

You need to add a 10 field to your metadata, type integer, delimiter \r\n

Name Type Delimiter
Field1 Integer ,
...
Field8 String ,
Field9 String ,
Field10 integer \r\n
by teebag
Mon Jul 04, 2011 12:59 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Correct way to execute SQL
Replies: 1
Views: 2122

Correct way to execute SQL

I have the following SQL set temporary option temp_extract_name1 = '/shared/jtesting/ei_phone.txt' set temporary option temp_extract_column_delimiter = '|' select * from ei_phone where pk_phone between 71894755 and 72542062 set temporary option temp_extract_name1 = '' go which works if I add it as &...