I want to select comma separated enames as single value for salary = 5000 from employee table. Please give me a single query to get this.
Hi,
I am getting the following error message while calling DB2 v7.1(UDB) SQL stored procedure.
Exception executing statement: { CALL CHEOPSUSER.CREATE_PHY_INV ( ?,?,?,?,?, ?,?,?,?,...
how do i clear the screen in DB2.
I am using DB2 CLP 7.2.5 in an AIX 4.3 environment.
Like in oracle if my screen becomes too messy, i can use the "cls scr" command to clear the whole screen...
Hi all,
I am trying to concatenate all the columns of this SELECT statements into one column. Columns are coming from multiple tables. When I try to execute it, I am getting the following err...
I am using DB2 and i basically want to turn rows to columns
EX:
Source Table
Key Category Value
1 C1 10
1 ...
we need to write a simple application (VB) to read an excel file and import the data into AS400 table/file...
Anyone done a project like this...do we need to read the excel row by row and i...
Db2 export - We have version 8 db2 and I am trying to export data from a table, I got the syntax but the dump data does not contain column names from table, how to get this info?
I know I've seen this somewhere before, but cannot find it anywhere...
I want to embed some SQL to pull some data from an external data source into an excel spreadsheet - without using Micros...
Hi,
I am having a VB application that is connecting to IBM DB2 7.2 through DSN. When I am trying to execute the stored procedures, I am getting the error "Query Timeout". Can anyone pls sug...
Hi All,
I am using DB2, basically want to turn rows to columns,
search criteria can be based on "Number" or "State", an empty search as well.
Source Table:
-----------------
Number...
I can't start db2 ,following message is:
$ db2start
09/19/2006 09:22:24 0 0 SQL1220N The database manager shared memory set cannot be allocated.
SQL1032N No start database manager...
I am using Work objects (asynch beans) running inside websphere app server 6.0. and hibernate as O/R layer.
There are about 80 Work objects, querying and updating tables in DB2 simultaneous...
Hello Experts,
I am new to DB2 For windows and I think I have either screwed up the installation or not configured it correctly.
I am runniong the Personal Edition and I cannot start the s...
We've been using DB2 on OS/2 for several years now, but suddenly have come up against some serious trouble. (I suspect the hard disk is failing, which may have caused this.) One of our tables ...
Hi all,
I have a transaction table that stores date and time in different fields. I need to concatenate these 2 fields and then subtract the minimum from the maximum to see how much time wa...
hi all,
i want to have one stored procedure to remove special characters from dbase and print the report
and after that it will concatenate the other string and update the db.
i am using ...
I have the join, below, which is oriented toward oracle. How do I select the "sysdate" within db2? How do I rewrite my join?
FSCMDMO.PS_DEPT_TBL.EFFDT=(SELECT MAX(DEP1.EFFDT) FROM
FSCMDMO...
Hi All - I am trying to port data from a mysql DB to a DB2 DB(express 8.2). I am very new with DB2 and am having trouble importing rows where one of the timestamp columns is null. For a simpl...
I have a ixf file for atable how do I import it in the db2
I have the need to display the age of people in a query.
I am comparing a BIRTHDATE field to "current date".
Would like to have the data presented as...
x Years, y Months, z Days
SQL Server 2000 with ODBC connection through Client Access (v9) to DB2 database on iSeries (AS400).
Various queries of the following form:
SELECT * FROM OPENQUERY(DBLINKSERV, 'SELECT SOSON...
REORG of a tablespace is failing.
I altered the secqty and priqty of the TS and then stopped and started the database when I got 'not able to allocate next extent message'
now after inreasin...
ive got a larger query, but to cut it down its like this:
select count(col1) as reccount from table1
where col2 > 0 and col3 / col2 > 21
union all
select count(col1) as reccount from tab...
I have a requirement to convert the concatenated column value string to rows, for example a string value
'London',Leeds','York' the result that I need is
London
Leeds
York
I googled ...
I have a batch program that reads and processes data from tables and writes that data to a couple of files. After I process all of the data and know what needs to be written to the files, I s...
