I got a text file with delimiter description as x'6a' .
What would be the exact syntax in the External Table Configuration parameter.
i tired with
.... Fields terminated by "x'6a'"
.... Fields terminated by "x''6a''"
.... Fields terminated by "0x'6a'"
.... Fields terminated by "0x''6a''"
Table gets created with no errors, but errors generate during data selection,cause, field terminator is not matched with above defined.
Have you thought about doing a find replace on the file and changing the delimeter to ~ (tilde)? If you are on a unix system sed and or awk might work, they aren't my strong suit. You may want to change to a simpler delimeter going forward.