Hello All,
I found a workaround to this issue i.e. using comma , as a delimiter instead
of a pipe. Is this a known issue for CALL SYSCS_UTIL.SYSCS_IMPORT_DATA stored
procedure ? Or which are valid delimiters to SYSCS_UTIL.SYSCS_IMPORT_DATA ?
thanks,
~sameer
Sameer Mehta sameer_me...@symantec.com writes:
Hello All,
I found a workaround to this issue i.e. using comma , as a delimiter
instead of a pipe. Is this a known issue for CALL
SYSCS_UTIL.SYSCS_IMPORT_DATA stored procedure ? Or which are valid
delimiters to SYSCS_UTIL.SYSCS_IMPORT_DATA ?
Hello All,
I am trying to import data from a csv file to a table using CALL
SYSCS_UTIL.SYSCS_IMPORT_DATA with the following arguments -
arg 1 - schema name (I tried using null as well but it gave me the same error
message i.e. Column 'COLUMN2' is either not in any table in the FROM list or
18 Feb 2011 18:17:35,218- Thread: 15 SEVERE [com.vontu.lookup.csv.CsvLookup]
Failed to initialize Csv lookup.
Cause:
com.vontu.lookup.common.InitializationException: The exception
'java.sql.SQLException:
Column 'COLUMN2' is either not in any table in the FROM list or appears within
a join