Mainframe Data Conversion
Posted on 2011-05-11
Here's what seems like a strange one (to me anyway). I have a file I exported from an IBM z/OS mainframe using IND$FILE to transfer it out. The file is created with a COBOL program that converts packed data and gets it into a format we can use in PC land. Not exactly sure of all the details but, that's it in a nutshell.
The resulting text file looks like it should. Pipe delimited text with no strange characters. Just letters and numbers and the occasional special character here and there. I have imported the file into Excel as text. Again, everything looks good.
The problem comes when I import into SQL using SSMS Import Data Wizard. The data is imported into my table and I can run queries against it in SSMS and everything looks great but, I run into trouble using the data in our ASP.NET application. Some reports work, others don't. It seems like it could be an issue with numbers which get converted to dates.
I have tested the application with other data which we exported preciously and everything looks and works correctly. As soon as I load our main table up with the new data, we run into trouble.
Does this sound familiar to anyone? Could it be something like a unicode or ascii issue or something? I'm lost. Any help would be greatly appreciated.