Hi,
I'm trying to use:
maas34:eedalf {102} perl -v
This is perl, v5.6.0 built for sun4-solaris
...
maas34:eedalf {105} perl -MDBI -e 'print $DBI::VERSION'
1.14
maas34:eedalf {108} perl -MDBD::ODBC -e 'print $DBD::ODBC::VERSION'
0.28
on a:
maas34:eedalf {109} uname -a
SunOS maas34 5.6 Generic_105181-23 sun4u sparc SUNW,Ultra-5_10
in order to access a Centura SQLBase 7.5 hosted on a Windows NT 4
machine via the dbish and Easysoft OOB (trial version):
maas34:easysoft {115} grep version /opt/local/odbc-bridge/easysoft/oob_install.info
version:
/home/products/build/sun4-sunos5.6/perl_modules-5.6.0/odbc-odbc-bridge-1.0.0.23.sunos-sparc
and it kind of works: I am able to issue SQL queries.
But often the results of the queries look mangled.
For example, if you look below, the column CNA_ID seems
to be overwritten (by the NOTE_BOOK column maybe?
mssweb@dbi:ODBC:SOURCE1> select CNA_ID from cn_a where cna_id='000228'/
CNA_ID
'000228'
[1 rows of 1 fields returned]
mssweb@dbi:ODBC:SOURCE1> select * from cn_a where cna_id='000228'/
CNA_ID,CNA_CODE,SYSTEM_TYPE,AS_ABBR,CNA_NO,CNA_LEVEL,LAST_ACA_NO,LAST_ECA_NO,LAST_SCA_NO,CNA_STATUS,CNA_REL_DATE,CNA_DOC,CNA_DOC_LANG,CNA_DOC_REV,CONV_FROM,CNA_TEXT,CNA_OLD_ID,FILE_NAME,NOTE_BOOK,LAST_DEL_NO,CNA_REV,SEQ_NO,INHR_FROM_ID,LAST_MCA_NO,LCL_LAST_ECA_NO,LCL_LAST_MCA_NO,INHR_FROM_CODE,CNA_MAPP_ID,BMT_NO
LSV24 ref
.','10','11',undef,undef,'0','0','0',undef,undef,undef',undef,'NA','na','NA','MSS','na','CM5RR','CN000228','LSV23
ref imported will be replaced by LSV24 to start prep for INDUS
[1 rows of 29 fields returned]
And if I select the NOTE_BOOK column alone, it looks
like the text is being written line by line, but on
the same row:
mssweb@dbi:ODBC:SOURCE1> select NOTE_BOOK from cn_a where cna_id='000228'/
NOTE_BOOK
LSV24 ref .'ported will be replaced by LSV24 to start prep for INDUS
[1 rows of 1 fields returned]
Here are my questions, maybe someone can help me
1) I wonder how to fix the above problem?
2) "perldoc DBI::Shell" mentions a possibility to set/get
$dbh-attributes, but how do I actually do it, for example
for LongTruncOk or LongReadLen?
3) Is there a way to stop fetching results (like ^C in
sqsh or isql of Sybase?). Trying ^C kills dbish
4) I have:
maas34:eedalf {106} perl -MData::ShowTable -e 1
maas34:eedalf {107}
but it doesn't seem to be used (see the ugly output above), why?
Besides the above problems, I think that DBI::Shell and dbish
are great things. They'll probably save me from installing
Win NT 4, SQLBase and SQLsomething in order to just being able
to send few SQL commands while I'm developing a CGI-script...
Regards and thank you in advance!
Alex
PS: Is lists.perl.org down?
