Results 1 to 6 of 6

Thread: Cobol Data file to SQL Table conversion

  1. 07-08-1999, 01:41 PM #1
    Monoos Guest

    Cobol Data file to SQL Table conversion


    I am a novice in data base designing. I have MS certification in both design, implementation and administration. Can anyone help me provide information regarding converting from Cobol flat files to sql server tables ?
    I will be very grateful.. This is my first assignment.. Got to prove myself... help....
  2. 07-08-1999, 04:28 PM #2
    Dano Guest

    Cobol Data file to SQL Table conversion (reply)

    BOOKS ONLINE... BCP. Bulk Copy Program.
    One warning: After making your *.fmt file it is sometimes easier to change all data types to SQLCHAR. BCP will still let you put non-char values into appropriate field structures. If using SQL 7 you should read about DTS Data Transformation Service.
    (MS cert hugh?)


    ------------
    Monoos at 7/8/99 2:41:03 PM


    I am a novice in data base designing. I have MS certification in both design, implementation and administration. Can anyone help me provide information regarding converting from Cobol flat files to sql server tables ?
    I will be very grateful.. This is my first assignment.. Got to prove myself... help....
  3. 07-09-1999, 06:58 PM #3
    {;} Guest

    Cobol Data file to SQL Table conversion (reply)

    That is a bull.... you CAN NOT pass SQL test if you don't know how to do this. I can bet on that.


    ------------
    Monoos at 7/8/99 2:41:03 PM


    I am a novice in data base designing. I have MS certification in both design, implementation and administration. Can anyone help me provide information regarding converting from Cobol flat files to sql server tables ?
    I will be very grateful.. This is my first assignment.. Got to prove myself... help....
  4. 07-12-1999, 02:25 PM #4
    Jagan Rao Guest

    Cobol Data file to SQL Table conversion (reply)

    SQL Server can&#39;nt recognize cobol flat files. You will have to convert cobol flat files to sequential format with column delimeters and end-of-row <CR> which gives you a text data file. I am sure there are some tools available for this kind of conversion. Also make sure there are no non-printable characters in the text data file.

    Then you can use BCP or DTS to export into SQL.

    Jagan
  5. 04-01-2014, 10:19 AM #5
    NinjaLord
    NinjaLord is offline Registered User
    Join Date
    Apr 2014
    Posts
    2
    IRI NextForm has an Eclipse GUI to map data in COBOL and other flat file formats into SQL Server and other RDBs.
  6. 04-01-2014, 12:37 PM #6
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Reviving a 15 years old thread
    http://databaseandstorage.blogspot.com
    http://gotodba.weebly.com
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules