Hi,
I would like to add a column to a db2 table. The column should content timestamp and have as default value "0000-00-00 00:00:00.000000".
Could you please give me the accurate sql sta...
1) We got remote access to iseries AS400 DB2 V5R3M0 through telnet, MOCHA tool and Java JDBC driver based free tools executeQuery & DBVisualizer.
2) When I create tables from any of these 4 c...
Dear Experts
I'd like to know how one can use the trim function in DB2 for the following problem
select * from table a
where SUBSTR(a.col1, 1, 4) LIKE trim('%' || '0419 '|| '%')
and SU...
Hi!
I have a problem that I can't seem to find any answer to through "google-ing".
I have a table with a timestamp column as primary key.
Now what I want to do is create a ...
I'm trying to use a JCC driver to connect SQuirreL client to a DB2 9 database.
URL - jdbc:db2://SV-MADD03:6789/TEST02
Class - com.ibm.db2.jcc.DB2Driver
I get the following error when ...
I created a databse using create standard, selecting the default pagesize to 32k. However, when I restored the database( which was created/backed up on a different machine), the page size cha...
Hi, I am having syntax problem with db2 left outer join using where clause.
Every thing is good except the left outer join section. I am getting "SQL0104N An unexpected token "E" was found ...
Hi,
I'm looking for a NON - ANSI code to represent the outer join, in DB2.
In Oracle, we use WHERE a.adb(+) = b.def etc.
Is there a way to translate that (+) into DB2?
Thanks!
Dear Experts
I'm actually new in DB2, and I'd like to know how one can make a dummy table to replace the a table when one a character in the that table is missing
Let me explain:
I hav...
I have a table similar to the following (column headings at top):
appnum, state, yn1, yn2, yn3, yn4
1, AL, Y, N, Y, N
2, AL, N, Y, Y, Y
3, AL, N, N, N, N
4, OK, Y, Y, Y, Y
5, PA, N, Y,...
How do I fix this issue and create the index? The order of operation is required. Thanks.
CREATE TABLE THETABLE (
COLUMN1 CHAR(38) NOT NULL,
COLUMN2 VARCHAR(255))
ALTER TABLE THETABL...
I am working on an attendance spread sheet. Each student recieves 5 points for attending class, if the student is late they only get 2.5 points, if the student is absent they get 0 points for...
Hi,
I have a table in Db2 with data say
id_1 phase1
id_1 phase2
id_1 phase3
id_2 phase1
id_2 phase2
I need to concatenate the values like
id_1 phase1,phase2,phase3
id_2 phase1,p...
I recently created a trigger in DB2 9.1. It is simply logging user and timestamp to TABLE2 when an update is made to TABLE1. It is working however it writes as many as 6 times each time TABL...
Hi,
I am new to db2. i am getting a problem when i try to create a database from client on server.
when i try to create database using control center it work with out any error. but when...
What is the DB2 9.5 equavalent to this Oracle statement to CREATE TABLE AS?
I have poeple that are temps that come and go. Somethimes they come back to work for us. Rather than delete their mail file and add them as new when they return, I just leve the mail file in...
I would like as much details as possible regarding licensing, hardware support limit for DB2 UDB 64 bit 9.1.7 (viper1) vs 9.7 (cobra).
Also, what are the difference in features.
Whether...
Hi,
I have a program which needs to use needs to one of seven files all with the same DDS, but different division. Which file is needed is not know until the client requests an employee n...
Hi
The default instance of my server is DB2
I created new instance say test.
db2icrt test
Now I learnt to bring that instance visible in control center i have to catalog the instance.
...
Using: IBM Universe 10.2.3
Connecting via asp pages to ODBC.
I am successfully connecting to a Universe Server via ODBC and retrieving data.
It all works great, I get the data I need.
...
Be forewarned, I am very new to DB2!
I am trying to move a DB2 database to a new server.
When i specify the file path I want the DB to sit on it is ignored.
Here are the commands I am...
Friends I have a number and I am converting this to chat to conc with other stirnf field.
But the when i convert the number it strips of 0's before number
suppose number is 001234598 wh...
Does anyone know how set autocommit property insidea connection string on a ASP net.
How do I do a join between two columns of type TIMESTAMP and DATE? I know I can cast the TIMESTAMP as date in the SELECT, but how do I do in the join?
DB2: 95 windows
t1 CALENDARDATE is ...
