CS-LIBRARY error:
        comn_get_cfg: user api layer: internal common library error: Configuration 
        section isql not found.

[isql] 
	CS_APPNAME=testappname
	CS_HOSTNAME=testhost

1> select program_name, hostname from sysprocesses where spid=@@spid
2> go
 program_name                   hostname
 ------------------------------ ------------------------------
 testappname                    testhost

(1 row affected)

1> create table this_is_a_kinda_long_table_name (a int)
2> go
Msg 103, Level 15, State 205
Server 'SYB155', Line 1
The identifier that starts with 'this_is_a_kinda_long_table_nam' is too long. 
Maximum length is 30.

use my_db
go
create function f_slow
  returns int 
as 
   waitfor delay '00:00:00.1'
   return 0
go
create table t (a int, b as my_db.dbo.f_slow() materialized)
go

use my_db
go
create function f_slow  
  returns int 
as 
   waitfor delay '00:00:00.1'
   return 0
go
create table t (a int, b as my_db.dbo.f_slow())
go

use my_db
go
create function f_slow (@i int)
  returns int 
as 
   waitfor delay '00:00:00.1'
   return @i
go
create table t (a int, b as my_db.dbo.f_slow(a))
go
create view v (a,b)
as
   select b, a from t
go

create table time2wait (tm varchar(10))
insert time2wait values ('00:00:02')
go

create function f_slow (@i int) 
  returns int 
as 
	declare @w varchar(10) 
	select @w = tm from time2wait 
	waitfor delay @w 
	return @i
go

use my_db
go
create function f_slow (@i int)
  returns int 
as 
   waitfor delay '00:00:00.1'
   return 0
go
create table t (a int)
go
create index ix_slow on t ( my_db.dbo.f_slow(a) )
go

1> select substring('abc', 1, 3)
2> go

 ------
 abc

(1 row affected)

% isql -Usa -P -S ASE1254 
Msg 2401, Level 11, State 2:
Server 'ASE1254':
Character set conversion is not available between client character set 'utf8'
and server character set 'iso_1'.
No conversions will be done.
1> 

% isql -Usa -P -S ASE155     # uses utf8
1> select substring('abc', 1, 3)
2> go

 ------
 abc

(1 row affected)
1> exit
%
%
% isql -Usa -P -S ASE155 -Jiso_1    # uses iso_1
1> select substring('abc', 1, 3)
2> go

 ---
 abc

(1 row affected)
1> exit
%

create proc p
as
  declare @cnt int
  set @cnt = 0

  while @cnt < 10000
  begin
	  select * from my_tab
	  set @cnt = @cnt + 1
  end
go

exec p
go 

select * from my_tab
go 10000

• Collegue #1: "isql isn't sending the batch 10,000 times, it's sending it only once and it gets executed 10,000 times at the server."

• Collegue #2: "When you use 'go 10000', only the result set of the last query is sent back to the client, so there is much less network traffic which explains why the stored proc is slower."

• Collegue #3: "The stored procedure is slower because it is generating more DONE_IN_PROC TDS tokens, causing additional overhead."

use master
go

-- this is needed to make sure the error message is displayed 
-- in case of a script abort
set flushmessage on
go

-- check database 'PROD' exists:
if not exists (select * from dbo.sysdatabases where name = 'PROD')
begin
    print "We seem to have a problem: database 'PROD' does not exist."
    print "Aborting..."

    -- now terminate the script:
    select syb_quit()
    -- this line is never reached!
end
go

-- OK, the database seems to exist...
use PROD
go
-- but we need to verify we can actually *use* this database
if db_name() != 'PROD'
begin
    print "We seem to have a problem: I cannot access database 'PROD'."
    print "Aborting..."

    -- now terminate the script:
    select syb_quit()
    -- this line is never reached!
end
go

...rest of SQL script...

% isql -U my_login -P mysecr3t -S PROD_SERVER -i my_sql_script.sql
We seem to have a problem: database 'PROD' does not exist.
Aborting...
CT-LIBRARY error:
        ct_results(): network packet layer: internal net library error: 
Net-Library operation terminated due to disconnect
%