Results 1 to 6 of 6

Thread: Cobol Data file to SQL Table conversion

  1. #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. #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. #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. #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. #5
    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. #6
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932

Posting Permissions

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