RE: Suggestions for replacing WRKQRY

Mark,

I just did the STRQM command and it throws the message that it cannot start because a COMMIT or ROLLBACK must be done.
Someone must have played with this before my time here.

What will happen with either option?

Thanks,
Jerry

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mark S Waterbury
Sent: Friday, May 8, 2015 10:04 AM
To: Midrange Systems Technical Discussion
Subject: Re: Suggestions for replacing WRKQRY

Dan:

You probably already have IBM's Query Manager/400 installed on your system ... try typing in the command STRQM and see what happens.

The RTVQMQRY and RTVQMFORM commands can retrieve information from the older *QRYDFN objects to assist with converting to *QMQRY and *QMFORM.  
See also the ANZQRY command for advice or warnings about things that require "manual intervention" when converting.

HTH,

Mark S. Waterbury

 > On 5/8/2015 10:55 AM, Dan wrote:
> Was asked just this morning for suggestions on SQL-based report 
> writers, such as Sequel.  I haven't used any such product in ages, so 
> I'm really not sure what's out there.  Note that I am not the decision 
> maker on this, so all I will do is pass along information.
>
> Any such product should be able to convert (preferred) or use existing 
> *QRYDFN objects.
>
> Suggestions on what to look for as well as what to avoid are welcomed.
>
> - Dan

--
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.

Subject to Change Notice: 

WalzCraft reserves the right to improve designs, and to change specifications without notice.

Confidentiality Notice:  

This message and any attachments may contain confidential and privileged information that is protected by law. The information contained herein is transmitted for the sole use of the intended recipient(s) and should "only" pertain to "WalzCraft" company matters.  If you are not the intended recipient or designated agent of the recipient of such information, you are hereby notified that any use, dissemination, copying or retention of this email or the information contained herein is strictly prohibited and may subject you to penalties under federal and/or state law.  If you received this email in error, please notify the sender immediately and permanently delete this email.  Thank You;  

WalzCraft PO Box 1748    La Crosse, WI.  54602-1748
www.walzcraft.com     Phone... 608-781-6355