Category Archives for "RPG"

Use RDi to make RPGLE lowercase

Internet fact #173 – If you make RPGLE lowercase it looks a lot prettier! If you’ve ever read any of my many waffling techno-blogs about programming with the RPG language you will know that I have a bit of a love/hate relationship IBM’s Rational Developer code editor. But, just sometimes it does really small, but […]

 
Continue reading

RPG Programmers #winning

When I was a lad – you read the newspaper for news, you talked to neighbors to network and find the local gossip, you watched TV or went to the Cinema for movies. Nowadays, it’s all done on computers and it’s us programmers that create, nurse and stroke this things called computer programs. How you […]

 
Continue reading

Send IBM i Email including SQL Table Data automatically

Have you ever wanted to extract some data out of an IBMi/AS400 file using SQL and then email that data to someone as an Excel Spreadsheet? Now you can… all from one IBMi command without having to write any CL code to do it. Projex4i: DSTDTA command now handles SQL STRINGS for selecting data I […]

 
Continue reading
1

Update an IBM i file with SQL cursor using SQLRPGLE WHERE CURRENT OF

Using SQL in RPGLE programs is easier than you think. Making the move from RPG native file IO to SQL database IO is really quite straightforward.  Changing from good old READE loops to SQL FOR Loops simply means using the SQL CURSOR function. SQL has a groovy way of referring to what the stuff that […]

 
Continue reading

Green Screen to Web Application in 5 minutes (aka how the AS400 got on the World Wide Web with IBM i)

Twenty years ago… I was typing on a dumb terminal, connected to a great big beige computer called IBM AS/400 with a thick grey Twinax cable. Screens were green on black, text only — or sometimes orange on black if you were posh. The internet was this thing we used to send emails (if you knew […]

 
Continue reading

How to Debug HTTPAPI RPG Programs – dsplnk ‘/tmp/httpapi_debug.txt’

If you are using the IBM i HTTPAPI (LIBHTTP) opensource utilities, you already realize how easy it is to talk to an internet webservice from within your IBM i RPG programs. But sometimes even the best laid plans go wrong and thats when you need to learn how about the “debug HTTPAPI webservices” function. Assuming […]

 
Continue reading

RPG Program Source Code – Clever or Clear?

I’ve been working on an interesting project focused on taking some old RPG code and re-factoring it to make it more efficient. Fascinating work for a client that is focused on doubling its IBM i throughput and reducing the CPU load of all its old programs. This has frequently made me choose between writing a […]

 
Continue reading
1 2 3 13