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 |
|
viral0028
Starting Member
3 Posts |
 Posted - 2012-08-10 : 17:37:37
|
| Hi all,I am trying to export data to a text file. I have a decimal field. I need to convert it to COMP-3(Packed Decimal). As i need to pass this file to mainframe.Thanks,Viral Patel |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-08-10 : 18:06:22
|
You did not tell us from where the data is coming.The destination is a mainframe - aha.For me it sounds like a COBOL-Program should be used to read the text file.If that is true then the very easy way is: export to ascii file with decimal values as 00234.66 or whatever and then in a short fine COBOL-Program read that file and move the data "PIC 9(5)V99" to a "PIC 9(5)V99 COMP-3" field for example...
Too old to Rock'n'Roll too young to die. |
 |
|
|
viral0028
Starting Member
3 Posts |
Posted - 2012-08-10 : 18:20:59
|
| Hi the data is comming form an SQL Table.I have searched a lot but didnt get anything :(Thanks,Viral Patel |
|
|
|
|
|
|
BCP Packed Format