midrange.com -- midrange-l mailing list

Re: Re:

Charles Wilt — 2013-05-22T15:49:11-05:00

This the that also logical issue list -- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list list -- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/midrange-l or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.

RE: Re:

Mike Cunningham — 2013-05-22T15:46:50-05:00

also logical issue list -- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/midrange-l or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l. -- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email...

RE: SQL Index Journaling

Mike Cunningham — 2013-05-22T15:46:24-05:00

Thanks - that is how we deal with native file creating when we manage journals ourselves. Create a table and decide when, where and how it is to be journaled and set it up that way. A few logicals we journal but not all of them. This one app was created using all Navigator tools from table creation, procedure creation and index creation. Navigator must journal indexes by default. I am planning on (slowly) stopping journaling on logicals to be sure it does not impact the application -----Original Message----...

Re: COMMON Europe

Hoteltravelfundotcom — 2013-05-22T15:46:04-05:00

Re: Re:

Hoteltravelfundotcom — 2013-05-22T15:43:48-05:00

RE: Re:

Bill Hopkins — 2013-05-22T15:09:33-05:00

Re: SQL Index Journaling

Mark S Waterbury — 2013-05-22T14:57:48-05:00

Hi,, Mike: Journaling access paths is not required for commitment control. There may be other reasons this may be desirable, such as to help speed up the restore of PFs and all of their LFs from back-up tapes, e.g. when recovering from a disk crash. =-O Otherwise, the system will have to re-build all of the access paths later on ... HTH, Mark S. Waterbury

RE: SQL Index Journaling

Gary Thompson — 2013-05-22T14:51:32-05:00

Mike, my guess is you can get by with journaling the base file(s). I think journaling "access paths" would be optional. -----Original Message----- From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike Cunningham Sent: Wednesday, May 22, 2013 1:43 PM To: Midrange Systems Technical Discussion Subject: SQL Index Journaling Does an SQL created INDEX need to be journaled in order to support commitment control? We use the Index Advisor to create all of the indexes for on...

SQL Index Journaling

Mike Cunningham — 2013-05-22T14:43:28-05:00

Does an SQL created INDEX need to be journaled in order to support commitment control? We use the Index Advisor to create all of the indexes for one of our applications and we just noticed that they are all being journaled. I know a create table will start journaling by default but I am not sure about indexes (aka LF)

Re:

John McKee — 2013-05-22T13:38:45-05:00

RE: SQL Delete from multiple files

Anderson, Kurt — 2013-05-22T13:26:33-05:00

Thanks everyone for the feedback. Luis, I have saved that link. I realize I didn't say it, and I apologize, but I wasn't looking for a single statement to perform the delete simply for the sake of it, but was wondering if there was a relatively simple way of doing so. The answer, it seems, is no. I'm ok with the SQL I do have. Although I should get more comfortable with using With. Thanks, Kurt -----Original Message----- From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behal...

Re: Prototypes/headers for ascii runtime

Tim Bronski — 2013-05-22T13:04:53-05:00

Re: Prototypes/headers for ascii runtime

Mark S Waterbury — 2013-05-22T12:56:37-05:00

Tim: See: http://www-304.ibm.com/partnerworld/wps/servlet/ContentHandler/pw_com_asciirt_tips I found this with a google search for "QADRTTS" ... Mark

Prototypes/headers for ascii runtime

Tim Bronski — 2013-05-22T12:25:13-05:00

Does anyone know where the prototypes/C headers are for the ascii runtime functions in service program QADRTTS (the old QADRT.h) ?

Re: WebQry 1.1.2 Not Fully Starting

Kirk Goins — 2013-05-22T12:21:48-05:00

When server jobs fail to properly start, and a joblog does not conspicuously reveal the cause, I almost always look for T-AF entries in -- Kirk -- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/midrange-l or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrang...

Re: WebQry 1.1.2 Not Fully Starting

TheBorg — 2013-05-22T12:04:47-05:00

QSH find to print

fbocch2595 — 2013-05-22T11:49:23-05:00

Hi Folks, what's the syntax to make the following command print a report on the i? QSH CMD('FIND / -name ''*.zip''') Thanks, Frank

RE:

Scott Mildenberger — 2013-05-22T11:45:48-05:00

Just explicitly list just the fields you want included. Scott Mildenberger -----Original Message----- From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Crystal Reports Sent: Wednesday, May 22, 2013 10:43 AM To: midrange-l@xxxxxxxxxxxx Subject: It seems to me, if I remember, the logical file, when used in Crystal REports, it passing not only all the records of the file OEOEHDOH, but also all the many fields. Is this correct? If the CR only is interested in say 5 fiel...

[no subject]

Crystal Reports — 2013-05-22T11:43:23-05:00

It seems to me, if I remember, the logical file, when used in Crystal REports, it passing not only all the records of the file OEOEHDOH, but also all the many fields. Is this correct? If the CR only is interested in say 5 fields, how can we code this logical or to make a new one that will only pass less, is that a performance issue would you say? I have also added a temporary filter to this logical R OEORHDRR PFILE(OEORHDOH) K OHORDT R K OHSHTC R K OHORDD R DESCEND O OHORDD COMP(LT 20130101) *** MY ADD O OH...

Re: Another PowerHA Question

Jim Oberholtzer — 2013-05-22T11:41:52-05:00