Of course...
Actually above error occur is because i am using w2k (DB2 client) to deploy SP into target DB2 server in AIX.
Later on i switch them back to same platform but different machine. It worked. I would like to say sorry!! it is not "across paltform", it is "across machine...
Thanks again sir, u are right! i am in the progress of creating "DECLARE GLOBAL TEMP TABLE" in DB2 8.1. To solve this problem, just need to create a tablespace (using type User temporary). And before use it assign mentioned user to have right to access it. Then it will work already!!!
If it is using Java API, then u can do as following lines:
...
...
int NoUpdatedRow = statement.executeUpdate("update blah blah...");
System.out.println(NoUpdatedRow);
...
...
Note:
Where u can get the number of updated row in above system print line.
Hi all,
i got this error from my application. I found that my current in used tablespace only have 4kb. For sure I did assign right for user "EXPRESS" to acess the mentioned tablespace (Userspace1).
I guess to solve the following problem is to increase the pagesize of the...
Can anybody tell me where goes wrong?
--->issue: db2 connect to genexp user express using password
--->result:
Database Connection Information
Database server = DB2/6000 8.1.0
SQL authorization ID = EXPRESS
Local database alias = GENEXP
--->issue: db2 put routine from...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.