Hi all,
I have a mysterious DEADLOCK occur in our UDB 8.2 environment that we will like to know what happened and why. Our scheduled backup and archive log files job have successfully complet...
Hi,
I need to use a performance tool for stored procedures written in cobol and in z/os.I have strobe and omegamon.How do I use them for stored procedures. Will be of great help if you c...
why below query returns 0 rows
Declare global temporary table session.temp_no
(
ref_no VARCHAR(32)
)not logged with replace on commit delete rows
/
insert into sessio...
Hi,
How do you select variables using a select statement like you do in MS SQL?
For example:
select @month = month, @year = Year From tableXYZ
hello a couple questions about index and primary key in udb
1) clustered index, i know you can only have one per table. But can you have it on an index with more than 1 column. well more sp...
I want to make a simple page that show only 10 records from one big file.
If I'll use somehting like "SELECT * FROM V40BPCSF.IIM" I'll get all Items in IIM file (1000K records) and it is taki...
I have an application in VB.net that does inserts into three different tables. Insert into table 1 is done by DB2 stored procedure1. Insert into table 2 DEPENDS on the success of the insert in...
I have a table in oracle (10g) that has 1 column defined as CLOB, I want to generate flat file data from this table so that I can import to db2 (ver 8.1) to read the data, I looked up in db2 I...
i have created one .bat file in windows in my java code to perform db2 export .I want to know how can i achieve the same in as/400 from my java code.
I want to know that if I don't have a backup of my database and I want to restore the database to another machine using the files in my existing machine, what is the procedure? Can I just copy...
i have this date
select DM_CREATE_DATETIME from dim_branch fetch first 5 rows only
DM_CREATE_DATETIME
--------------------------
2006-04-27-14.30.55.667009
2005-10-11-15.40.52...
What command or query can I use to give me table name, number of rows for all tables in an IBM DB2 database? I am using windows if that makes any difference.
I want to know some of disadvantages or drawbacks from AS400 compared with MS SQL. Actually we have to compare these two products and we preferably to roll out MS SQL rather AS400. It will b...
when i select the function:
newFunction(select name, address from customer)
i want it return the result like:
name1,address1
name2,address2
count=2
Hi, all,
I installed the new DB2 8.1 Personal Edition on my Redhat.
When I did "db2 create database dbname", it could say
"SQL1096N The command is not valid for this node type."
I have...
1) For IMPORT/LOAD, we can set savecount/commit frequency/savepoints of consistency.
2) Support we run DML commands i.e. bulk inserts and queries which do massive updates or deletes. How ca...
Hi
I have a situation where I have a table that has around 2000 to 3000 rows and this table has 2 columns query1 and query2 each varchar(4000) in length.
I want to execute these 2 query ...
This is a related question that Davelash helped me with.
The select statement returns 3 rows. I need the 3 rows to concat. But the while loop loops 5 times and the ***last row*** is concated...
Which version of DB2 is used on a System i computer with the i5/OS V6R1 Operation System? Please provide the name, version, and the URL to view the DB2 product.
Is a calculated field possible in AS400 iSeries V5R4 SQL ?
I can't find any documentation on "Calculated Field" is it called something else?
Like .... MyTable.FieldABCD = (MyTable.FieldA...
I am going to migrate the DB2 from AS400 platform to windows.
Therefore, I need to copy the table structure form from AS400 platform to windows.
How can I extract the table structure by gene...
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...
1) We have DB2 UDB 9.1 on linux.
2) ID columns and sequences are not allowed.
3) Primary keys are composite as (date, number, string)
4) We need to increment numbers from 1 onwards in midd...
Hi Guys
I need to create a query which gets data for a record from data stored in multiple records
There is a table taxctgry, which has the following columns
---------------------------...
1) We are having DB2 UDB 7.2 EE on windows NT 4.
2) I managed to connect & work with type 1 & type 2 drivers.
3) Type 3 driver is pure Java but needs client Db2 and meant for applets is ...
