We currently have text in a field in our DB2 database. The current string reads:
Your package is now available for pick-up.
We want the text to now read:
Your package is now avai...
I'm having trouble getting a scheduled DTS job to run, even though it runs interactively. I've looked at the solutions posted here, and none seem to apply. Let me describe what I've done so fa...
Hi all,
I need to locate and writeup the procedure for recovering a UDB database from tablespace backup?
Is there anyone with actual experience doing this who can share examples of a scrip...
Hello,
we have an application running on IBM DB2 (Version 8.2). The application is developed in Delphi 7. Now we have a problem with our app at a customer installation. Setting the query text...
Every other day the DB2 service will freeze and need to be restarted. When reviewing the db2diag.log I find a couple items that appear to be the cause, but not 100% sure. And if they are the c...
Still learning ...
If I want to see what integer results from this: LOCATE ( 'A' , 'BBBBBBBBAAAA' , 6 )
How would I script it in a "Run SQL Scripts" window?
I've tried ...
SE...
I have a scenario where I have an ASP.NET page that uses T-SQL to hit a DB2 database with an ODBC connection. My requirement is that the client that has us developing this wants us to be able...
1) We have DB2 V5R3 on iseries AS/400.
2) FULL OUTER JOIN is not supported
3) There is a query we have written with repeating WHERE conditions for LEFT OUTER JOIN UNION RIGHT OUTER JOIN.
4)...
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...
I'm using AS400 iSeries SQL V5R4M0
How do I convert an integer into a varchar with commas embedded in the proper places? (Like ###,###,###)
I need to pull a list of zips and route numbers from a table and am trying to use DISTINCT, but I am pulling 0 rows. I know that there is data for this date and route type, so I am not sure w...
On 08/04/2008 the web app www.iilinoisskillsmatch.com produced a deadlock situation which
ate up the CPU for the entire WAS and the server had to be restarted in production. This is not good ...
I know next to nothing about running queries on an AS400, but I can't for the life of me get this to run - it's adapted from a SQL Server query.
Any help would be much appreciated:
SELEC...
I have a Stored procedure with 2 IN parameters (dbname,schemaname) and 3 OUT parameters one for the count of calls to the 2nd Stored procedure and the other 2 to capture the error messages upo...
Hi,
DB2 V8.2 - replication setup.
SETUP
=====
I have a several qualifiers composing of different tables for each.
There are multiple databases subscribing to these qualifiers.
Q...
Hi, I am trying to create a function that calls some dynamic SQL and then returns some value, like the example one below. I am using DB2 v9 on Windows.
CREATE FUNCTION halloWorld2()
R...
Here is the error which I received when upgrading DB2
DBI1130E The SA MP Base Component could not be installed or updated
because system prerequisites were not met. See the log fil...
Hello: I'm hoping someone can help with with a SQL (DB2 database) query that I'm needing to write. This query only involves a single table. Take the following table with the following fields:...
Is there a way to increase the number of foreign keys in a table? I have a situation as follows:
tblA
A_ID (pk)
tblB
B_ID (pk)
InputA1
InputA2
InputA3
Where all InputA's need to...
Okay, bear with me. I've built a Windows form that allows a user to enter certain business information. What happens is, I make an initial call to an Oracle database to pull in informatin th...
sigh .... ok how do I construct the SQL string to call a stored proc in DB2?
Below VB code works for [CommandType.Text]
Public Shared Function MyDB2Table() As DataSet
Dim ob...
1) We want to fetch records in ranges for a number of queries on DB2 V6 in AS/400 where OLAP functions like ROW_NUMBER are not supported.
2) We cannot use sequences or identity columns eith...
Hello,
I am very new to DB2 but I am hoping this is common enough that it is simple to do.
I want to create a silent install for DB2 Express C database on a windows machine such that it ...
I am testing an existing VB6 app, which creates AR and GL records in JD Edwards, running on an AS/400 with DB2 as the database. The VB uses ADO and an ODBC connection.
The application is w...
We use WebSphere Application Server 5.1 and access data in DB2/400 over JDBC using the toolbox driver in jt400.
There are instances where we call stored procedures (RPG) in DB2/400. These st...
