Tag Archives for " #SQL "

Sep 13

Varying Length fields in DDS and IBM i SQL

IBM i , AS400 , iSeries , 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, […]

More Waffle
1 2 3 4