No idea where the back-tick came from. It happens consistently.
As far as I know, we are using the ODBC drivers that shipped with 11.5.0.2 but I will need to double check to be sure. Definitely not using drivers older than that...
I am able to "View Data Sample" on this file from the IA workbench with no issues.
/path/project/source is not the actual path. I have to substitute generic values in place of real values when posting online.
Here is the .odbc.ini header section entry:
Code: Select all
MYPOC=DataDirect TextFile(*.*) Driver
Here is the .odbc.ini driver section entry (it's got mostly default settings):
Code: Select all
[MYPOC]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMtxt00.so
Description=DataDirect TextFile(*.*) Driver
AllowUpdateAndDelete=0
ApplicationUsingThreads=1
CacheSize=4
CenturyBoundary=20
Database=/path/project/source
DataFileExtension=TXT
DecimalSymbol=.
Delimiter=
FileOpenCache=0
FirstLineNames=0
IntlSort=0
ScanRows=25
TableType=Comma
UndefinedTable=GUESS
Here is the /path/project/source/QETXT.INI file that was automatically built:
Code: Select all
[Defined Tables]
file.txt=file.txt
[file.txt]
FILE=file.txt
FLN=0
DC=|
TT=CHARACTER
Charset=ANSI
DS=.
FIELD1=colA,VARCHAR,255,0,255,0,