Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2007
    Posts
    2

    Question Unanswered: Any possibility for BCPing selected columns

    We're using Sybase ASE 15.0

    Is there any possibility to BCP selected columns of a table only
    or
    Any possibility to read NULL values into some columns

  2. #2
    Join Date
    Sep 2008
    Posts
    40

    Smile

    you can take bcp out of selected columns only through view hope no other way

  3. #3
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    Also have a look at the sqsh and its \bcp command.

  4. #4
    Join Date
    Jan 2009
    Posts
    2
    Why don't you use some open source & freely avail tool, for doing this ? You can extract whatever you need & load it to where ever you want.

    I am fond of one such tool , which is a good alternative for me for BCP.
    Check this out -
    Proposing a Pentaho solution - automated/scheduled ETL job - Pentaho Community Forums

    Regards,
    Kedar

  5. #5
    Join Date
    Dec 2007
    Posts
    2

    Exclamation

    I need to use BCP in Solaris environemnt and i'm not having constraint to use BCP only ....
    @All replied to my query ..
    Thanks for your suggestions


    Quote Originally Posted by kedar mehta
    Why don't you use some open source & freely avail tool, for doing this ? You can extract whatever you need & load it to where ever you want.

    I am fond of one such tool , which is a good alternative for me for BCP.
    Check this out -
    Proposing a Pentaho solution - automated/scheduled ETL job - Pentaho Community Forums

    Regards,
    Kedar

Posting Permissions

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