SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 BCP Packed Format		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

viral0028
Starting Member

USA
3 Posts
Posted - 08/10/2012 :  17:37:37  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

Germany
8515 Posts
Posted - 08/10/2012 :  18:06:22  Show Profile  Visit webfred's Homepage  Reply with Quote
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.
Go to Top of Page

viral0028
Starting Member

USA
3 Posts
Posted - 08/10/2012 :  18:20:59  Show Profile  Reply with Quote
Hi the data is comming form an SQL Table.

I have searched a lot but didnt get anything :(

Thanks,
Viral Patel
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000