Fighting a dragon with modern military units (or Smaug vs. Symptom When the 'Create DB' button is pressed: Creating new empty Database Running DB Step: initial Running script batch: script/db2_createDB.batch Running script: script/db2/sequence_xdbtrickle_seq.sql Running script: script/db2/table_xdb00.sql ** ERROR: com.ibm.db2.jcc.am.io: DB2 SQL But when I try to select * from APPSFA.DummyTest this is the error I get. They are created little by little, day by day.

asked 2 years ago viewed 35198 times active 1 year ago Linked 7 Db2 connection problem with java 5 ibm db2 net driver sql error. Oh dear, I should have tried that. @mustaccio, would you like to add it as an answer, and I'll accept it? –Martin McCallion Jun 11 '14 at 11:33 add a comment| Why were Navajo code talkers used during WW2? So here's what it says: Column or attribute "" is not defined in "".

Like Show 0 Likes(0) Actions 3. Sqlcode=-204 Sqlstate=42704 In Mainframe I've just "mv"ed a 49GB directory to a bad file path, is it possible to restore the original state of the files? The first error is because you didn't specify a schema, so it couldn't find the login table. Slightly embarrassed, too, though. –Martin McCallion Jun 10 '14 at 21:09 1 That was it!

See if supplying the schema name in upper case helps. –mustaccio Jun 10 '14 at 15:34 1 That sounds believable, because if you don't use "'s, then DB2 automatically rolls Sql0204n Is An Undefined Name. Sqlstate=42704 Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence. But then I change one single variable, the table name, and it gives me the 42704 error meaning it can't find the table. Can any one please help me out.

Sqlcode=-204 Sqlstate=42704 In Mainframe

Thanks in advance. Accidentally modified .bashrc and now I cant login despite entering password correctly Do working electrical engineers in circuit design ever use textbook formulas for rise time, peak time, settling time, etc Is An Undefined Name.. Sqlcode=-204, Sqlstate=42704 I run my Java program with a specified name of a table which has been in the database for a long time. Db2 Sql Error: Sqlcode=-727, Sqlstate=56098 Information Server Datastage Certified http://www.infocura.be Reply With Quote 01-06-12,04:20 #12 dubeyanurodh View Profile View Forum Posts Registered User Join Date Dec 2011 Posts 7 I have published all the details requested.

So since I'm using a table name, this means that it can't find the specified column in this table right? Why does Fleur say "zey, ze" instead of "they, the" in Harry Potter? and may be more information neccesary, depending on your response ... Why _finitism_ isn't nonsense? Sql State 42704 Postgres

I called it DummyTest and created it under the APPSFA user so it named the table APPSFA.DummyTest. Please help me java jdbc db2 db2-luw share|improve this question edited Jul 21 at 19:47 mustaccio 10.7k41933 asked Oct 19 '09 at 13:33 RishiPatel 801211 add a comment| 4 Answers 4 how to deal with being asked to smile more? The Question is viewed 10 time and no answer.

Protracted and patient effort is needed to develop good DBAs. Are there any non-ideal side-effects of putting capacitors in parallel to increase capacitance? With other words, the specified schema and/or tablename doesn't exist in database. DB2 version is 9.5 and OS is AIX.

Please let me know what else you need. It look like a schemaname.tablename to me. Reply With Quote 01-06-12,05:06 #13 stolze View Profile View Forum Posts Visit Homepage Registered User Join Date Jan 2007 Location Jena, Germany Posts 2,721 As we said: check that you have Still, some of my colleagues have the above configuration working, at least when they have WAS and DB2 on the same machine.

Is it possible to make any abelian group homomorphism into a linear map? Explanation: If "" is a table or view, then "" is a column that is not defined in "". asked 7 years ago viewed 34428 times active 3 months ago Get the weekly newsletter! more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed

I get following error : com.ibm.db2.jcc.b.eo: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=SCHEMANAME.TBLNAME, DRIVER=3.53.95 at com.ibm.db2.jcc.b.bd.a(bd.java:676) at com.ibm.db2.jcc.b.bd.a(bd.java:60) at com.ibm.db2.jcc.b.bd.a(bd.java:127) at com.ibm.db2.jcc.b.gm.c(gm.java:2484) at com.ibm.db2.jcc.b.gm.d(gm.java:2461) at com.ibm.db2.jcc.b.gm.a(gm.java:1962) 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) or you can request me to come over .. Not the answer you're looking for? Start the Controller application server 12.

Shutdown Controller application server (to ensure that there are no connections to the DB2 database) 3. Steps: Assuming your DB2 database server is hosted on Windows: 1. Does Neo have any back-story?