Category Archives for "DDS"

0 An old AS400 Quiz willed with technical questions and plain old fashioned AS/400 brainteasers

So, last night I was nosing around in the dim dark corners of an old network share on my homeserver. I stumbled across an old TXT document from the late 90’s, I think. It was sitting in a text file called “AS400 Quiz Brainteasers” -it’s obviously old (look at the as400 model numbers question). It […]

0 Upgrade from PF to DDL (SQLSTM) using TURNOVER from UNICOM SOFTLANDING

When you do the RUNSQLSTM to create your SQL Objects – Do not qualify library names but use the Turnover variables just like you would define PDM variables: ? RUNSQLSTM SRCFILE(“&SL”/”&SF” SRCMBR(“&SM”) COMMIT(*NONE) NAMING(*SYS) DFTRDBCOL(“&LI”) Turnover uses the DFTRDBCOL column “&LI” to populate the other *library* variables. DFTRDBCOL(NLITTEN) Most shops I’ve been to use QSQLSRC […]

0 Adding bar codes to good old fashioned spool reports | AS400 RPG BARCODE OVERLAY

Have you been asked to add a part number as a barcode to an existing warehouse report? Does the report currently print as an old fashioned text based spool that looks like it came from the 1980’s? Is this program written in RPG? Is the Printer file defined in DDS? If the answer to these […]

0 Modernizing AS400 Green Screens

Modernizing AS400 aka WEB-ENABLING AS400 and iSeries Converting an old green screen application to run in a website is as easy as typing an email or uploading a photo to facebook. If you are a modern IBM i Software developer the chances are, your system has lots of old AS400 and iSeries that code that […]

0 Interview Question and Answer – AS400 things you should know

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 MISCELLANEOUS How do you combine two record formats […]

0 IBM i SQL vs DDS – Is SQL faster than CPYF Native IO?

For the longest time I’ve heard about the performance difference between a true SQL INDEX and a DDS ACCESS PATH generated index on the IBM i operating system (or ‘OS400’ which was a ten year old, but very commonly used version of the the same OS). But is it true? I know that SQL creates […]

0 “IBM I Cocoa” is the new Java

Glendale, CA – Cocoa is a hot new programming language developed by Nestle Microsystems. The language was originally designed for programming hot chocolate machines but Nestle soon realized that the language had the potential to do much more. Because it is “architecture neutral” it can run on any device with a microchip including PCs, the […]

0 IBM i DDS Edit Codes

0 RPG SQL: load all subfile has fixed size of 9999 records

What is a load all subfile? A load all subfile is one in which we generally specify the subfile size as 9999 in the record format itself. However, you may define the subfile size to be less than 9999 in the record format and still load all your subfile at a time. In that situation […]