All posts by The Author

Welcome to SQL Server Tips

Welcome to the new updated SQL Server Tips site from SVEK Computing Ltd, we will try to give you a variety of interesting and usefull tips for SQL Server – from 2000 onwards.

We hope you like the updated version of this site

 

We are currently updating the content and all the original content should be available by 21st October 2011

COBOL Generated Files

Yes they still do exist in the new technological era – they contain a lot of the information that client server systems want! Whilst most versions of COBOL support the STRING verb, it’s rarely used in data migration (in my humble opinion) and most systems follow the sensible approach of using fixed field some with delimiters But we always have the following problems, what delimiter to use – well a radical answer – don’t use a delimiter keep it fixed format and map it using the cobol field definitions.

Saves all those unwelcome bytes of data between fields and the problems when someone sets up a name as c!o xyz corp #01234 456789 You’ve picked ! as the delimiter and suddenly you have an extra column in your data – same if you use # which will “never appear in the data”