RE: What would you do without RPG?

I've never seen programmer working against db2 on their PC<

Bob,

Fairly common where I work and have worked.

We have a robotic picking system exchanging data between MS Sql Server
on Win-Tel servers. For Sales and Customer delivery we exchange iSeries
data with MS Sql server DB, an Oracle database, MS Sharepoint, and about
800 devices running Windows Mobile OS which exchange data twice daily
with iSeries running SAP and other business applications. We routinely
exchange data between our iSeries and various MS Excel workbooks and
text files, some with third-party clients.

Some years past I worked on an in-house "LIMS" which supported our QC lab.
The code was a combination of MS Access windows forms for lab staff to interact
with the MS Sql Server DB and MS Sql Server Transact-Sql to exchange data with
JD Edwards on an iSeries.


-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Roche, Bob
Sent: Thursday, July 31, 2014 9:27 AM
To: RPG programming on the IBM i (AS/400 and iSeries)
Subject: RE: What would you do without RPG?

I can't speak for set ups using the "i" as a pure DB server, but I
would have thought that in such environments there would indeed be a
group of DBA's sweating profusely over the fact some young
whippersnapper programmer has brought production to its knees by doing
a 30 file join using a never before >>used sequence with a selection
criteria that omits half the records evenly interspersed in the master
stock file who when asked "why?" responds with the answer "well it
worked really quickly when I tested it with my local sql set up" ;-)

The answer to this goes back to Buck's response. RLA means I don't write a 30 file join. I read or chain in to each file as needed. And how would test against a local sql setup? I've never seen programmer working against db2 on their PC. I also have not worked at many different companies. Where I worked there was usually a test partition, system, library list. That you run tests against.

--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l.

--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l.