RE: SQLException - Column 'COLUMN2' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification .....

2011-02-24 Thread Sameer Mehta
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

Re: SQLException - Column 'COLUMN2' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification .....

2011-02-24 Thread Knut Anders Hatlen
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 ?

SQLException - Column 'COLUMN2' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification .....

2011-02-23 Thread Sameer Mehta
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

Re: SQLException - Column 'COLUMN2' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification .....

2011-02-23 Thread Bryan Pendleton
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