I am setting up a column in db2 that has the actual query to execute in db2, the table looks like this
Table name : Test_query
Column1 : Query1 varchar(1000)
Value : insert into test_inse...
Hi. I am new to stored procedures. I am selecting data for various tables & placing them in global temp tables. I have a couple of temp tables that are each populated by it's own insert statem...
Hi All,
I am a SQL Server DBA by trade - but have been drafted to help our DB2 team on a very time constrained project.
I have noticed that all the stored procedures in DB2 that return d...
I have a sample db2 stored procdure written that has cursors, I needed experts to review and give me hints..
Requirement is to write a SQL PL SP that has cursor to iterate a table and then ...
Hi,
I want to update a colmn in table1 using a column i table 2. query will be like update table1 set column1 = (selet column2 from table2 where column1=column2). Problem is table 2 can conta...
I have a ixf file for atable how do I import it in the db2
[IBM][CLI Driver] SQL30081N A communication error has been detected.
Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS".
Location where the error was dete...
I am working on improving performances on db2 sql pl's and re writing some of the joins in the sql's, I would appreciate some one who could tell me what I should follow on table whether the pa...
Hello All,
Just wanted some advice, here is my situation.
I have a message driven bean which i want to ensure i only receive once.
So i am storing the MDB id's in a DB2 Database.
(sim...
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 ( ?,?,?,?,?, ?,?,?,?,...
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,
I'm trying to deploy my web application in Websphere Application Server Community edition Version 1.
I've generated my war file and deploy it with the administrative console (Applicati...
Is it possible to change the codepage settings for the client via SQL and the odbc-functions. If the environment DB2CODEPAGE=819 is set, I want to use the Codepage 1208 for the connection rega...
Is there any equivalent of DBMS_OUTPUT in Oracle or PRINT in SQL Server for DB2 or do I need to jump over my head again for this sort of thing?
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...
I have a problem in db2 development center (ver 8.1) executing a stored procedure (code posted) that looks at tablle ( test_query table colunn 1 defined as query varchar(32000)) and executing ...
Hello,
I have a field in database file that contains Numeric data types, these numeric values are indicating the Date of my file.
Now I want a query to convert these numeric values to date, ...
Hi guys
When i am running my query i am getting the following error, In the query I am using Substr function to get the text which is in the <Description> tags of the clob datatype column. ...
Hello,
I'm going to use db2move to transfer database between different o.s. ( from windows to linux)
for example: the database name is useraccount
The current issue is, in Linux, ...
My boss has been exporting several tables from our DB2 database into access and running an access wizard to create a Crosstab pivoted report. The access code is this.
TRANSFORM Sum(MM410IT...
While connecting from ASP via ODBC DSN with Named Pipes to DB2 database 7.2 on Win NT 4 workstation, we got the following error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[I...
The standard option for insertion to a decimal column is (appears) to be truncate
is there anyway to alter this to round?
e.g.
A Int
B Decimal(6,2)
insert into mytab (A,B)
Valu...
1) We have DB2 UDB 9.1 Express C on Windows.
2) Since space in D: drive is very less, I dropped one table after exporting its IXF.
3) Now I created a system managed tablespace with container...
I want to convert a string like September 11, 2001 to date for insertion in DB2.
But when i run the following command i get an error:
SELECT TO_DATE('September 11, 2001',
'Mo...
Hi
I uninstalled db2 than I reinstalled it but the db there were there before are not completely gone
how can I delete the db completely which were on the previous db2 install becasue w...
