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 |
|
prachi
Starting Member
1 Post |
 Posted - 2004-09-16 : 05:34:58
|
| Hi,Is there a method in which output from Mainframe - Cobol program can be uploaded in SQL server using DTS ? One of the fields from this ouput program contains cobol's COMP-3 field.regards,Prachi |
|
|
hgorijal
Constraint Violating Yak Guru
277 Posts |
Posted - 2004-09-17 : 00:34:36
|
| COMPs can't be handled in DTS. The output of the cobol program needs to be stored in a file; with char and numeric/decimal fields only.Hemanth GorijalaBI Architect / DBA... |
 |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2004-09-17 : 00:42:42
|
| Yip,To be more clear on that - your decimal fields must contain physical decimals (all fields must be display format)It's been a long time since I worked with cobol, but If I remember correctly your numeric fields will have to be declared as pic 99999.99 for example.In other words - your output file (from the cobol extract) should be very similar to a report.Duane. |
|
|
|
|
|
|
Cobol comp-3 convert using DTS