Hi All, I'm trying to connect to an oracle DB and extract 3 columns from, I need to extract only 1st 3 characters in each column. I used unpack. But, its not working.. Can someone help.. My code is as below.. 
#!/usr/bin/perl
#use strict;

use DBI;

my $user = "qwer";
my $passwd = "qwer";
my $server = "asdf";
my $database='rd_db';
my $dbd='Sybase';
my $an_dt_file = "an_dt_file";

# Connect to the database

my $dbh = DBI->connect($server,$user,$passwd,$dbd, {RaiseError => 1,Au
+toCommit => 1 });
# Prepare the SQL query for execution
my $sql = "SELECT $ans_rid, $ans_qcn, $ans_loc FROM ft_int_tbl WHERE $
+ans_rid is not null";
my $sth = $dbh->prepare($sql) or die "Couldn't prepare statement:$DBI:
+:errstr; stopped";

# Execute the query
$sth->execute() or die "Couldn't execute statement: $DBI::errstr; stop
+ped";
#open JKLL, ">$an_dt_file" or die "can't open file $ansb_detail_file f
+or write,\n";

# Fetch each row and print it
while ( my ($ans_rid, $ans_qcn, $ans_loc) = $sth->fetchrow_array() ) {
my ($ansb_cktid, $ansb_mcn, $ansb_soc) = unpack("A3 A3 A3", $_);
#print JKLL"Field 1: $ansb_cktid Field 2:$ansb_mcn Field 3: $ansb_soc 
+\n";
print "Field 1: $ansb_cktid Field 2:$ansb_mcn Field 3: $ansb_soc \n";

}

# Disconnect from the database
$dbh->disconnect();

[download]

In reply to Extracting only required length in a column in perl DBI by Thomas Kennll

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.