IBM i, Programming, SQL

How to change a Files alternative name using IBM i SQL

SQL works very nicely on IBM i Servers — the added benefit is that we can access the database using SQL from other machines, access it using IBM SQL and also using Native (DB2) File IO. Note, SQL has some features that native database IO does not support – namely huge long table names (aka …

 Read More

iSeries, AS400, Authority, IBM i, Programming

AS400 Technical Interview Question and Answer – AS400 Database

Twenty years ago these are the kind of things you had to know to work on the old AS400 systems. I found these on an old dusty corner of my homeserver. Enjoy the trip down memory lane or to use old RPG lingo AS400NERD CABEQ ‘1’  START DATABASE FILES What are the different definition levels …

 Read More