Quite often we have to create fixed length files to communicate with an IBM mainframe. We do this by creating fixed length columns outputted out of sql code. For example:

...