RE: Finding gaps in a sequence of invoice numbers using SQL

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.