in reply to Re^2: Sybase::BCP
in thread Sybase::BCP

OK - off hand that looks good. Can you load that file using the normal bcp command? And when you load it via Sybase::BCP do you get all NULLs, or just one of the columns?

Michael

Replies are listed 'Best First'.
Re^4: Sybase::BCP
by jilltw (Initiate) on Nov 03, 2004 at 15:05 UTC
    I did a bcp of the file (/tmp/css.txt) into the DB from the Unix command line & the file loaded properly, all 63 rows as they should be. This was walking through the interactive BCP utility, and I saved off the format file it created.

    When I use the perl script with Sybase::BCP, then isql from the command line to do "select * from tmp_site_term" all I see are NULLS in both columns.

    Thanks.
[reply]
      OK - two more things for you to test:

      First, try the same thing with Sybase::BLK instead of Sybase::BCP. BLK uses the CT-lib based API which is required if your target table has any new features (such as row-level locking). The Sybase::BLK module has the same syntax as Sybase::BCP.

      Second, try loading the data via bcp using this command line: 

      bcp db..table in tmpfile -c -Uuser -Ppwd -Ssrv

      [download]
      (obviously using correct values for "db", "table", etc.) That should mimic what Sybase::BLK will try to do (i.e. split on the tab and use \n for the row separator).

      Michael

      update Sybase::BLK is part of sybperl, so you should already have it installed...

[reply]
[d/l]
        Well, the good news is that the bcp from the command line works fine... 63 rows of data loaded properly.

        The bad news is, we apparently do not have Sybase::BLK installed on our system. Changing my code to: 
        use Sybase::BLK;

$bcp = new Sybase::BLK $user, $pwd, $server, $appname;
$bcp->config(INPUT => $tmp_file,
             OUTPUT => 'css..tmp_site_term',
             ERRORS => 'bcp_errors');
$bcp->run;

        [download]
        I get an error: Can't locate Sybase/BLK.pm in @INC (@INC contains: /usr/perl5/5.00503/sun4-solaris /usr/perl5/5.00503 /usr/perl5/site_perl/5.005/sun4-solaris /usr/perl5/site_perl/5.005 .)

        Should I pursue using the other bcp routines?
[reply]
[d/l]

In Section Seekers of Perl Wisdom