I coded a one time script as follows in Command Editor : ( do not want to make it a stored procedure)
*******************************************************************
begin
DECLARE xxid ...
Hi All,
Just now i downloaded DB3 8.1 personal from IBM. when i am trying to create a connecting to that i am getting this error below. how to solve this problem?
IWAS0126E Problems enco...
//Doesn't look like DB2 supports the from clause in update statements.
//FOR EXAMPLE: I have 2 tables defined.
//The customer_input table will be used to update the customer table.
//c...
Hi Experts,
I'm struggling with something that I thought would be very easy! I'm trying to find a simple / free ODBC driver for IBM DB2. I have a Windows 2003 machine with DB2 on a networ...
I'm accessing a table in a DB2 database on an IBM I-series.
The Table (a price list) is arranged as follows:
Part Number, Price, Effective Date (stored as a 7 digit string)
This means t...
How do I do an if-else statement in AS400/iSeries??
In SQL Server, I have:
if whatever Begin
..
END
Else If whatver2 Begin
...
Else
..
End If
I probably can use Case but how ...
Hi Folks,
I'm looking to perform an UPDATE statement whilst incorporating an INNER JOIN in DB2. The SELECT statement is dead easy:
select isupv from e3sitm i, e3ssrc v ...
I'm configuring online backup for my DB2 using Tivoli Storage Manager. Following DB2 and TSM document, I think I got it right.
In my testing the backup(online) and restore, this is what I di...
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 are using DB2 8.0.1 Express on Red Hat Linux 9
2) SELECT MAX(POINT_SEQ) + 1 FROM SFUCHECK WHERE POINT_DATE = CURRENT DATE FOR UPDATE WITH RS; is not working due to one of the many SELEC...
Ok, here is the question.
I need define a cursor having select statement with dynamic where clause.
Here is the detailed requirement in points.
1. Create a stored procedure with param...
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,...
What does decimal(15) mean in db2? Is it a decimal value that can have x.y digits s.t. x+y =15?
Thanks
I need to do a calculation with in db2 with a varchar + varchar, how can i convert it to integer or double?
Greetings, experts!
I'm receiving some invalid data from an external source, and I need to "clean it up" before loading it into our main database. Based on two columns in the table, I need ...
I am able to import csv's into a db2 database using:
db2 connect to DB01user USERNAME using PASSWORD
db2 -tvf C:\files\create_tables.sql
However this ignores the column header and impor...
Hi experts,
This should be the simple question.
I am calling db2 stored procedure having output parameter from the command prompt.
How to display (ECHO) the output parameter value of ...
I have a few Oracle SQL statements that I need to run in ISeries DB2. I'm not having much sucess.
Here is the idea. make a backup of Envelope table DatabaseA, empty out the Envelope Databa...
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...
Hi Guys
I need to find out how to compare dates in db2. i will be passing two dates 'from' and 'to' from the java code to the query in this format 2007-04-10-09.36.54.930000. what I need i...
I am having a problem with a simple select statement when the fields are null.
My input parameters are variables with an i in front in my code below. If I send in '' for a varchar input para...
I need some help with using the DB2 current date in my select where clause below for my VB program. I know this is not the correct format. Can someone please help.
oCant.Append "...
I want to create a select clause that have a column always has null value. Please show me how to do that with DB2.
Ex:
SELECT NULL AS nullColumn, * FROM TBL_A
Thanks so much!
I need to select a range of records from a IBM DB2 database and save them to a CSV file in a specific directory on the iSeries.
I know in SQL you ca do the following:
SELECT * FROM FOO i...
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...
