BCP "HOW-TO"?

BCP "HOW-TO"?

Post by HJ » Tue, 13 Mar 2001 00:38:55



Hi all! :)

    Does anyone knows where I can find a BCP how-to? (Yes I've read the
on-line docs "Books OnLine")
    I'm looking for something else.
    Thank you for trying help me.

    HJ

 
 
 

1. Nasty SybPerl/bcp "bad free()" problem

I'm having an intermittent problem with bcp's from within SybPerl.
Namely, I get

  [...]
  bcp_sendrow($dbp, ucssc, aeib)...Done.
  bcp_sendrow($dbp, ucssc, aemx)...Done.
  bcp_sendrow($dbp, ucssc, aetc)...Done.
  bcp_done($dbp)...Bad free() ignored at /usr/local/kb/lib/kbsupport.pl \
    line 1264.
  Done.
  Done.
  bcp_sendrow($dbp, all, abbj)...Done.
  bcp_done($dbp)...Bad free() ignored at /usr/local/kb/lib/kbsupport.pl \
    line 1264.
  Done.

After all this, it usually ends in:

  Segmentation Fault (core dumped)

(Ah... didn't that feel better?)  The associated code is:

  &'bcp_init($main'dbp, $tt, '', "$tt.err", $main'DB_IN);
  &'bcp_meminit($main'dbp, 2);

    ($domain, $docid) = &domain_docid($_);
    print STDERR "bcp_sendrow(\$dbp, $domain, $docid)...";
    &'bcp_sendrow($'dbp, $domain, $docid);
    print STDERR "Done.\n";
  }
  print STDERR 'bcp_done($dbp)...';
  $ret = &'bcp_done($main'dbp);
  print STDERR "Done.\n";

Anyone had this and know what the problem is?  I'm guessing that it's
a compilation problem with Perl/SybPerl, but it could be a server
configuration problem, too.  I'm too new to this stuff to start
guessing...

FYI, the system is Sybase R10 under Solaris 2.3 (SPARCstation 20).

 -Scott

2. Can a pl/perl function return NULL?

3. max of ("...","...","..")

4. FMP 6 and OS 10.2

5. sa CAN "xp_cmdshell bcp blabla", other users cannot

6. Methinks I have an undocumented Microsoft SQLTRACE bug

7. BCP - text qualifiers ""

8. Data Environment

9. "function sequence error" with BCP

10. problem with the command "bcp"

11. BCP lockup with multiple "text" columns

12. "bcp" question

13. bcp text file with "" identifiers