Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009
    Location
    New Delhi - India
    Posts
    22

    Unanswered: Sybase column separator

    Hi,
    I need a dump of my table with "KM"(2 characters) as field separator. On executing the below script, the fields are separated by "K"(only the first character reflects).
    How can I use two or more characters with -s option.


    isql -U$USER -P$PASS -S$SERV -D$DBNAME -w400 -b -s 'KK' -o ./out.dat << !

    select query
    go

  2. #2
    Join Date
    Nov 2002
    Location
    Ireland
    Posts
    6

    Use BCP

    You could use the BCP command to achieve this..

    e.g.
    bcp database..table out table.dat -S server -U username -P password -c -e error.log -tKM
    Pat

Posting Permissions

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