With a text editor I can write SQL to create a table on the server; however, there is a secondary qualifier ( IN STATEMENT) which must be attached to the query. example of text editor SQL: ---ConnectString=ODBC;DSN=DB2AAAA create TABLE ANY_TABLE (MEM_ID (6) Not Null) IN X2222221.X2222222 ; I need to integrate X2222221.X2222222 in my DBLOAD statement: proc dbload dbms=ODBC data=OUTSAS.TEST; DSN = 'db2aaaa' uid='anyid'; pwd='anypassword'; TABLE = test; load ; run; Without the statement I receive the error: ERROR: CLI execute error: [IBM][CLI Driver][DB2] SQL0551N "anyid" does not have the privilege to perform operation "CREATE TABLESPACE" on object "BP20". SQLSTATE=42501 Any help would be greatly appreciated
... View more