× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Hi Loyd

That's exactly right. We're allowed to use Query to interrogate the data
for investigative purposes on the production server, but they have to be
submitted to batch (F5 and interactive query is disabled).

QMQRY and any SQL that does maintenance (very little) has to go through
Change Management and be signed off before it can be run.

All I'm trying to do here is to identify blocks of missing invoice numbers
for an issue I'm working on. What I'll end up doing is identifying the
start of the range and then doing a similar thing to find the end of the
range.

All the best

Jonathan

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
lgoodbar@xxxxxxxxxxxxxx
Sent: 07 August 2008 17:05
To: midrange-l@xxxxxxxxxxxx
Subject: RE: Finding gaps in a sequence of invoice numbers using SQL

Al,

I suspect that Jonathan can run SQL via iSeries Navigator's Run SQL
Scripts to query the data. This is generally a grey area in most change
management policies. Any program, update or inquiry generally goes
through CMS. Any SQL that becomes a QMQRY or RUNSQLSTM should go through
CMS also (IMO). In my experience running SQL queries for
troubleshooting/inquiring are generally unknown or exempt from CMS.

Not saying it's right but what I've found.

Loyd Goodbar
Business Systems
BorgWarner Shared Services
662-473-5713

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Al Mac Wheel
Sent: Thursday, August 07, 2008 10:07 AM
To: Midrange Systems Technical Discussion
Subject: Re: Finding gaps in a sequence of invoice numbers using SQL

So how come software written in SQL is exempted from change management
at
the company? Are other languages like COBOL also exempted?

Do the rules specify a particular version of RPG, for example ... if
they
say that any programs written in RPG ILE go through change management,
then
maybe you have access to an earlier version like RPG/400 or RPG 2.5 &
saying that the rules don't include all versions of RPG, then you can do

the job in a different older version.

Sounds to me like the change management system needs to go through
change
management to authorize the creation of reports when investigating some
crisis, like running out of numbers, or other situation that might
interfere with business continuity.

If the invoice # can only go up to 6 digits, then maybe what is needed
is a
system for archiving oldest, based on date of issuance, and fact of paid

... we have customers with invoices unresolved from 2 years ago, so we
need
to hang onto the invoice detail to participate in the customer game of
infinitely asking again for, and receiving, details on the invoice.




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.