Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. billytcj

    Can anybody tell me where goes wron

    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...
  2. billytcj

    How to increase TableSpace's Pagesize for created db

    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!!!
  3. billytcj

    Can anybody tell me where goes wron

    ok. i found the way to deploy SP in different platform already! Thank a lot sathyarams.
  4. billytcj

    update statment

    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.
  5. billytcj

    How to increase TableSpace's Pagesize for created db

    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...
  6. billytcj

    Can anybody tell me where goes wron

    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...

Part and Inventory Search

Back
Top