IM 7.5: Used knowledge base article 859833, where it says to change the field of the source text file's definition from string to Long Varchar in order to link this field
with one in a sql query (sql query has definition of varchar). However, as soon as I change the type from string to Long Varchar, I can no longer preview the text
file (error: Invalid Field Definition '000' in definition of index or relationship).
I'm not sure where it is getting the '000' from, but my first record of this field in the text file is TOR0029629, which is a valid long varchar.
with one in a sql query (sql query has definition of varchar). However, as soon as I change the type from string to Long Varchar, I can no longer preview the text
file (error: Invalid Field Definition '000' in definition of index or relationship).
I'm not sure where it is getting the '000' from, but my first record of this field in the text file is TOR0029629, which is a valid long varchar.