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 ...
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?
Hi,
I have DB2 v8.1.8.762.
i want to export data from db2 to a flat file (preferably CSV format)
Can somebody help me on this?
Thanks,
Anu
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 have a DB2-database. Most of the tables have a primary key that is filled by selecting and updating a row from another table. (to mimic the Oracle Sequence-function).
"Select PrimKey from t...
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.
Part 2 of 2.
If I use a SELECT statment such as this while querying the AS400 db,
SELECT CustomerName, DATE(digits(CM_PMT_MO)||'/'||digits(CM_PMT_DA)||'/'||digits(CM_PMT_CN)||digits(CM_P...
I needed to export some of the tables in db2 for auditing purposes and then load them in spreadsheet so that I can see the columns for 12 months.
How can I export table data to spreadsheet?...
1) We have DB2 UDB 9.1 on linux.
2) One way to detect locks is monitoring. Will this detect deadlocks or we need to go for a snapshot. Actually inbuit deadlock monitor/detector in db2 detects...
Hi all,
My environment is Vista 64bit, VMware running Red Hat Enterprise Linux server machine, DB2v9.5 64bit.
While trying to install DB2 in this linux machine, I am getting a "The required ...
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...
I am using IBM DB2 6.1 on Windows NT 4.0 SP 6.
There are two databases LIBSRVRN and OBJSRVRN. I see only the folder d:\db2\node0000\sql00002. But I cannot see the folder d:\db2\node0000\sql...
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...
Hello,
How to check if stored prodecudure exists before dropping it?(using sql)
thanks
Plattform websphere: Solaris sun 9 on sparc
plattform DB2: windows server 2003 64 bits
DB2 level:
PTF number: WR21407
Build level: s080122
Prerequisite: V9.1 GA
Signature: ...
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...
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...
How do I place a timestamp into DB2 using sql?
hELLO EXPERTS,
I am using IBM DB2 VERSION 8 devloper edition....
I needed to amend that data in a table, and so I used the load operation to load data from a tab delimited .txt file.
...
I need a DB2 sql script that creates a table only if it does not exist. I do not want to drop the table first.
Example:
IF (MYTABLE exists)
THEN
-- DO NOTHING
ELSE
CREATE TABLE...
I am working on a tool to issue queries to DB2 on an AS/400 (iSeries) system. http://sourceforge.net/projects/sqlqueryagent
Is there a way, using SQL, to:
1. List all the databases on th...
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 ...
Hello,
I'm trying to load thousands of records extracted from an EXCEL spreadsheet to a DB2 database (version 8.2), with the date format in mm/dd/yyyy. I did a test as followings:
----------...
I am using EXCEL 2007 SQL to pull data from an AS400 and need to convert the integer dates (YYYYMMDD format) into dates I can use in a pivot table. I have tried the following satement and get ...
hi there,
col 1 AA BB CC DD (Table 1)
Col2 BB CC DD EE (Table 2)
Col 3 Bell , CAMBRIDGE (Table 2)
Col4
If data in col1(BB) = data in ...
