DB2: accessing the column by column number
Can I select the columns by column number like for example select custome.0, customer.1 from customer table customer with id and name as columns? ...
db2
How does Firebird client/server compare to DB2 Express C
I was about to use Firebird for a project, when someone told that DB2 Express C is also free, and with plethora of tools, and is also mature. I read Firebird is also good for use as enterprise client/server database. Then how does it compare to DB2 Express C? Could the experienced ones shed some light on this. ...
How to make JDBC SQLExceptions for DB2 more descriptive?
How to make SQLExceptions thrown by DB2 JDBC driver more descriptive? Currently I am getting this kind of exceptions. It is cumbersome to work with these cryptic SQLCODE and SQLSTATE numeric values. Is there a way where to make the SQL exception to contain code description. Caused by: com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLC...
UNION with different data types in db2 server
I have built a query which contains UNION ALL, but the two parts of it have not the same data type. I mean, i have to display one column but the format of the two columns, from where i get the data have differences. So, if i get an example : select a,b from c union all select d,b from e a and d are numbers, but they have different f...
Not able to query after Alter table in DB2
We have a table someone created in DB2. I have no idea how they created it. But when I edit the table, It edits just fine. But after edit I can not query the table at all THE COLUMN CANNOT BE ADDED TO THE TABLE BECAUSE THE TABLE HAS AN EDIT PROCEDURE. I looked ibm site and found this how to edit table using procedure But I have no idea...
DB2 - LUW 8.2 Can you restore one tablespace from a full DB backup to a different server
In DB2 8.2 for LUW can you restore one tablespace to a 2nd server from a full database backup without having to restore the entire database? The database backup was taken when the system was up so log files are involved. I can provide further clarification if needed. Thanks, Dave ...
pagination on jsp with DB2 as backend
I am retrieving thousands of rows from the database, but I want to display only about 200 on one jsp. I am using pagination by creating links to the next rows. Currently using DB2, the only thing I can do is a FETCH FIRST 200 rows. So by the time I get to the 5th page, I am doing a FETCH FIRST 1000 rows and then I am displaying 800 to 1...
Is a commit needed on a select query in DB2 ?
I have a vendor reporting product executing queries to pull report data, no inserts, no updates just reading data. We have double our heap size 3 times and are now at 1024 4k pages, The app will run fine for a week then we will begin to see DB2 SQL error: SQLCODE: -954, SQLSTATE: 57011 indicating the transaction log is not able to acco...
Is it possible in DB2 or in any Database to detect if the table is locked or not?
Is it possible in DB2 to detect if the table is locked or not. Actually whenever we use Select statement and if that table is locked [ may be because of on going execution of insertion or deletion ] , then we have to wait till the table is unlocked. In our application sometimes it goes to even 2-3 mins. What i think is, if i can have s...
Free alternative of TOAD for DB2
I am currently using Toad for DB2 to work on my DB2 database. I just wanted to know is there any free alternative to Toad for DB2, Note: Similar question is posted earlier, but it was for TOAD [ oracle ], none of the solution specified is for DB2 obviously. ...
Oracle Migration Workbench
Does anybody know anything about using Migration Workbench to migrate db2 database to oracle 10G? I am getting a strange SQL1402N error when I try to get source capture. ...
How do I figure out if a column size is in bytes or characters from the column metadata?
I am working on some software that has to create dummy entries in various databases (Oracle, DB2, SQLServer) temporarily. Every column in the the row is filled with random data. The code uses java.sql.DataBaseMetaData class in java to get the COLUMN_SIZE attribute to figure out how large of a random string to store in the VARCHAR2 and ...
Database and table of arbitrary percentages?
This question is kind of complicated and I do not even know how to Google for it in the first place. I am even having loads of difficulty phrasing my question coherently but here goes! Hi guys, I need some help with some SQL. I am making a database (DB2 Express-C) backend for a company's corporate training software. The intention is to...
Mapping a table called "group" in Hibernate for DB2 and HSQLDB
I have a table called group, that I am trying to map using hibernate for DB2 and HSQLDB. Table name group is a reserved word and it must be quoted in HSQLDB. However DB2 does not like quoted table name. So this mapping works in HSQLDB but not in DB2: @Entity @Table(name="`group`") public class Group { Mapping results in following err...
EJB3/DB2 Transactions not rolling back.
Hello all, I have a situation where I have a tree of Entities, and a Session Bean. The Session Bean simply persists or merges the entities, and the method in question is marked as @TransactionAttribute(TransactionAttributeType.REQUIRES_NEW). Now in the case that a child entity fails to be persisted/merged due to (for example) a foreig...
What does SQLCODE: -516 signify
I am able to retrieve data from the same database table but am not able to isert The error which i get is DB2 SQL error: SQLCODE: -516, SQLSTATE: 26501, SQLERRMC: null ...
Db2 connection problem with java.
I am having problem with DB2. I just installed the db2 as a db2admin and with a password. When i try to connect to database it is success full and while running any simple select query it give me following error:- DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DB2ADMIN.LOGIN, DRIVER=3.57.82 I have a database named onp and a tabl...
Where/How do I handle different connection types using Repository Pattern with ADO.Net?
I am new to the repository pattern but am creating a repository to connect to two different database types that have the same data structure. Where and how should I handle the connection? Here are my requirements/constraints/project description I will be connecting to SQL Server 2005 and DB2 (on Iseries) I will be using the repository...
DB2 automatic trim tailing whitespace
This is data in TB_USER table USER_USERID -------------- A111 A9999 ADMIN AHO AHO2 AHO3 AHO4 ...and schema of TB_USER table is COLUMN_NAME DATA_TYPE DATA_LENGTH -------------------- --------- ----------- USER_USERID VARCHAR ...
Add a column to a DB2/400 table with a specific ordinal position
Is there an SQL command on the AS400/iSeries/System-i/whatever to add a column to a table in a specific ordinal position, or moving an existing column to a different position? ...