Characters after 255 getting truncated while using the DBLib package

ganeshm69 has asked for the wisdom of the Perl Monks concerning the following question:

I created a table TAB1 with column A, where A is varchar 400

 $query  = " select A from TAB1 ";

  my($DB) = Sybase::DBlib->dblogin( $User, $Password, $Server);
  $DB->dbuse( database );
  $DB->dbcmd($query);
  $DB->dbsqlexec;
  $DB->dbresults;
  
  while ( %dbdata = $DB->dbnextrow(1) )
  {
    foreach ( sort keys %dbdata )
    {
        my $CurColumn = $_;
        print $CurColumn;
                my $tempname = $dbdata{$CurColumn};
                print "[$tempname]\n";
    }
}
[download]

Comment on Characters after 255 getting truncated while using the DBLib package Download Code

Replies are listed 'Best First'.

Re: Characters after 255 getting truncated while using the DBLib package
by GrandFather (Saint) on Jul 10, 2007 at 23:51 UTC

The quick reference documentation for Sybase ASE 12.5 says in the Datatypes section:

varchar(n) char[acter] varying 255 characters or fewer

so varchar 400 would seem to illegal.

DWIM is Perl's answer to Gödel

[reply]
[d/l]

Re: Characters after 255 getting truncated while using the DBLib package
by Jenda (Abbot) on Jul 10, 2007 at 23:19 UTC

Any reason why you are not using DBI? I do believe you should "go with the crowd" and use DBI unless you really really need something that DBI+DBD::Sybase doesn't support.

Jenda
Support Denmark!
Defend the free world!

[reply]

Re: Characters after 255 getting truncated while using the DBLib package
by GrandFather (Saint) on Jul 10, 2007 at 23:02 UTC

You actually haven't given us very much to go on. No sample output. No indication of the table schema in the database. Inconsistent code (where does $CASHDB come from). Nothing we can run to reproduce your results (see I know what I mean. Why don't you? for hints).

I'd take a look at the column format for the field you are having trouble with. I'd guess it is limited to length 255.

Update: no indication that you have updated your node since the initial version of my reply.

DWIM is Perl's answer to Gödel

[reply]

Re: Characters after 255 getting truncated while using the DBLib package
by mpeppler (Vicar) on Jul 14, 2007 at 05:30 UTC

The solution is to move to Sybase::CTlib or DBI/DBD::Sybase, and make sure that you have OpenClient 12.5 or later installed (and available at build time).

I'll add that Sybase has been saying for the last 10 years or so that DBlib would not be updated to handle new features at the protocol level. Hence you should not be using DBlibrary.

Michael

[reply]


Just another Perl shrine
	PerlMonks