Date:         Tue, 29 May 2001 12:54:11 GMT
Reply-To:     Tom Walker <TWalker@GIANTBEAR.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Tom Walker <TWalker@GIANTBEAR.COM>
Organization: Prodigy Internet http://www.prodigy.com
Subject:      SAS/Access - DB2 import
Content-Type: text/plain; charset=us-ascii

I use the db2 "import" utility in native db2, and want to invoke it from
SAS.  From prior tests, I know the db2 connection is valid, the problem
definitely lies with the execute of the import statement.  Any ideas
what the problem could be?

proc sql;
connect to db2 as dw (database=rptdwp01);
execute (set current schema rptdev) by dw;
execute (import from "/u/sastest/data/sub_count_by_day" of del
insert_update into sub_count_by_day)  by dw;
disconnect from dw;
quit;

ERROR: CLI execute error: [IBM][CLI Driver][DB2/6000] SQL0104N
   An unexpected token "import from "/u/sastest/data/sub_count_by_"