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...
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?
1) I am comfortable with control center for configuring, establishing connections and its GUI.
2) For configuring in Client Configuration Assistant, there are 6 protocols: Local, Named pipes,...
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...
Hello,
I have a stored procedure that starts by doing a MERGE and the clean up old data. The MERGE has an INSERT statement for the NOT MATCHED condition and an UPDATE statement for the MATC...
WE created user ids and groups on the Unix machine that hosts DB2 database.
We wereplanning to grant permissions to tables and stored procs to groups only , not to specific ids.
Our DBA to...
1) Earlier we used to have DB2 UDB 9.1 Express C on Linux but now AS/400 DB2 V5R3 has added to the scene.
2) We used to use SELECT ...........FOR UPDATE WITH RS; to fetch MAX(SEQ_NO) + 1 and ...
Is there a way to format a current timestamp when inserting it into DB2 through SQL.
Hi DB2 experts , I have a problem in a user accessing database?
This is a DB2 V9.1 problem for attaching the new Brokernet user id to db2instance and database.
Here is what I did:
1) A...
how can i get the current time in seconds in db2,,, unix epoch.
Hi,
I'm trying to extract the state from the address fields. the format is this: street, ST where street is the name of the street and ST is the state initials from 2 letters. most of the t...
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?
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 this error when i try to started my application.
and on the services, i couldn't start this:
DB2 - DB2-0
But the rest of the services are started.
DB2 Licience Server
Db2 Remot...
My db2 running very slow . I am planning to run RUNSTATS on tables . What procedure i want fallow .Is it necessary to run reorg before RUNSTATS . I hear ed this is sequence i want to fallow ...
Hello experts,
I am running IBM DB@ UDB 8.1 on Red Hat Linux 8.0.
I just like to know how can run my sql script from the command line. So far I am trying as follows:
db2 => client.sql
DB...
Hi,
I want to pad the fields while selecting them in the query. The query should look like -
SELECT PAD(<field name>,10,"0") from <table name>
where <condition>
So if the value of the ...
What does allow reverse scan exactly mean in DB2.
1) It assists queries with columns only in order by clause.
2) It assists if original order of columns is reversed in order by
3) It ...
Hi,
I need to create a Materialized view for one of my report in the DB2 data base.
Can you please let me know what is the syntax for creating the Materialized view in the DB2?. Please not...
Hi, I'm new to AS/400 and DB2 (we're currently at ver 4.5)
I've got a C# application that uses an ODBC connection to retrieve data from a DB2 database. When running the application I get ...
I'm trying to use commit and rollback in my stored procedure. I insert records into two tables but I only want to commit them if they both suceed. The Rollback is not working. The insert fa...
Hi
I have a db2 table having timestamp as column and when data gets inserted to this table, I see the time as GMT and not EST, is there way to change that?
I'm sorry for such a basic question, but I've been hunting for a few days and haven't found a clear answer.
I'm developing on a Windows server running ColdFusion. I need to connect to the ...
Hi all,
I have a need to copy z/OS data and load into DB2 UDB on Linux and Windows Servers. What are the options that I have to accomplish this requirement. Please be kind enough to describe ...
I have some text data stored in db2 table as blob type. How do I select these data so that I can see the actual text.
Thanks in advance.
