Category Archives for "DDS"

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 […]

Continue reading

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 […]

Continue reading

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 […]

Continue reading

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

as400 ddl vs dds

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 […]

Continue reading

“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 […]

Continue reading