Db2 Sql Error Sqlcode=-204 Sqlstate=42704 Driver=3.50.152
Technote (troubleshooting) Problem(Abstract) When upgrading your WebSphere Business Events to V6.2.1 from a previous release, the upgrade fails. Symptom The upgrade failed and errors similar to the following are logged by the installer. [5/19/09 20:42:55:593 EDT] 0000003e validateSyste I BEER1023I: Business Spaces JDBC Definition not found. Assuming remote system installation and bypassing database validation [5/19/09 20:58:59:218 EDT] 00000050 CMPConnectorF W J2CA0130I: Connection Factory
the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Page 1 of 2 12 Last Jump to page: Results 1 to 15 of 18 Thread: Can't drop view Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode http://www.ibm.com/support/docview.wss?uid=swg21388652 03-09-10,08:57 #1 danieles View Profile View Forum Posts Registered User Join Date Mar 2010 Posts 5 Unanswered: Can't drop view Hi to all! I have installed DB2 9.7 FP1 on AIX OS. I have activate ORACLE COMPATIBILITY If i try drop view DB2 give me this response: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=HCSUITE.SQL100308144713000, DRIVER=3.50.152 Message: "HCSUITE.SQL100308144713000" is an undefined name.. SQLCODE=-204, http://www.dbforums.com/showthread.php?1654357-Can-t-drop-view SQLSTATE=42704, DRIVER=3.50.152 but the "HCSUITE.SQL100308144713000" i haven't create and i can not drop it. Can you help me please? Thanks. D. Reply With Quote 03-09-10,09:51 #2 n_i View Profile View Forum Posts Visit Homepage :-) Join Date Jun 2003 Location Toronto, Canada Posts 5,516 Provided Answers: 1 Why do you think it's a view? --- "It does not work" is not a valid problem statement. Reply With Quote 03-09-10,09:55 #3 Cougar8000 View Profile View Forum Posts Registered User Join Date Nov 2005 Location IL Posts 557 What is the problem? It tells you that object you are trying to drop is not there in plain English. BTW. I have never seen that naming convention used in the views. That resembles a PK that was auto created. Run the following and post output. db2 list tables for all | grep -i SQL100308144713000 I bet it will come back empty. db2 "select indname, uniquerule from syscat.indexes where indname = 'SQL100308144713000'" -- IBM Certified DBA on DB2 for Linux, UNIX, and Windows DB2 v9.7.0.6 os 6.1.0.0 Reply With Quote 03-10-10,04:49 #4 danieles View Profile Vie
over XML (TPoX) https://sourceforge.net/p/tpox/discussion/650154/thread/90ee88f2/ Discussion Transaction Processing over XML (TPoX) Brought to you by: afichter, agustin_g, irina_kogan, matthiasnicola, and 4 others Summary Files Reviews Support Wiki Mailing Lists Tickets ▾ Patches Bugs Feature Requests News Discussion Code Create Topic db2 sql Stats Graph Forums Help 3 Open Discussion 20 Help Formatting Help DB2 schema validated and mixed queries Forum: Help Creator: Ryszardo Created: 2011-01-26 Updated: 2013-05-02 Ryszardo - 2011-01-26 Hi, inserting data without schema validation (like db2 sql error "insNoValidcustacc.xml") works fine but when I try to execute data with schema validation I get an error: C:\TPoX2\WorkloadDriver>java WorkloadDriver -d tpox -w properties/insValidcustac c.xml -u 1 -tr 1 The WorkloadDriver program is running… The following arguments are used (user id/password omitted): -d tpox -u 1 -w properties/insValidcustacc.xml -tr 1 com.ibm.db2.jcc.b.nm: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=B051 510.CUSTACC, DRIVER=3.50.152 at com.ibm.db2.jcc.b.wc.a(wc.java:579) at com.ibm.db2.jcc.b.wc.a(wc.java:57) at com.ibm.db2.jcc.b.wc.a(wc.java:126) at com.ibm.db2.jcc.b.tk.c(tk.java:1901) at com.ibm.db2.jcc.b.tk.d(tk.java:1889) at com.ibm.db2.jcc.b.tk.a(tk.java:1416) at com.ibm.db2.jcc.t4.db.g(db.java:138) at com.ibm.db2.jcc.t4.db.a(db.java:38) at com.ibm.db2.jcc.t4.t.a(t.java:32) at com.ibm.db2.jcc.t4.sb.h(sb.java:141) at com.ibm.db2.jcc.b.tk.N(tk.java:1387) at com.ibm.db2.jcc.b.uk.Kb(uk.java:2461) at com.ibm.db2.jcc.b.uk.Pb(uk.java:2561) at com.ibm.db2.jcc.b.uk.Eb(uk.java:2127) at com.ibm.db