Re: reduce your I.T. backlog by granting SQL UPDATE/DELETE/ capability to user community!

FWIW i think this is a very good case for RI and foreign constraints...


Thanks,
Tommy Holden



From:   Bryce Martin <BMartin@xxxxxxxxxxxx>
To:     Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date:   05/27/2010 07:19 AM
Subject:        RE: reduce your I.T. backlog by granting        SQL
UPDATE/DELETE/  capability to user community!
Sent by:        midrange-l-bounces@xxxxxxxxxxxx



Yeah, we have a product that our users use to do mass updates.  Only
problem so far was when someone created 90,000 items in the item master
for a new product line and put the wrong item class on it... valid class,
passed the logic tests.... still wrong!  Thanks to the integral part that
item class plays it only too a week to run our update program to fix it.
So, 85 sql statements per item finally fixed it right up.  Gotta love the
'power users', one day they are a great asset because they don't bother
you, but when they do, its usually enough work to make up for lost time.


Thanks
Bryce Martin
Programmer/Analyst I
570-546-4777



rob@xxxxxxxxx
Sent by: midrange-l-bounces@xxxxxxxxxxxx
05/27/2010 07:02 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
cc

Subject
RE: reduce your I.T. backlog by granting SQL    UPDATE/DELETE/  capability

to user community!






There's a company that sells a product which will read files and do the
same thing. Useful for batch uploads and stuff.


Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From:   "Musselman, Paul" <pmusselman@xxxxxxxxxxxxxxxx>
To:     "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Date:   05/26/2010 04:57 PM
Subject:        RE: reduce your I.T. backlog by granting SQL
UPDATE/DELETE/  capability to user community!
Sent by:        midrange-l-bounces@xxxxxxxxxxxx



If users want to use spreadsheets to update the iSeries there is a safe
way--

One of our users had a spreadsheet with a lot of updates.  He, being a
'power user,' set up a keyboard macro to pick up the entries from his
spreadsheet and 'enter' them into the standard iSeries green-screen
update program.  This caused no issues-- all of his transactions went
through the normal editing just as if he was typing every keystroke by
hand.  And he didn't have to re-key all of the transactions from his
spreadsheet.

Paul E Musselman
--
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: 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 message (including any attachments) is intended only for the use
of the individual or entity to which it is addressed and may contain
information that is non-public, proprietary, privileged, confidential, and
exempt from disclosure under applicable law. If you are not the intended
recipient, you are hereby notified that any use, dissemination,
distribution, or copying of this communication is strictly prohibited. If
you have received this communication in error, please notify us and
destroy this message immediately. ---
--
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: 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.