Booth, I have found some of your stuff interesting.
I just looked at this and thought, I need to try it.
I copied the two SQLRPGLE programs and the DSPF to my system. They compiled without issue. I think that is a first.
I get these results.
Location Response
Street 2800 37th St NW Trial 1 failed: SQL code -332
City Rochester Trial 2 failed: SQL code -332
State MN Trial 3 failed: SQL code -332
ZIP 55901
I looked up -332 and it said "Character conversion is not defined." I am not sure what conversion it is refering to.
Do I need to set up my CCID or something?
P#
Kerwin
IBMi Systems/Applications Programmer
-----Original Message-----
From: Booth Martin [mailto:booth@xxxxxxxxxxxx]
Sent: Monday, March 2, 2020 2:16 PM
To: RPG programming on the IBM i (AS/400 and iSeries) <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: challenging tasks? Got one to discuss?
A few days ago Jeff came up with a challenging task - not an everyday need, cool if we could do it, and yet very common in the non-i World. Plenty of discussion here, which is always good, right?
It looked like fun, here is my answer:
http://www.martinvt.com/Web_-__json/Latitude_-_Longitude/latitude_-_longitude.html
Location Response
Street 2800 37th St NW Latitude is 43.96728
City Rochester Longitude is -92.411514
State MN Trial 1 failed: SQL code 100
ZIP 55901 Trial 2 failed: SQL code 100
Which brings us to the point of this post: Anymore RPG challenges where a bit of lively discussion raises skill levels for many of us? A nagging project that needs attention but it's not clear where and/or how to start? Why not put it out here for us to look at?
(disclaimer: yes, this is a blatant appeal for a challenging task; it keeps me out of the beer halls and back alleys. :) I'm not looking for money or responsibility, just something to bat away the boredom.
--
Booth Martin
www.martinvt.com
(870)576-9371
(802)461-5349
Beauty and harmony are as necessary to you as the very breath of life.
midrange.com
