Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-05-30 : 09:23:48
|
| J McRay writes "Download pay records from IBM 390 (Legacy mainframe) running CICS table to flat file to MS SQL table. Records are copied daily from IBM CICS tables to a flat file. The character string is 320 character length. I need to read these records into a SQL pre-defined table. Unfortunately, the dollar amount field is a packed field. I could write a program on the main side to unpack the dollar amount field before it is writen to a flat file or read the flat file and unpack the dollar amount field into another flat file and then download directly into SQL. I have heard two sides, please clarify the truth; Can SQL accept packed numeric fields or the ability to un-pack? I need to find a way to converse with an old IBM 390 running the old CICS tables.Thank you for any assistance.PS I looked at CHAR and strings, but not certain." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-05-30 : 09:25:23
|
| The packed decimal type does not have an equivalent in SQL Server. My advice is to unpack it to a text file and import to SQL Server, or, if you can find an ODBC driver for the IBM 390, you can maybe use Data Transformation Services (DTS) to copy the data directly into SQL Server. |
 |
|
|
|
|
|
Convert packed ASCII to SQL