 |
|
|
|
|
Can you help me with this query?
Expert: Craig Mullins | 22 Jul 2003
EXPERT ANSWER - 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 prevents me from ...
|
|
|
Console vs. GUI-based mainframe applications
Expert: Craig Mullins | 22 Jul 2003
EXPERT ANSWER - I am a graduate student at the University of Waterloo, Ontario, Canada. My research is focussed on software usability issues in mainframe environments. I was wondering if you could let me know whether the majority of ...
|
|
|
DB2 mirroring: Tools and options for 24/7
Expert: Craig Mullins | 22 May 2003
EXPERT ANSWER - 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 (i.e. almost ...
|
|
|
DB2 date conversion
Expert: Craig Mullins | 22 May 2003
EXPERT ANSWER - 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 date. I can get ...
|
|
|
Help with the 'in' clause
Expert: Craig Mullins | 22 May 2003
EXPERT ANSWER - 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 exception is thrown. It ...
|
|
|
Will the DB2 updates be committed as part of the two-phase commit?
Expert: Craig Mullins | 06 May 2003
EXPERT ANSWER - 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 was not setup ...
|
|
|
I get a -30090 message when the CICS application is executed
Expert: Craig Mullins | 06 May 2003
EXPERT ANSWER - 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 version 7.
We ...
|
|
|
Converting words to numbers in DB2, and vice versa
Expert: Craig Mullins | 10 Apr 2003
EXPERT ANSWER - 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")
|
|
|
Converting VSAM records into DB2
Expert: Craig Mullins | 10 Apr 2003
EXPERT ANSWER - 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.
|
|
|
|
|
|
|
