Expert Knowledgebase
DB2 and Database Management with Craig Mullins
Converting VSAM records into DB2
(21 JUN 2004)
I need information on converting VSAM records into DB2. It would be helpful if I could get any URL or some details on this subject.
Converting words to numbers in DB2, and vice versa
(21 JUN 2004)
I would like to ask, is there a built in function in DB2 that will convert a date into its word equivalent? (e.g. 2003-04-10 and output April 10, 2003) How about numbers? (e.g. 21 - output "twenty one")
Mainframe DB2 and stored procedure support
(21 JUN 2004)
Can tablebase tables be accessed from the stored procedure running on the mainframe?
I get a -30090 message when the CICS application is executed
(21 JUN 2004)
Our application is in CICS TS 1.3 in OS/390. We have defined DDF to access a DB2 UDB 7.2 Database in Windows 2000 Server from the mainframe. The connectivity is thru TCP/IP and the mainframe DB2 subsystem is v...
Will the DB2 updates be committed as part of the two-phase commit?
(21 JUN 2004)
If a CICS application calls a DB2 Stored procedure (that has done DB2 updates) and then issues a syncpoint, will the DB2 updates be committed as part of the two-phase commit? Assume that the Stored Procedure wa...
Help with the 'in' clause
(21 JUN 2004)
In DB2 I have a query which goes like this:
Select * from mytable where where mark in ('a','b','c'............);
The 'in' clause is generated dynamically and the size of query size goes to 261 kb. an excep...
DB2 date conversion
(21 JUN 2004)
In my database date is stored in numeric format yymmdd i.e. for MAY 13, 2003 it is stored as 30513. I want to compare this date between two dates, one is the current date and the other is 1 year from current d...
DB2 mirroring: Tools and options for 24/7
(21 JUN 2004)
We are evaluating several options to make our online application (CICS/DB2) 24/7 and co-exist with batch processing. One of the options is to use mirroring concept. Does DB2 have tools for achieving mirroring (...
Can you help me with this query?
(21 JUN 2004)
Hi Craig,
I have gone through your DB2 complete reference and other articles published by you ... believe it or not .. it is so informative and has answered almost all of my queries and doubts .. nothing ...
Preventing SQL -904 (resouces unavailable) abends
(21 JUN 2004)
We provide 24x7 production support for a mainframe application that runs in five different geographic regions and uses DB2 tables (there are about two dozen DB2 sites). Our client wants us to prevent SQL -904 (...
|
|
|
|
|
|
|
| TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of . |
|
| |
All Rights Reserved, , TechTarget |
|
|
|
|
|
