Results 1 to 2 of 2

Thread: sybase newbie

  1. #1
    Join Date
    Feb 2004
    Posts
    143

    Question Unanswered: sybase newbie

    Hi,
    I am an Oracle guy new to sybase. The sybase version I am using is 11. The sybase database client I use to query tables is SQL Advantage. How can I produce an ascii text file of my table with the fields delimited by |(pipe).
    What actually I am trying to do here is produce the pipe delimited file of the data which I can use to load into Oracle(using Oracle's sql loader)
    Any tips is appreciated

    Thanks

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Look into the bcp utility. Although, I am not sure what changes were made since 11.0, or if documentation even exists for it anymore.

Posting Permissions

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