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