Microsoft (R) Program Maintenance Utility Version 6.00.8168.0 Copyright (C) Microsoft Corp 1988-1998. All rights reserved. Installing C:\cpanrun-5.8\build\5-8-0\site\lib\DBI\Format.pm Installing C:\cpanrun-5.8\build\5-8-0\site\lib\DBI\Shell.pm Installing C:\cpanrun-5.8\build\5-8-0\site\lib\DBI\Shell\Completion.pm Installing C:\cpanrun-5.8\build\5-8-0\site\lib\DBI\Shell\FindSqlFile.pm Installing C:\cpanrun-5.8\build\5-8-0\site\lib\DBI\Shell\Spool.pm Installing C:\cpanrun-5.8\build\5-8-0\site\lib\DBI\Shell\SQLMinus.pm Installing C:\cpanrun-5.8\build\5-8-0\site\lib\DBI\Shell\Timing.pm Installing C:\cpanrun-5.8\build\5-8-0\site\lib\DBI\Format\CSV.pm Installing C:\cpanrun-5.8\build\5-8-0\site\lib\DBI\Format\SQLMinus.pm Installing C:\cpanrun-5.8\build\5-8-0\bin\dbish Installing C:\cpanrun-5.8\build\5-8-0\bin\dbish.bat Writing C:\cpanrun-5.8\build\5-8-0\site\lib\auto\DBI\Shell\.packlist Appending installation info to C:\cpanrun-5.8\build\5-8-0\lib/perllocal.pod DBI::Shell; ok 2 - require Text::Reform; ok 3 - Testing CSV plugin for dbish. Configuration file dbish_config. DBI::Shell 11.95 using DBI 1.601 /option editor=vim (was vi) /option sqlpath=.:C:\cpanrun-5.8/sql (was .) /option tmp_dir=/tmp (was undef) /option tmp_file=dbish2032.sql (was dbish2032.sql) Loaded plugins DBI::Shell::Timing Loaded plugins DBI::Shell::Completion Loaded plugins DBI::Shell::Spool commandline history written to C:\cpanrun-5.8/.dbish_history ok 4 - Create statement handler Connecting to 'dbi:ExampleP:' as ''... /option format=sqlm (was neat) Loaded plugins DBI::Shell::SQLMinus ok 5 - Connecting to source ok 6 - Change format to csv Current statement buffer: select nlink,ino,blocks,ctime,rdev from t ok 7 "nlink","ino","blocks","ctime","rdev" "1","0","","1204130140","2" "1","0","","1204130140","2" "1","0","","1204130140","2" "1","0","","1204130140","2" "1","0","","1204130140","2" "1","0","","1204130140","2" "1","0","","1204130140","2" "1","0","","1204130140","2" "1","0","","1204130140","2" "1","0","","1204130140","2" Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) ok 8 /option seperator=^ (was ,) ok 9 @dbi:ExampleP:> select nlink,ino,blocks,ctime,rdev from t "nlink"^"ino"^"blocks"^"ctime"^"rdev" "1"^"0"^""^"1204130140"^"2" "1"^"0"^""^"1204130140"^"2" "1"^"0"^""^"1204130140"^"2" "1"^"0"^""^"1204130140"^"2" "1"^"0"^""^"1204130140"^"2" "1"^"0"^""^"1204130140"^"2" "1"^"0"^""^"1204130140"^"2" "1"^"0"^""^"1204130140"^"2" "1"^"0"^""^"1204130140"^"2" "1"^"0"^""^"1204130140"^"2" Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) ok 10 /option seperator=| (was ^) ok 11 @dbi:ExampleP:> select nlink,ino,blocks,ctime,rdev from t "nlink"|"ino"|"blocks"|"ctime"|"rdev" "1"|"0"|""|"1204130140"|"2" "1"|"0"|""|"1204130140"|"2" "1"|"0"|""|"1204130140"|"2" "1"|"0"|""|"1204130140"|"2" "1"|"0"|""|"1204130140"|"2" "1"|"0"|""|"1204130140"|"2" "1"|"0"|""|"1204130140"|"2" "1"|"0"|""|"1204130140"|"2" "1"|"0"|""|"1204130140"|"2" "1"|"0"|""|"1204130140"|"2" Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) ok 12 Disconnecting from dbi:ExampleP:. ok 13 - Disconnect from source. ok t/func........1..0 # Skip Function tests not completed skipped all skipped: Function tests not completed t/shell.......1..51 ok 1 - use DBI::Shell; DBI::Shell 11.95 using DBI 1.601 ok 2 - Create new handler Connecting to 'dbi:ExampleP:' as ''... ok 3 - Connect to source Available drivers: DBM ExampleP File Gofer Mimer Multiplex Proxy Sponge ok 4 - Do drivers TABLE_CAT,TABLE_SCHEM,TABLE_NAME,TABLE_TYPE,REMARKS '.',undef,'.','TABLE',undef '.',undef,'..','TABLE',undef '.',undef,'blib','TABLE',undef '.',undef,'lib','TABLE',undef '.',undef,'t','TABLE',undef [5 rows of 5 fields returned] ok 5 - Do table_info TYPE_NAME,DATA_TYPE,COLUMN_SIZE,LITERAL_PREFIX,LITERAL_SUFFIX,CREATE_PARAMS,NULLABLE,CASE_SENSITIVE,SEARCHABLE,UNSIGNED_ATTRIBUTE,FIXED_PREC_SCALE,AUTO_UNIQUE_VALUE,LOCAL_TYPE_NAME,MINIMUM_SCALE,MAXIMUM_SCALE 'VARCHAR',12,1024,'\'','\'',undef,0,1,1,0,0,0,undef,0,0 'INTEGER',4,10,'','',undef,0,0,1,0,0,0,undef,0,0 [2 rows of 15 fields returned] ok 6 - Do type_info ok 7 - Do clear ok 8 - Recall results history ok 9 - Recall command history ok 10 - Recall history Defined commands, in alphabetical order: [/;]chistory display command history [/;]clear erase the current statement [/;]col_info display columns that exist in current database [/;]commit commit changes to the database [/;]connect connect to another data source/DSN [/;]count execute 'select count(*) from table' (on each table listed). [/;]current display current statement [/;]describe display information about a table (columns, data types). [/;]do execute the current (non-select) statement [/;]drivers display available DBI drivers [/;]edit edit current statement in an external editor [/;]exit exit [/;]format set display format for selected data (Neat|Box) [/;]get make a previous statement current again [/;]go execute the current statement [/;]help display this list of commands [/;]history display combined command and result history [/;]load load a file from disk to the current buffer. [/;]option display or set an option value [/;]perl evaluate the current statement as perl code [/;]ping ping the current connection [/;]primary_key_info display primary keys that exist in current database [/;]prompt change the displayed prompt [/;]quit exit [/;]redo re-execute the previously executed statement [/;]rhistory display result history [/;]rollback rollback changes to the database [/;]run load a file from disk to current buffer, then executes. [/;]save save the current buffer to a disk file. [/;]spool send all output to a disk file. usage: spool file name or spool off. [/;]table_info display tables that exist in current database [/;]trace set DBI trace level for current database [/;]type_info display data types supported by current server ok 11 - Help ... batch: 0 chistory_size: 50 command_prefix: [/;] command_prefix_end: ; command_prefix_line: / debug: 0 desc_format: partbox desc_show_columns: COLUMN_NAME,DATA_TYPE,TYPE_NAME,COLUMN_SIZE,PK,NULLABLE,COLUMN_DEF,IS_NULLABLE,REMARKS desc_show_long: 1 desc_show_remarks: 1 editor: vi format: neat home_dir: C:\cpanrun-5.8 init_autocommit: 1 init_trace: 0 prompt: dbi:ExampleP: rhistory_head: 5 rhistory_size: 50 rhistory_tail: 5 seperator: , sqlpath: . tmp_dir: undef tmp_file: dbish2032.sql user_level: 1 ok 12 - Options ... ok 13 - Have test file? Current statement buffer: select * from t ok 14 - Loading test file testsql.sql blksize,ctime,rdev,blocks,uid,dev,mtime,mode,name,size,nlink,atime,ino,gid '',1204130140,2,'',0,2,1204130140,16895,'.',0,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130143,16895,'..',0,1,1204130143,0,0 '',1204130140,2,'',0,2,1204130140,33206,'batch.t',731,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'core.t',1099,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'csv.t',1555,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'func.t',7117,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'shell.t',2977,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'spool.t',1640,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'sqlminus.t',15187,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'timing.t',5111,1,1204130140,0,0 [10 rows of 14 fields returned] ok 15 - Execute current buffer @dbi:ExampleP:> select * from t ok 16 - Get last command executed blksize,ctime,rdev,blocks,uid,dev,mtime,mode,name,size,nlink,atime,ino,gid '',1204130140,2,'',0,2,1204130140,16895,'.',0,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130143,16895,'..',0,1,1204130143,0,0 '',1204130140,2,'',0,2,1204130140,33206,'batch.t',731,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'core.t',1099,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'csv.t',1555,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'func.t',7117,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'shell.t',2977,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'spool.t',1640,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'sqlminus.t',15187,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'timing.t',5111,1,1204130140,0,0 [10 rows of 14 fields returned] ok 17 - Execute current buffer @dbi:ExampleP:> select * from t ok 18 - Get first command executed blksize,ctime,rdev,blocks,uid,dev,mtime,mode,name,size,nlink,atime,ino,gid '',1204130140,2,'',0,2,1204130140,16895,'.',0,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130143,16895,'..',0,1,1204130143,0,0 '',1204130140,2,'',0,2,1204130140,33206,'batch.t',731,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'core.t',1099,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'csv.t',1555,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'func.t',7117,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'shell.t',2977,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'spool.t',1640,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'sqlminus.t',15187,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'timing.t',5111,1,1204130140,0,0 [10 rows of 14 fields returned] ok 19 - Execute current buffer Current statement buffer: ok 20 - Save current buffer to file testsql.tmp ok 21 - Does testsql.tmp exists? ok 22 - Configuration file defined in environment Disconnecting from dbi:ExampleP:. Connecting to 'dbi:ExampleP:' as ''... ok 23 - Connect to source Current statement buffer: select * from t ok 24 - Load current buffer from testsql.sql blksize,ctime,rdev,blocks,uid,dev,mtime,mode,name,size,nlink,atime,ino,gid '',1204130140,2,'',0,2,1204130140,16895,'.',0,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130146,16895,'..',0,1,1204130146,0,0 '',1204130140,2,'',0,2,1204130140,33206,'batch.t',731,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'core.t',1099,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'csv.t',1555,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'func.t',7117,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'shell.t',2977,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'spool.t',1640,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'sqlminus.t',15187,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'timing.t',5111,1,1204130140,0,0 [10 rows of 14 fields returned] ok 25 - Execute current buffer ok 26 - Do commit ok 27 - Do rollback ok 28 - Set format to neat @dbi:ExampleP:> select * from t ok 29 - Last executed command blksize,ctime,rdev,blocks,uid,dev,mtime,mode,name,size,nlink,atime,ino,gid '',1204130140,2,'',0,2,1204130140,16895,'.',0,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130146,16895,'..',0,1,1204130146,0,0 '',1204130140,2,'',0,2,1204130140,33206,'batch.t',731,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'core.t',1099,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'csv.t',1555,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'func.t',7117,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'shell.t',2977,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'spool.t',1640,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'sqlminus.t',15187,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'timing.t',5111,1,1204130140,0,0 [10 rows of 14 fields returned] ok 30 - Execute current buffer ok 31 - Set format to box @dbi:ExampleP:> select * from t ok 32 - Last executed command +-------+----------+----+------+---+---+----------+-----+----------+-----+-----+----------+---+---+ |blksize|ctime |rdev|blocks|uid|dev|mtime |mode |name |size |nlink|atime |ino|gid| +-------+----------+----+------+---+---+----------+-----+----------+-----+-----+----------+---+---+ | |1204130140| 2| | 0| 2|1204130140|16895|. | 0| 1|1204130140| 0| 0| +-------+----------+----+------+---+---+----------+-----+----------+-----+-----+----------+---+---+ | |1204130140| 2| | 0| 2|1204130146|16895|.. | 0| 1|1204130146| 0| 0| +-------+----------+----+------+---+---+----------+-----+----------+-----+-----+----------+---+---+ | |1204130140| 2| | 0| 2|1204130140|33206|batch.t | 731| 1|1204130140| 0| 0| +-------+----------+----+------+---+---+----------+-----+----------+-----+-----+----------+---+---+ | |1204130140| 2| | 0| 2|1204130140|33206|core.t | 1099| 1|1204130140| 0| 0| +-------+----------+----+------+---+---+----------+-----+----------+-----+-----+----------+---+---+ | |1204130140| 2| | 0| 2|1204130140|33206|csv.t | 1555| 1|1204130140| 0| 0| +-------+----------+----+------+---+---+----------+-----+----------+-----+-----+----------+---+---+ | |1204130140| 2| | 0| 2|1204130140|33206|func.t | 7117| 1|1204130140| 0| 0| +-------+----------+----+------+---+---+----------+-----+----------+-----+-----+----------+---+---+ | |1204130140| 2| | 0| 2|1204130140|33206|shell.t | 2977| 1|1204130140| 0| 0| +-------+----------+----+------+---+---+----------+-----+----------+-----+-----+----------+---+---+ | |1204130140| 2| | 0| 2|1204130140|33206|spool.t | 1640| 1|1204130140| 0| 0| +-------+----------+----+------+---+---+----------+-----+----------+-----+-----+----------+---+---+ | |1204130140| 2| | 0| 2|1204130140|33206|sqlminus.t|15187| 1|1204130140| 0| 0| +-------+----------+----+------+---+---+----------+-----+----------+-----+-----+----------+---+---+ | |1204130140| 2| | 0| 2|1204130140|33206|timing.t | 5111| 1|1204130140| 0| 0| +-------+----------+----+------+---+---+----------+-----+----------+-----+-----+----------+---+---+ [10 rows of 14 fields returned] ok 33 - Execute current buffer ok 34 - Set format to string @dbi:ExampleP:> select * from t ok 35 - Last executed command blksize ctime rdev blocks uid dev mtime mode name size nlink atime ino gid 1204130140 2 0 2 1204130140 16895 . 0 1 1204130140 0 0 1204130140 2 0 2 1204130146 16895 .. 0 1 1204130146 0 0 1204130140 2 0 2 1204130140 33206 batch.t 731 1 1204130140 0 0 1204130140 2 0 2 1204130140 33206 core.t 1099 1 1204130140 0 0 1204130140 2 0 2 1204130140 33206 csv.t 1555 1 1204130140 0 0 1204130140 2 0 2 1204130140 33206 func.t 7117 1 1204130140 0 0 1204130140 2 0 2 1204130140 33206 shell.t 2977 1 1204130140 0 0 1204130140 2 0 2 1204130140 33206 spool.t 1640 1 1204130140 0 0 1204130140 2 0 2 1204130140 33206 sqlminus.t 15187 1 1204130140 0 0 1204130140 2 0 2 1204130140 33206 timing.t 5111 1 1204130140 0 0 [10 rows of 14 fields returned] ok 36 - Execute current buffer ok 37 - Set format to html @dbi:ExampleP:> select * from t ok 38 - Last executed command
blksizectime rdevblocksuiddevmtime mode name size nlinkatime inogid
1204130140 2 0 2120413014016895. 0 11204130140 0 0
1204130140 2 0 2120413014616895.. 0 11204130146 0 0
1204130140 2 0 2120413014033206batch.t 731 11204130140 0 0
1204130140 2 0 2120413014033206core.t 1099 11204130140 0 0
1204130140 2 0 2120413014033206csv.t 1555 11204130140 0 0
1204130140 2 0 2120413014033206func.t 7117 11204130140 0 0
1204130140 2 0 2120413014033206shell.t 2977 11204130140 0 0
1204130140 2 0 2120413014033206spool.t 1640 11204130140 0 0
1204130140 2 0 2120413014033206sqlminus.t15187 11204130140 0 0
1204130140 2 0 2120413014033206timing.t 5111 11204130140 0 0
[10 rows of 14 fields returned] ok 39 - Execute current buffer ok 40 - Set format to raw @dbi:ExampleP:> select * from t ok 41 - Last executed command blksize,ctime,rdev,blocks,uid,dev,mtime,mode,name,size,nlink,atime,ino,gid ,1204130140,2,,0,2,1204130140,16895,.,0,1,1204130140,0,0 ,1204130140,2,,0,2,1204130146,16895,..,0,1,1204130146,0,0 ,1204130140,2,,0,2,1204130140,33206,batch.t,731,1,1204130140,0,0 ,1204130140,2,,0,2,1204130140,33206,core.t,1099,1,1204130140,0,0 ,1204130140,2,,0,2,1204130140,33206,csv.t,1555,1,1204130140,0,0 ,1204130140,2,,0,2,1204130140,33206,func.t,7117,1,1204130140,0,0 ,1204130140,2,,0,2,1204130140,33206,shell.t,2977,1,1204130140,0,0 ,1204130140,2,,0,2,1204130140,33206,spool.t,1640,1,1204130140,0,0 ,1204130140,2,,0,2,1204130140,33206,sqlminus.t,15187,1,1204130140,0,0 ,1204130140,2,,0,2,1204130140,33206,timing.t,5111,1,1204130140,0,0 [10 rows of 14 fields returned] ok 42 - Execute current buffer ok 43 - Set format to neat @dbi:ExampleP:> select * from t ok 44 - Last executed command blksize,ctime,rdev,blocks,uid,dev,mtime,mode,name,size,nlink,atime,ino,gid '',1204130140,2,'',0,2,1204130140,16895,'.',0,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130146,16895,'..',0,1,1204130146,0,0 '',1204130140,2,'',0,2,1204130140,33206,'batch.t',731,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'core.t',1099,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'csv.t',1555,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'func.t',7117,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'shell.t',2977,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'spool.t',1640,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'sqlminus.t',15187,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'timing.t',5111,1,1204130140,0,0 [10 rows of 14 fields returned] ok 45 - Execute current buffer ok 46 - Set format to neat Negative number -1: Changed number 9: @dbi:ExampleP:> select * from t ok 47 - Get with -1 command blksize,ctime,rdev,blocks,uid,dev,mtime,mode,name,size,nlink,atime,ino,gid '',1204130140,2,'',0,2,1204130140,16895,'.',0,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130146,16895,'..',0,1,1204130146,0,0 '',1204130140,2,'',0,2,1204130140,33206,'batch.t',731,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'core.t',1099,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'csv.t',1555,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'func.t',7117,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'shell.t',2977,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'spool.t',1640,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'sqlminus.t',15187,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'timing.t',5111,1,1204130140,0,0 [10 rows of 14 fields returned] ok 48 - Execute current buffer Negative number -2: Changed number 9: @dbi:ExampleP:> select * from t ok 49 - Get with -2 command blksize,ctime,rdev,blocks,uid,dev,mtime,mode,name,size,nlink,atime,ino,gid '',1204130140,2,'',0,2,1204130140,16895,'.',0,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130146,16895,'..',0,1,1204130146,0,0 '',1204130140,2,'',0,2,1204130140,33206,'batch.t',731,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'core.t',1099,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'csv.t',1555,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'func.t',7117,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'shell.t',2977,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'spool.t',1640,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'sqlminus.t',15187,1,1204130140,0,0 '',1204130140,2,'',0,2,1204130140,33206,'timing.t',5111,1,1204130140,0,0 [10 rows of 14 fields returned] ok 50 - Execute current buffer Disconnecting from dbi:ExampleP:. ok 51 - Disconnect ok t/spool.......1..14 ok 1 - use DBI::Shell; ok 2 - Testing Spool plugin for dbish. Configuration file dbish_config. DBI::Shell 11.95 using DBI 1.601 /option editor=vim (was vi) /option sqlpath=.:C:\cpanrun-5.8/sql (was .) /option tmp_dir=/tmp (was undef) /option tmp_file=dbish2776.sql (was dbish2776.sql) Loaded plugins DBI::Shell::Timing Loaded plugins DBI::Shell::Completion Loaded plugins DBI::Shell::Spool commandline history written to C:\cpanrun-5.8/.dbish_history ok 3 - Create statement handler Connecting to 'dbi:ExampleP:' as ''... /option format=sqlm (was neat) Loaded plugins DBI::Shell::SQLMinus ok 4 - Connecting to source Current statement buffer: select nlink,ino,blocks,ctime,rdev from t ok 5 nlink,ino,blocks,ctime,rdev 1,0,'',1204130140,2 1,0,'',1204130140,2 1,0,'',1204130140,2 1,0,'',1204130140,2 1,0,'',1204130140,2 1,0,'',1204130140,2 1,0,'',1204130140,2 1,0,'',1204130140,2 1,0,'',1204130140,2 1,0,'',1204130140,2 [10 rows of 5 fields returned] Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) ok 6 @dbi:ExampleP:> spooling testspool.tmp ok 7 - Spooling testspool.tmp @dbi:ExampleP:> spooling output to file: testspool.tmp ok 8 - Spooling to testspool.tmp @dbi:ExampleP:> select nlink,ino,blocks,ctime,rdev from t ok 9 - Get command nlink,ino,blocks,ctime,rdev 1,0,'',1204130140,2 1,0,'',1204130140,2 1,0,'',1204130140,2 1,0,'',1204130140,2 1,0,'',1204130140,2 1,0,'',1204130140,2 1,0,'',1204130140,2 1,0,'',1204130140,2 1,0,'',1204130140,2 1,0,'',1204130140,2 [10 rows of 5 fields returned] Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) ok 10 - Execute current buffer ok 11 - Spool off @dbi:ExampleP:> not spooling ok 12 - Spool is off ok 13 - Created Spool file Disconnecting from dbi:ExampleP:. ok 14 - Disconnect ok t/sqlminus....1..109 ok 1 - use DBI::Shell; ok 2 - require Text::Reform; ok 3 - Testing SQLMinus plugin for dbish. Configuration file dbish_config. DBI::Shell 11.95 using DBI 1.601 /option editor=vim (was vi) /option sqlpath=.:C:\cpanrun-5.8/sql (was .) /option tmp_dir=/tmp (was undef) /option tmp_file=dbish2032.sql (was dbish2032.sql) Loaded plugins DBI::Shell::Timing Loaded plugins DBI::Shell::Completion Loaded plugins DBI::Shell::Spool commandline history written to C:\cpanrun-5.8/.dbish_history ok 4 - Create statement handler Connecting to 'dbi:ExampleP:' as ''... /option format=sqlm (was neat) Loaded plugins DBI::Shell::SQLMinus ok 5 - Connecting to source ok 6 - Change format to sqlminus ok 7 - List columns defined with formats fred: no column format defined. ok 8 - Show column format for fred nlink: no column format defined. ok 9 - Show column format for nlink format cleared ok 10 - Clear all column formats ok 11 ok 12 ok 13 ok 14 blocks column_format a20 format <<<<<<<<<<<<<<<<<<<< length 20 on 1 type char ctime column_format a20 format <<<<<<<<<<<<<<<<<<<< length 20 on 1 type char ino column_format a20 format <<<<<<<<<<<<<<<<<<<< length 20 on 1 type char nlink column_format a20 format <<<<<<<<<<<<<<<<<<<< length 20 on 1 type char ok 15 Current statement buffer: select nlink,ino,blocks,ctime,rdev from t ok 16 nlink ino blocks ctime rdev -------------------- -------------------- -------------------- -------------------- ---------- 1 0 1204130140 2 1 0 1204130140 2 1 0 1204130140 2 1 0 1204130140 2 1 0 1204130140 2 1 0 1204130140 2 1 0 1204130140 2 1 0 1204130140 2 1 0 1204130140 2 1 0 1204130140 2 Page Number: 0 [10 rows of 5 fields returned] Elapsed: 0 wallclock secs ( 0.02 usr + 0.00 sys = 0.02 CPU) @ 66.67/s (n=1) ok 17 ok 18 blocks column_format a20 format <<<<<<<<<<<<<<<<<<<< length 20 on 1 type char ctime column_format a20 format <<<<<<<<<<<<<<<<<<<< length 20 noprint 1 on 1 type char ino column_format a20 format <<<<<<<<<<<<<<<<<<<< length 20 on 1 type char nlink column_format a20 format <<<<<<<<<<<<<<<<<<<< length 20 on 1 type char ok 19 Current statement buffer: select nlink,ino,blocks,ctime,rdev from t ok 20 nlink ino blocks rdev -------------------- -------------------- -------------------- ---- 1 0 2 1 0 2 1 0 2 1 0 2 1 0 2 1 0 2 1 0 2 1 0 2 1 0 2 1 0 2 Page Number: 0 [10 rows of 5 fields returned] Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) ok 21 ok 22 Current statement buffer: select nlink,ino,blocks,ctime,rdev from t ok 23 nlink ino blocks ctime rdev -------------------- -------------------- -------------------- -------------------- ---------- 1 0 1204130140 2 1 0 1204130140 2 1 0 1204130140 2 1 0 1204130140 2 1 0 1204130140 2 1 0 1204130140 2 1 0 1204130140 2 1 0 1204130140 2 1 0 1204130140 2 1 0 1204130140 2 Page Number: 0 [10 rows of 5 fields returned] Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) ok 24 format cleared ok 25 ok 26 ok 27 ctime ---------- 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 Page Number: 0 [10 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) ok 28 ok 29 Page Number: 0 [10 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) ok 30 ok 31 ctime ---------- 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 Page Number: 0 [10 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) ok 32 ok 33 ctime ---------- 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 Page Number: 0 [10 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) ok 34 format cleared ok 35 ok 36 ctime ---------- 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 Page Number: 0 [10 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) ok 37 command: heading @dbi:ExampleP:> heading: undef ok 38 command: underline @dbi:ExampleP:> underline: null ok 39 - turn underline off ctime 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 Page Number: 0 [10 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) ok 40 command: underline @dbi:ExampleP:> underline: - ok 41 ctime ---------- 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 Page Number: 0 [10 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) ok 42 command: underline @dbi:ExampleP:> underline: undef ok 43 command: heading @dbi:ExampleP:> heading: on ok 44 ok 45 ctime column_format a10 format <<<<<<<<<< heading This is my heading length 10 on 1 type char ok 46 This is my undefunde- 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 Page Number: 0 [10 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) ok 47 command: underline @dbi:ExampleP:> underline: - ok 48 ok 49 New Headi- ---------- 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 Page Number: 0 [10 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) ok 50 column ctime format: column_format a10 format <<<<<<<<<< heading New Heading length 10 on 1 type char ok 51 format cleared ok 52 ctime ---------- 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 Page Number: 0 [10 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) ok 53 command: underline @dbi:ExampleP:> underline: - ok 54 ok 55 Underline test - -------------------- 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 Page Number: 0 [10 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) ok 56 command: underline @dbi:ExampleP:> underline: null ok 57 - Turn underline off ok 58 Underline test off 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 Page Number: 0 [10 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) ok 59 command: underline @dbi:ExampleP:> underline: on ok 60 ok 61 Underline test on ononononononononono- 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 Page Number: 0 [10 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) ok 62 ok 63 ok 64 ok 65 ok 66 ok 67 ok 68 invalid justification o ok 69 invalid justification on ok 70 invalid justification yuck ok 71 ok 72 invalid justification irhgt ok 73 ok 74 ok 75 ctime column_format a20 format >>>>>>>>>>>>>>>>>>>> heading Justify test j r justify r length 20 on 1 type char ok 76 format cleared ok 77 command: underline @dbi:ExampleP:> underline: - ok 78 command: heading @dbi:ExampleP:> heading: null ok 79 - Turn heading off command: heading @dbi:ExampleP:> heading: on ok 80 ok 81 Justify left -------------------- 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 Page Number: 0 [10 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) ok 82 ctime column_format a20 format <<<<<<<<<<<<<<<<<<<< heading Justify left justify l length 20 on 1 type char ok 83 ok 84 Justify right -------------------- 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 Page Number: 0 [10 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) ok 85 ctime column_format a20 format >>>>>>>>>>>>>>>>>>>> heading Justify right justify r length 20 on 1 type char ok 86 ok 87 Justify center -------------------- 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 Page Number: 0 [10 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) ok 88 ctime column_format a20 format ^^^^^^^^^^^^^^^^^^^^ heading Justify center justify c length 20 on 1 type char ok 89 ok 90 Justify off -------------------- 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 1204130140 Page Number: 0 [10 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) ok 91 ctime column_format a20 format <<<<<<<<<<<<<<<<<<<< heading Justify off length 20 on 1 type char ok 92 ctime column_format a20 format <<<<<<<<<<<<<<<<<<<< heading Justify off length 20 on 1 type char ok 93 format cleared ok 94 command: null @dbi:ExampleP:> null: 'stuff' ok 95 - Null value text tests command: null @dbi:ExampleP:> null: 'null ok 96 command: null @dbi:ExampleP:> null: "" ok 97 command: null @dbi:ExampleP:> null: &localtime() ok 98 command: null @dbi:ExampleP:> null: null ok 99 - set null off command: pagesize @dbi:ExampleP:> pagesize: null ok 100 - pagesize off command: pagesize @dbi:ExampleP:> pagesize: 10 ok 101 - set pagesize 10 command: pagesize @dbi:ExampleP:> pagesize: 10 ok 102 - is pagesize 10 command: limit @dbi:ExampleP:> limit: null ok 103 - row limit undef command: limit @dbi:ExampleP:> limit: 100 ok 104 - set row limit 100 command: limit @dbi:ExampleP:> limit: 100 ok 105 - row limit is 100 command: limit @dbi:ExampleP:> limit: null ok 106 - row limit is off DBD::ExampleP::db prepare failed: Unknown field names: yuck_error. Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) ok 107 last dbi error : 2000000000 last dbi error string : Unknown field names: yuck_error last dbi error state : S1000 ok 108 Disconnecting from dbi:ExampleP:. ok 109 - Disconnect from source. ok t/timing......1..77 ok 1 - use DBI::Shell; DBI::Shell 11.95 using DBI 1.601 /option editor=vim (was vi) /option sqlpath=.:C:\cpanrun-5.8/sql (was .) /option tmp_dir=/tmp (was undef) /option tmp_file=dbish2776.sql (was dbish2776.sql) Loaded plugins DBI::Shell::Timing Loaded plugins DBI::Shell::Completion Loaded plugins DBI::Shell::Spool commandline history written to C:\cpanrun-5.8/.dbish_history ok 2 - Create shell instance Connecting to 'dbi:ExampleP:' as ''... /option format=sqlm (was neat) Loaded plugins DBI::Shell::SQLMinus ok 3 - Connecting to dbi:ExampleP: Current statement buffer: select name from t where name = 'timing.t' ok 4 - Loading test file: testtiming.sql name '.' '..' 'batch.t' 'core.t' 'csv.t' 'func.t' 'shell.t' 'spool.t' 'sqlminus.t' 'timing.t' [10 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) ok 5 - Execute loaded statement ok 6 - Change output format to neat @dbi:ExampleP:> timing: off ok 7 - Turn timing OFF @dbi:ExampleP:> timing: off ok 8 - Timing is OFF @dbi:ExampleP:> select name from t where name = 'timing.t' ok 9 - Get the last statement executed name '.' '..' 'batch.t' 'core.t' 'csv.t' 'func.t' 'shell.t' 'spool.t' 'sqlminus.t' 'timing.t' [10 rows of 1 fields returned] ok 10 - Execute statement in buffer @dbi:ExampleP:> timing: on ok 11 - Turn timing ON @dbi:ExampleP:> timing: on ok 12 - Timing is ON @dbi:ExampleP:> select name from t where name = 'timing.t' ok 13 - Get the last statement executed name '.' '..' 'batch.t' 'core.t' 'csv.t' 'func.t' 'shell.t' 'spool.t' 'sqlminus.t' 'timing.t' [10 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) ok 14 - Execute statement in buffer @dbi:ExampleP:> timing: on ok 15 - Display timing status @dbi:ExampleP:> select name from t where name = 'timing.t' ok 16 - Get the last statement executed name '.' '..' 'batch.t' 'core.t' 'csv.t' 'func.t' 'shell.t' 'spool.t' 'sqlminus.t' 'timing.t' [10 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) ok 17 - Execute statement in buffer /option timing_timing=1 ok 18 - Check options: timing_timing /option timing_timing=1 (was 1) ok 19 - Check options: timing_timing=1 /option timing_timing=0 (was 1) ok 20 - Check options: timing_timing=0 @dbi:ExampleP:> timing: off ok 21 - Timing is OFF /option timing_timing=1 (was 0) ok 22 - Check options: timing_timing=1 @dbi:ExampleP:> timing: on ok 23 - Timing is ON @dbi:ExampleP:> timing: off ok 24 - Turn timing OFF @dbi:ExampleP:> timing: off ok 25 - Test timing is OFF @dbi:ExampleP:> timing: on ok 26 - Turn timing ON @dbi:ExampleP:> timing: on ok 27 - Test timing is ON @dbi:ExampleP:> timing: off ok 28 - Turn timing stop @dbi:ExampleP:> timing: off ok 29 - Test timing is OFF @dbi:ExampleP:> timing: on ok 30 - Turn timing start @dbi:ExampleP:> timing: on ok 31 - Test timing is ON @dbi:ExampleP:> timing: off ok 32 - Turn timing end @dbi:ExampleP:> timing: off ok 33 - Test timing is OFF @dbi:ExampleP:> timing: on ok 34 - Turn timing begin @dbi:ExampleP:> timing: on ok 35 - Test timing is ON /option timing_style=auto ok 36 - Current timing style options: timing_style /option timing_style=bad (was auto) ok 37 - Current timing style options: timing_style=bad @dbi:ExampleP:> select name from t where name = 'timing.t' ok 38 - Get the last statement executed name '.' '..' 'batch.t' 'core.t' 'csv.t' 'func.t' 'shell.t' 'spool.t' 'sqlminus.t' 'timing.t' [10 rows of 1 fields returned] Elapsed: 0 0 0 0 0 1 bad ok 39 - Execute statement in buffer /option timing_style=auto (was bad) ok 40 - Current timing style options: timing_style=auto @dbi:ExampleP:> select name from t where name = 'timing.t' ok 41 - Get the last statement executed name '.' '..' 'batch.t' 'core.t' 'csv.t' 'func.t' 'shell.t' 'spool.t' 'sqlminus.t' 'timing.t' [10 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) ok 42 - Execute statement in buffer /option timing_style=noc (was auto) ok 43 - Current timing style options: timing_style=noc @dbi:ExampleP:> select name from t where name = 'timing.t' ok 44 - Get the last statement executed name '.' '..' 'batch.t' 'core.t' 'csv.t' 'func.t' 'shell.t' 'spool.t' 'sqlminus.t' 'timing.t' [10 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) ok 45 - Execute statement in buffer /option timing_style=nop (was noc) ok 46 - Current timing style options: timing_style=nop @dbi:ExampleP:> select name from t where name = 'timing.t' ok 47 - Get the last statement executed name '.' '..' 'batch.t' 'core.t' 'csv.t' 'func.t' 'shell.t' 'spool.t' 'sqlminus.t' 'timing.t' [10 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.00 cusr + 0.00 csys = 0.00 CPU) ok 48 - Execute statement in buffer /option timing_style=none (was nop) ok 49 - Current timing style options: timing_style=none @dbi:ExampleP:> select name from t where name = 'timing.t' ok 50 - Get the last statement executed name '.' '..' 'batch.t' 'core.t' 'csv.t' 'func.t' 'shell.t' 'spool.t' 'sqlminus.t' 'timing.t' [10 rows of 1 fields returned] Elapsed: ok 51 - Execute statement in buffer /option timing_style=all (was none) ok 52 - Current timing style options: timing_style=all @dbi:ExampleP:> select name from t where name = 'timing.t' ok 53 - Get the last statement executed name '.' '..' 'batch.t' 'core.t' 'csv.t' 'func.t' 'shell.t' 'spool.t' 'sqlminus.t' 'timing.t' [10 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.00 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU) ok 54 - Execute statement in buffer /option timing_format=5.2f ok 55 - Current timing format options: timing_format /option timing_format=5.2f (was 5.2f) ok 56 - Current timing style options: timing_style=5.2f @dbi:ExampleP:> select name from t where name = 'timing.t' ok 57 - Get the last statement executed name '.' '..' 'batch.t' 'core.t' 'csv.t' 'func.t' 'shell.t' 'spool.t' 'sqlminus.t' 'timing.t' [10 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.00 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU) ok 58 - Execute statement in buffer /option timing_format=5.5f (was 5.2f) ok 59 - Current timing style options: timing_style=5.5f @dbi:ExampleP:> select name from t where name = 'timing.t' ok 60 - Get the last statement executed name '.' '..' 'batch.t' 'core.t' 'csv.t' 'func.t' 'shell.t' 'spool.t' 'sqlminus.t' 'timing.t' [10 rows of 1 fields returned] Elapsed: 0 wallclock secs (0.00000 usr 0.00000 sys + 0.00000 cusr 0.00000 csys = 0.00000 CPU) ok 61 - Execute statement in buffer /option timing_format=5d (was 5.5f) ok 62 - Current timing style options: timing_style=5d @dbi:ExampleP:> select name from t where name = 'timing.t' ok 63 - Get the last statement executed name '.' '..' 'batch.t' 'core.t' 'csv.t' 'func.t' 'shell.t' 'spool.t' 'sqlminus.t' 'timing.t' [10 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0 usr 0 sys + 0 cusr 0 csys = 0 CPU) ok 64 - Execute statement in buffer /option timing_format=1s (was 5d) ok 65 - Current timing style options: timing_style=1s @dbi:ExampleP:> select name from t where name = 'timing.t' ok 66 - Get the last statement executed name '.' '..' 'batch.t' 'core.t' 'csv.t' 'func.t' 'shell.t' 'spool.t' 'sqlminus.t' 'timing.t' [10 rows of 1 fields returned] Elapsed: 0 wallclock secs (0 usr 0 sys + 0 cusr 0 csys = 0 CPU) ok 67 - Execute statement in buffer /option timing_format=5.2f (was 1s) ok 68 - Resetting current timing_format=5.2f /option timing_prefix=Elapsed: ok 69 - Current timing prefix options: timing_prefix, Default /option timing_prefix="Timing: " (was Elapsed: ) ok 70 - Current timing prefix options: timing_prefix="Timing: " /option timing_prefix=\"Timing: \" (was "Timing: ") ok 71 - Current timing prefix options: timing_prefix=\"Timing: \" /option timing_prefix="Timing: " (was \"Timing: \") ok 72 - Current timing prefix options: timing_prefix="Timing: " /option timing_prefix=Timing: (was "Timing: ") ok 73 - Current timing prefix options: timing_prefix=Timing: /option timing_prefix=Timing: (was Timing:) ok 74 - Current timing prefix options: timing_prefix=Timing: /option timing_prefix='undef' (was Timing: ) ok 75 - Current timing prefix options: timing_prefix='undef' /option timing_prefix='undef' ok 76 - Current timing prefix options: timing_prefix, undefined Disconnecting from dbi:ExampleP:. ok 77 - Disconnect from source. ok All tests successful, 1 test skipped. Files=8, Tests=274, 5 wallclock secs ( 0.00 cusr + 0.00 csys = 0.00 CPU)