Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2009
    Posts
    8

    Question Unanswered: how to reformat the data in a format to bcp

    hi

    I have a file which is delimited by right curly bracket }.

    i need to fetch only few column values and bcp those values into a table, and that table contains some columns whose values doesnot exist in the input file , for those columns , a default value is given based on the column name .

    How can i reformat the data in a format to bcp into the table .

    Pls help .

  2. #2
    Join Date
    Feb 2007
    Location
    India
    Posts
    56
    Once you bcp out the file with delimeter. Use awk command to rearrange the data. And then bcp into the table.
    Regards,
    Naveen.
    Sybase DBA-Consultant

Posting Permissions

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