I have installed a DB2 Server on a remote machine and I want to connect to that database using a DB2 Client on AIX. I have installed the DB2 run time client but I cannot find the db2ca comman...
Hi everybody, I am a new one. I am doing a porject on network database. Just got stuck on the problem of double quote.
I want to insert the sentence:
<b>it is as good as "Wonderfulland"</b>...
I am configuring a tool that, at a particular point, executes a SQL statement on a DB. It is that generic ... my SQL statement can be anything.
I need a SQL statement that will put the cur...
The database order field is defined as numeric with length of 5; is there an easy way to increase the size of the column to 9?
I'm confused. I've now moved into VisualBasic.NET and I'm trying to use IBM.Data.DB2.iSeries.iDB2Connection.
Does IBM.Data.DB2.iSeries.iDB2Connection use ODBC?
Help file titled: "IBM DB2 U...
I get the above error when executing the following update.
update tlorder
set bill_number_key = 'XXXX-XXXX 12345678 '
where detail_line_id = -152345
detail_line_id is the primary key...
hi
I need to have today and yesterday's date as varchar yyyymmdd in SQL, but I do not have good knowledge on DB2...
with Sybase, it wouldn't be too difficult, just getdate, dateadd, conver...
Good Morning,
I have a database that is in the "backup pending state" I am aware that to correct this I can perform a manual backup from the DB2 command line. Is there any other way to chan...
Greetings,
I noticed on my RHES4 linux system running DB2 8.2 that there are 20 db2sysc processes running, and I also noticed there are 20 users running a desktop application on their PCs t...
hello,
i added one more column called submittime, the type is timestamp into a table.
my question is: in the table which already has some recordes, only the column submittime is empty, is...
Hello,
I am looking for a way to export DB2 UDB table data using tabs to delimit columns and NO character string delimiter. I don't want to delimit character strings because it is unnecessar...
Message:
SQL0952N Processing was cancelled due to an interrupt. SQLSTATE=57014
Database:
DB2-UDB version 8 on an AIX server
Hi All,
I'm having a real problem with an MFC-ODBC windows...
1) We have DB2 7.2.0 on WIn NT/2000 or AIX 5.1.
2) We need to alter a column to make it generated always as or generated by default or just as a sequence type column.
3) We looked up syn...
We are in the process of optimizing a lot of SQL queries running against a DB2 database. Another developer found a tool, I don't know what it was, and it suggests using COALESCE in a lot of p...
I have a database called KLOCB on an IBM DB2 v7.2 instance on an Unix based server.
yesterday morning the database worked perfect, however, now im getting the error:
"SQL1031N The databas...
Hi,
I'm using db2 udb v8.1 on SunOs 5.8 as i want to create my first database i get this error :
SQL1084C Shared memory segments cannot be allocated. SQLSTATE=57019
anyone can help ...
wht command should i give to turn it off
-c Auto-Commit ON
its db2 8.1.2 /nt
thanks
bobby
Hi Guys
I need a query to which a user will pass from and to timestamps for example
'2006-05-01-10.00.00.000000' and '2006-05-05-12.00.00.000000
Now what i need is that I get data for ...
HI,
Im using DB2 v9 and i wish to lock only some rows ( not the hole table ) from a table ,i've tried to use this : " Select ... from ... where .... with rs ", but this statement locks the w...
I've been banging my head against the wall for two days now. trying to track down the cause of this error.
The DB2 Version is :-
DB21085I Instance "db2inst1" uses "32" bits and DB2 code rele...
Hello,
How to check if stored prodecudure exists before dropping it?(using sql)
thanks
I have a total count being retrieved into a variable in a stored procedure.
Example the value of the variable is an INTEGER datatype with value as 99.... I need to change the value as a char ...
Hello EE Members & Experts ,
I am using Websphere Portal With IBM DB2 as DBMS.
In the last few days , i get a problem in inserting a new value in one of the tables , after tracing the pr...
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...
Do we have functions like Isnumeric as we have in C , which will check whether the contents in the VARCHAR filed are numbers or not ?
