From AS/400 to iSeries to System i to IBM i on Power
Leave a ticket on the helpdesk if you cant find what you need or have a request for a new lesson or blog
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 …
IBM i, AS400, iSeries, Life, Programming
The AS/400 does not exist anymore Discussing a data interchange process with a software vendor today (who shall remain nameless), they told me: … our product talks to AS400 but I don’t think it has experience of iSeries or IBM i…. Customer Support Bloke for XYZ Company *sigh* I am not telling you the company …
Now, before you get all bent out of shape and point your grubby little index finger at me cackling “you called it an AS400 na-na-nu-na-naaah“, I do have a legitimate reason. It’s a shallow SEO based one (the grey haired brigade keep searching for “zip AS400 library”) but it’s legitimate. I only used the wrong …
IBM i, AS400, iSeries, Programming, RPG
Pointing at Pointers and laughing aka “How to Display Pointer Data” RPG has all kinds of different data types. In the olden days of RPG, we only really thought in terms of character variables and numeric variables (signed numeric and packed numeric). But as the language has advanced and adopted new technologies, methods of talking …
System Request 3 Here’s a blast from the past: I was just testing an IBM i program that is importing data from a Windows Server, converting the data, juggling it, tweaking it and when its finished playing it finally shoves it into an IBM i Database. Fun Fun FUN! But if its running interactive and …
Modernizing RPG Programs – Learn the RPG History first I had email email from an old work colleague this morning. He was a windows programmer, with limited exposure to RPG, but works in a company that is driven by a huge, old, complex RPG3 application that has changed little over the last decade. He is …
IBM i, IFS, Programming, SQL, Webservice
Most IBM i shops using webservices to talk to the Internet, will convert the data they are sharing into a web-service format like XML or JSON before sending it out. Obviously the responses will be in the same format and they need to convert it back into native IBM i format to use it. That …
Nice Subprocedures with RPG ON-EXIT IBM is adding all kinds of new tweaks to RPG with each new release of IBM i. RPG ON-EXIT is a great example of a neat tweak to the RPG programming language. Last year, IBM quietly introduced a rather neat new function called “ON-EXIT” to our sub procedures in RPG. …
Add a System to Connect to The first thing we wan to do is to add a System to use with ACS – so lets click “System Configurations” It’s easier to show you than to tell you:
...IBM i, AS400, iSeries, Life, Programming
Who uses the AS/400 anymore? I frequently see this question in places like Linkedin, Facebook and Quora, it’s both simple and complicated to answer. It’s Simple because the AS/400 just doesn’t exist anymore! I doubt anyone is using the old AS400 machines anymore…. they are over thirty years old. Complicated because (stupidly) many current day programmers …
STRSQL is not the only way to use SQL! SQL is a story in two parts — (1) IBM SQL is an interface to the data and (2) runtime SQL is part of the base operating system. IBM I Administrators often want to limit what SQL statements a user is allowed to run because how …
Do you think you know IBM i? IBM i 7.3 Announcement & Material IBM® DB2™ for i Temporal Support, enabling clients to conduct accurate analysis of data within a specific historical time period More advanced analytics capability driven by enhanced OLAP functionality, allowing clients to better forecast, define gaps and build new strategies for business …