log=C:\src\logs.oltp25\1build_oltp_emul_25.log, err=C:\src\logs.oltp25\1build_oltp_emul_25.err                                                                                                                                             16:55
Check settings (read from config file oltp25_config.win)

Path to FB client: fbc = > C:\"Program Files (x86)"\Firebird\Firebird_2_5\bin<; version of isql:
ISQL Version: WI-V2.5.2.26539 Firebird 2.5

Server host = >127.0.0.1<, port = >3050<

Database name/alias: >C:\src\ab_demo.fdb<

User name and password: >SYSDBA< >masterkey<

Test connect and analyze engine version for matching to arg. >25<
Command to be executed now:

 C:\"Program Files (x86)"\Firebird\Firebird_2_5\bin\isql 127.0.0.1/3050:C:\src\ab_demo.fdb -nod -pag 0 -i C:\src\logs.oltp25\1build_oltp_emul_25.tmp -m -o C:\src\logs.oltp25\1build_oltp_emul_25.err -user SYSDBA -pas masterkey

Result:
Unable to open
All checks of isql temp log messages PASSED OK.

#################################################
Database will be created for FB  25 
#################################################

Press any key to START building database objects. . .
Content of building SQL script:
-------------------------------
show version;
show database;
set list on;
select * from mon$database;
set list off;
set echo on;
in "C:\src\oltp25_DDL.sql";
in "C:\src\oltp25_sp.sql";
in "C:\src\oltp_misc_debug.sql";
in "C:\src\oltp_main_filling.sql";
in "C:\src\oltp_data_filling.sql";
show collation;
show domain;
show exception;
show generator;
show table;
show view;
show trigger;
show proc;
-------------------------------

Build test database. Please wait. . .
-------------------------------------

C:\src>if .0. == .1. (C:\"Program Files (x86)"\Firebird\Firebird_2_5\bin\isql C:\src\ab_demo.fdb -nod -i C:\src\logs.oltp25\1build_oltp_emul_25.sql  1>C:\src\logs.oltp25\1build_oltp_emul_25.log 2>C:\src\logs.oltp25\1build_oltp_emul_25.err )
  else (C:\"Program Files (x86)"\Firebird\Firebird_2_5\bin\isql 127.0.0.1/3050:C:\src\ab_demo.fdb -nod -i C:\src\logs.oltp25\1build_oltp_emul_25.sql -user SYSDBA -pas masterkey  1>C:\src\logs.oltp25\1build_oltp_emul_25.log 2>C:\src\logs.olt
p25\1build_oltp_emul_25.err )

Script for building database objects finished with ERROR

Check log: C:\src\logs.oltp25\1build_oltp_emul_25.err

Press any key to FINISH this batch. . .

PROCEDURE ZKP_ANALIZ_PS ( 
 OMONTH INTEGER
 ) RETURNS ( 
 C0 INTEGER,
 C1 INTEGER,
 T1 VARCHAR( 200 ) CHARACTER SET WIN1251 ,
 T2 VARCHAR( 2 ) CHARACTER SET WIN1251 ,
 C2 NUMERIC( 7, 2 ),
 C3 NUMERIC( 7, 2 ),
 C4 NUMERIC( 7, 2 ),
 C5 NUMERIC( 7, 2 ),
 C6 NUMERIC( 7, 2 ),
 C7 NUMERIC( 7, 2 )
 )as 

DECLARE VARIABLE Decl_LS INTEGER = NULL;
DECLARE VARIABLE Decl_ID INTEGER = NULL;
DECLARE VARIABLE Decl_012 INTEGER = NULL;
DECLARE VARIABLE Decl_013 INTEGER = NULL;
DECLARE VARIABLE Decl_014 INTEGER = NULL;
DECLARE VARIABLE Decl_015 INTEGER = NULL;
DECLARE VARIABLE Decl_016 INTEGER = NULL;
DECLARE VARIABLE Decl_017 INTEGER = NULL;
DECLARE VARIABLE Decl_018 INTEGER = NULL;
DECLARE VARIABLE Decl_019 INTEGER = NULL;
DECLARE VARIABLE Decl_020 INTEGER = NULL;
DECLARE VARIABLE Decl_021 INTEGER = NULL;
DECLARE VARIABLE Decl_022 VARCHAR( 40 ) CHARACTER SET WIN1251  = NULL;
DECLARE VARIABLE Decl_KREDIT_023 NUMERIC( 12, 4 ) = NULL;
DECLARE VARIABLE Decl_KREDIT NUMERIC( 12, 4 ) = NULL;
DECLARE VARIABLE Decl_KREDIT_025 NUMERIC( 12, 4 ) = NULL;
DECLARE VARIABLE Decl_DEBET_026 NUMERIC( 12, 4 ) = NULL;
DECLARE VARIABLE Decl_DEBET NUMERIC( 12, 4 ) = NULL;
DECLARE VARIABLE Decl_DEBET_028 NUMERIC( 12, 4 ) = NULL;
DECLARE VARIABLE Decl_USENUM INTEGER = NULL;
DECLARE VARIABLE Decl_VDATE DATE = NULL;

BEGIN 

 C0 = 0;

 C2 = 0;

 C3 = 0;

 C4 = 0;

 C5 = 0;

 C6 = 0;

 C7 = 0;

SELECT    MONTH2LDATE.VDATE
FROM      MONTH2LDATE( :OMONTH )
INTO      :Decl_VDATE
;

FOR 
SELECT    G.KODNP,
          G.KODSTREET,
          G.HOUSE,
          G.CORPUS,
          G.KODSIMVOL,
          G.ID,
          G.AVGID,
          B.STREET
FROM      ZKP_GRPSCH G
           JOIN STREET B ON ( 
            G.KODSTREET = B.KODSTREET 
           ) 

WHERE     G.GRP IS NULL and  G."CLOSE" = 0   and  G.ACTDT <= :Decl_VDATE  
ORDER BY  B.STREET ASCENDING,
          G.HOUSE ASCENDING
INTO      :Decl_016,:Decl_017,
          :Decl_019,
          :Decl_020,
          :Decl_021,
          :Decl_012,
          :Decl_013,
          :Decl_022

 DO 
 BEGIN 

 Decl_ID = 0;

SELECT    FIRST ( 1 )
          ZKP_LS.ID
FROM      ZKP_LS
WHERE     ZKP_LS.KODNP = :Decl_016  and  ZKP_LS.KODSTREET = :Decl_017   and  ZKP_LS.HOUSE = :Decl_019   and  ZKP_LS.CORPUS = :Decl_020   and  ZKP_LS.KODSIMVOL = :Decl_021  
INTO      :Decl_ID
;

 Decl_LS = NULL;

FOR 
SELECT    ZKP_LSENUM.LS
FROM      ZKP_LSENUM( 0, NULL, NULL, :Decl_ID, NULL, 0 )
INTO      :Decl_LS

 DO 
 BEGIN 

 Decl_USENUM = NULL;

SELECT    FIRST ( 1 )
          ZKP_FLUSEN.USENUM
FROM      ZKP_FLUSEN
WHERE     ZKP_FLUSEN.LS = :Decl_LS  and  ZKP_FLUSEN.DATEZ <= :Decl_VDATE  
ORDER BY  ZKP_FLUSEN.LS DESCENDING,
          ZKP_FLUSEN.DATEZ DESCENDING
INTO      :Decl_USENUM
;

IF ( :Decl_USENUM IS NULL ) THEN 

 Decl_USENUM = 0;

IF ( :Decl_USENUM BETWEEN 20000  AND 29999  ) THEN 
 BEGIN

SELECT    ZKP_LSREPOBOR.KREDIT
FROM      ZKP_LSREPOBOR( :Decl_LS, :OMONTH, 0 )
INTO      :Decl_KREDIT
;

SELECT    ZKP_LSREPOBOR.DEBET
FROM      ZKP_LSREPOBOR( :Decl_LS,  :OMONTH + 1 , 0 )
INTO      :Decl_DEBET
;

 C4 =  :C4 + :Decl_KREDIT ;

 C5 =  :C5 + :Decl_DEBET ;

END --  BEGIN /IF ( :Decl_USENUM BETWEEN 20000  AND 29999  .../


IF ( :Decl_USENUM BETWEEN 30000  AND 39999  ) THEN 
 BEGIN

SELECT    ZKP_LSREPOBOR.KREDIT
FROM      ZKP_LSREPOBOR( :Decl_LS, :OMONTH, 0 )
INTO      :Decl_KREDIT_023
;

SELECT    ZKP_LSREPOBOR.DEBET
FROM      ZKP_LSREPOBOR( :Decl_LS,  :OMONTH + 1 , 0 )
INTO      :Decl_DEBET_026
;

 C2 =  :C2 + :Decl_KREDIT_023 ;

 C3 =  :C3 + :Decl_DEBET_026 ;

END --  BEGIN /IF ( :Decl_USENUM BETWEEN 30000  AND 39999  .../


IF ( :Decl_USENUM < 20000  or :Decl_USENUM > 39999  ) THEN 
 BEGIN

SELECT    ZKP_LSREPOBOR.KREDIT
FROM      ZKP_LSREPOBOR( :Decl_LS, :OMONTH, 0 )
INTO      :Decl_KREDIT_025
;

SELECT    ZKP_LSREPOBOR.DEBET
FROM      ZKP_LSREPOBOR( :Decl_LS,  :OMONTH + 1 , 0 )
INTO      :Decl_DEBET_028
;

 C6 =  :C6 + :Decl_KREDIT_025 ;

 C7 =  :C7 + :Decl_DEBET_028 ;

END --  BEGIN /IF ( :Decl_USENUM < 20000  or :Decl_USENUM > 39999 .../


END -- DO BEGIN /FOR SELECT    ZKP_LSENUM.LSFROM      ZK .../

IF ( :C2 <> 0  ) THEN 
 BEGIN

SELECT    GENADRSTR.ADR
FROM      GENADRSTR( :Decl_017, :Decl_019, :Decl_020, :Decl_021, 0, 0 )
INTO      :T1
;

 T2 = NULL;

IF ( not  :Decl_013 IS NULL  ) THEN 

 T2 = _WIN1251 'СР';

 C0 =  :C0 + 1 ;

SUSPEND;


END --  BEGIN /IF ( :C2 <> 0  .../


 C2 = 0;

 C3 = 0;

 C4 = 0;

 C5 = 0;

 C6 = 0;

 C7 = 0;

END -- DO BEGIN /FOR SELECT    G.KODNP,          G.KODST .../

END -- main BEGIN