Tag Archives for " #dds "

Varying Length fields in DDS and IBM i SQL

Back in the olden days – files were filled with numbers and long string of data. Words like SAUSAGES might have been stored as a 30 ALPHA field in the format “SAUSAGES______________________” which, even tho its padded with *blanks – is just wasting a lot of space. Nowadays, most systems use variable length fields, shorter, […]

 
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
as400 ddl vs dds

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

 
Continue reading