zOs/SQL/STPRPATH
$** $>.fEdit('~wk.texv(out)')
call sqlConnect dbaf
$;
$<=[
set current sqlid = 's100447' ;
drop procedure a540769A.pathP1;
drop procedure a540769B.pathP1;
drop procedure a540769.pathP2;
drop procedure a540769.pathP3;
drop procedure a540769.pathFak;
drop procedure gdb9998.pathP1;
drop procedure gdb9998A.pathP1;
drop procedure gdb9998B.pathP1;
drop procedure gdb9998.pathP2;
drop procedure gdb9998.pathP3;
drop procedure gdb9998.pathFak;
drop procedure gdb9998.pathLoUp;
terminator } ;
create procedure gdb9998A.pathP1(out scNa varchar(20))
deterministic contains sql
set scNa = 'gdb9998A.pathP1'
}
create procedure gdb9998B.pathP1(out scNa varchar(20))
deterministic contains sql
set scNa = 'gdb9998B.pathP1'
}
create procedure gdb9998.pathP2(out scNa varchar(60))
deterministic contains sql
qualifier gdb9998A
begin
declare vA, vB, vX varchar(20) ;
call gdb9998A.pathP1(vA);
call gdb9998B.pathP1(vB);
call pathP1(vX);
set scNa = 'gdb9998.pathP2: ?=' || vX
|| ', A=' || vA || ', B=' || vB;
end
}
create procedure gdb9998.pathp3(out scNa varchar(60))
deterministic contains sql
sql path gdb9998X, gdb9998A, gdb9998B, gdb9998Z
begin
declare vA, vB, vX varchar(20) ;
call gdb9998A.pathP1(vA);
call gdb9998B.pathP1(vB);
call pathP1(vX);
set scNa = 'gdb9998.pathp3: ?=' || vX
|| ', A=' || vA || ', B=' || vB;
end
}
create procedure gdb9998.pathFak(in i int, out fak bigInt)
deterministic contains sql
begin
set i = i - 1;
if i < 1 then
set fak = 1;
else
call pathFak(i, fak);
set fak = (i+1) * fak;
end if;
end
}
create procedure gdb9998.pathLoUp(inOut txt varchar( 70))
deterministic contains sql
begin
declare res varchar(100);
set txt = left(lower(txt) || ' <== ' || upper(txt)
|| ' <== ' || txt, min(70,3*length(txt)+10));
end
}
terminator ; }
call gdb9998.pathLoUp('einsZwei Drei');
call gdb9998.pathLoUp(
'Null Eins Zwei Drei Vier Fuenf Sechs Sieben');
call gdb9998A.pathP1() ;
call gdb9998.pathP2() ;
alter procedure gdb9998.pathP2
qualifier gdb9998B;
call gdb9998.pathP2() ;
call gdb9998.pathP3() ;
alter procedure gdb9998.pathP3
sql path gdb9998Y, gdb9998B, gdb9998A, gdb9998Z;
call gdb9998.pathP3() ;
commit;
call gdb9998.pathP2() ;
call gdb9998.pathP3() ;
set current path gdb9998Y, gdb9998A, gdb9998B;
set current schema gdb9998A;
call gdb9998.pathP2() ;
commit;
call gdb9998.pathP2() ;
call gdb9998.pathP3() ;
commit;
drop procedure gdb9998B.pathP1;
commit;
$*(
call gdb9998.pathP3() ;
call gdb9998.pathP2() ;
call gdb9998.pathP3() ;
call gdb9998.pathFak(4,) ;
call gdb9998.pathFak(9,) ;
call gdb9998.pathFak(19,) ;
call gdb9998.pathFak(29,) ;
$*)
terminator } ;
create procedure gdb9998B.pathP1(out scNa varchar(20))
deterministic contains sql
set scNa = 'gdb9998B.pathP1 e2'
}
create procedure gdb9998.pathP1(out scNa varchar(20))
deterministic contains sql
set scNa = 'gdb9998.pathP1 e2'
}
commit
$] call sqlStmtsOpt
$#out 20110726 18:23:12
sqlCode 0: set current sqlid = 's100447'
sqlCode -204: drop procedure a540769A.pathP1
sqlCode -204: drop procedure a540769B.pathP1
sqlCode -204: drop procedure a540769.pathP2
sqlCode -204: drop procedure a540769.pathP3
sqlCode -204: drop procedure a540769.pathFak
sqlCode 0: drop procedure gdb9998.pathP1
sqlCode 0: drop procedure gdb9998A.pathP1
sqlCode 0: drop procedure gdb9998B.pathP1
sqlCode 0: drop procedure gdb9998.pathP2
sqlCode 0: drop procedure gdb9998.pathP3
sqlCode 0: drop procedure gdb9998.pathFak
sqlCode 0: drop procedure gdb9998.pathLoUp
sqlCode 0: create procedure gdb9998A.pathP1(out scNa varchar(20)) determin...
sqlCode 0: create procedure gdb9998B.pathP1(out scNa varchar(20)) determin...
sqlCode 0: create procedure gdb9998.pathP2(out scNa varchar(60)) determini...
sqlCode 0: create procedure gdb9998.pathp3(out scNa varchar(60)) determini...
SQLCODE = 440, WARNING: NO PROCEDURE BY THE NAME PATHFAK HAVING
COMPATIBLE ARGUMENTS WAS FOUND
stmt = execSql create procedure gdb9998.pathFak(in i int, out fak bigInt)
sqlCode 440: create procedure gdb9998.pathFak(in i int, out fak bigInt) de...
sqlCode 0: create procedure gdb9998.pathLoUp(inOut txt varchar( 70)) deter...
--- called GDB9998.PATHLOUP, sqlCode 0
parm 1 b TXT = einszwei drei <== EINSZWEI DREI <== einsZwei Drei
sqlCode 0: call gdb9998.pathLoUp('einsZwei Drei')
--- called GDB9998.PATHLOUP, sqlCode 0
parm 1 b TXT = null eins zwei drei vier fuenf sechs sieben <== NULL EINS ZWEI
sqlCode 0: call gdb9998.pathLoUp( 'Null Eins Zwei Drei Vier Fuenf Sechs Si...
--- called GDB9998A.PATHP1, sqlCode 0
parm 1 o SCNA = gdb9998A.pathP1
sqlCode 0: call gdb9998A.pathP1()
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
sqlCode 0: alter procedure gdb9998.pathP2 qualifier gdb9998B
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: alter procedure gdb9998.pathP3 sql path gdb9998Y, gdb9998B, gdb...
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: commit
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: set current path gdb9998Y, gdb9998A, gdb9998B
sqlCode 0: set current schema gdb9998A
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
sqlCode 0: commit
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: commit
sqlCode 0: drop procedure gdb9998B.pathP1
sqlCode 0: commit
sqlCode 0: create procedure gdb9998B.pathP1(out scNa varchar(20)) determin...
sqlCode 0: create procedure gdb9998.pathP1(out scNa varchar(20)) determini...
sqlCode 0: commit
$#out 20110726 17:56:16
sqlCode 0: set current sqlid = 's100447'
sqlCode -204: drop procedure a540769A.pathP1
sqlCode -204: drop procedure a540769B.pathP1
sqlCode -204: drop procedure a540769.pathP2
sqlCode -204: drop procedure a540769.pathP3
sqlCode -204: drop procedure a540769.pathFak
sqlCode -204: drop procedure gdb9998.pathP1
sqlCode 0: drop procedure gdb9998A.pathP1
sqlCode 0: drop procedure gdb9998B.pathP1
sqlCode 0: drop procedure gdb9998.pathP2
sqlCode 0: drop procedure gdb9998.pathP3
sqlCode 0: drop procedure gdb9998.pathFak
sqlCode 0: drop procedure gdb9998.pathLoUp
sqlCode 0: create procedure gdb9998A.pathP1(out scNa varchar(20)) determin...
sqlCode 0: create procedure gdb9998B.pathP1(out scNa varchar(20)) determin...
sqlCode 0: create procedure gdb9998.pathP2(out scNa varchar(60)) determini...
sqlCode 0: create procedure gdb9998.pathp3(out scNa varchar(60)) determini...
SQLCODE = 440, WARNING: NO PROCEDURE BY THE NAME PATHFAK HAVING
COMPATIBLE ARGUMENTS WAS FOUND
stmt = execSql create procedure gdb9998.pathFak(in i int, out fak bigInt)
sqlCode 440: create procedure gdb9998.pathFak(in i int, out fak bigInt) de...
sqlCode 0: create procedure gdb9998.pathLoUp(inOut txt varchar( 70)) deter...
--- called GDB9998.PATHLOUP, sqlCode 0
parm 1 b TXT = einszwei drei <== EINSZWEI DREI <== einsZwei Drei
sqlCode 0: call gdb9998.pathLoUp('einsZwei Drei')
--- called GDB9998.PATHLOUP, sqlCode 0
parm 1 b TXT = null eins zwei drei vier fuenf sechs sieben <== NULL EINS ZWEI
sqlCode 0: call gdb9998.pathLoUp( 'Null Eins Zwei Drei Vier Fuenf Sechs Si...
--- called GDB9998A.PATHP1, sqlCode 0
parm 1 o SCNA = gdb9998A.pathP1
sqlCode 0: call gdb9998A.pathP1()
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
sqlCode 0: alter procedure gdb9998.pathP2 qualifier gdb9998B
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: alter procedure gdb9998.pathP3 sql path gdb9998Y, gdb9998B, gdb...
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: commit
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: set current path gdb9998Y, gdb9998A, gdb9998B
sqlCode 0: set current schema gdb9998A
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
sqlCode 0: commit
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: commit
sqlCode 0: drop procedure gdb9998B.pathP1
sqlCode 0: commit
sqlCode 0: create procedure gdb9998B.pathP1(out scNa varchar(20)) determin...
sqlCode 0: create procedure gdb9998.pathP1(out scNa varchar(20)) determini...
sqlCode 0: commit
$#out 20110726 17:55:58
sqlCode 0: set current sqlid = 's100447'
sqlCode -204: drop procedure a540769A.pathP1
sqlCode -204: drop procedure a540769B.pathP1
sqlCode -204: drop procedure a540769.pathP2
sqlCode -204: drop procedure a540769.pathP3
sqlCode -204: drop procedure a540769.pathFak
sqlCode 0: drop procedure gdb9998.pathP1
sqlCode 0: drop procedure gdb9998A.pathP1
sqlCode 0: drop procedure gdb9998B.pathP1
sqlCode 0: drop procedure gdb9998.pathP2
sqlCode 0: drop procedure gdb9998.pathP3
sqlCode 0: drop procedure gdb9998.pathFak
sqlCode 0: create procedure gdb9998A.pathP1(out scNa varchar(20)) determin...
sqlCode 0: create procedure gdb9998B.pathP1(out scNa varchar(20)) determin...
sqlCode 0: create procedure gdb9998.pathP2(out scNa varchar(60)) determini...
sqlCode 0: create procedure gdb9998.pathp3(out scNa varchar(60)) determini...
SQLCODE = 440, WARNING: NO PROCEDURE BY THE NAME PATHFAK HAVING
COMPATIBLE ARGUMENTS WAS FOUND
stmt = execSql create procedure gdb9998.pathFak(in i int, out fak bigInt)
sqlCode 440: create procedure gdb9998.pathFak(in i int, out fak bigInt) de...
*** run error ***
SQLCODE = -601: THE NAME (VERSION OR VOLUME SERIAL NUMBER)
OF THE OBJECT TO BE DEFINED OR THE TARGET OF A RENAME STATEMENT IS
IDENTICAL TO THE EXISTING NAME (VERSION OR VOLUME SERIAL NUMBER)
GDB9998.PATHLOUP OF THE OBJECT TYPE PROCEDURE
stmt = execSql create procedure gdb9998.pathLoUp(inOut txt varchar( 70))
$#out 20110726 17:54:17
sqlCode 0: set current sqlid = 's100447'
sqlCode -204: drop procedure a540769A.pathP1
sqlCode -204: drop procedure a540769B.pathP1
sqlCode -204: drop procedure a540769.pathP2
sqlCode -204: drop procedure a540769.pathP3
sqlCode -204: drop procedure a540769.pathFak
sqlCode -204: drop procedure gdb9998.pathP1
sqlCode 0: drop procedure gdb9998A.pathP1
sqlCode 0: drop procedure gdb9998B.pathP1
sqlCode 0: drop procedure gdb9998.pathP2
sqlCode 0: drop procedure gdb9998.pathP3
sqlCode 0: drop procedure gdb9998.pathFak
sqlCode 0: create procedure gdb9998A.pathP1(out scNa varchar(20)) determin...
sqlCode 0: create procedure gdb9998B.pathP1(out scNa varchar(20)) determin...
sqlCode 0: create procedure gdb9998.pathP2(out scNa varchar(60)) determini...
sqlCode 0: create procedure gdb9998.pathp3(out scNa varchar(60)) determini...
SQLCODE = 440, WARNING: NO PROCEDURE BY THE NAME PATHFAK HAVING
COMPATIBLE ARGUMENTS WAS FOUND
stmt = execSql create procedure gdb9998.pathFak(in i int, out fak bigInt)
sqlCode 440: create procedure gdb9998.pathFak(in i int, out fak bigInt) de...
sqlCode 0: create procedure gdb9998.pathLoUp(inOut txt varchar(100)) deter...
--- called GDB9998.PATHLOUP, sqlCode 0
parm 1 b TXT = einszwei drei <== EINSZWEI DREI <== einsZwei Drei
sqlCode 0: call gdb9998.pathLoUp('einsZwei Drei')
--- called GDB9998.PATHLOUP, sqlCode 0
parm 1 b TXT = null eins zwei drei vier fuenf sechs sieben acht neun zehn elf
sqlCode 0: call gdb9998.pathLoUp( 'Null Eins Zwei Drei Vier Fuenf Sechs Si...
--- called GDB9998A.PATHP1, sqlCode 0
parm 1 o SCNA = gdb9998A.pathP1
sqlCode 0: call gdb9998A.pathP1()
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
sqlCode 0: alter procedure gdb9998.pathP2 qualifier gdb9998B
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: alter procedure gdb9998.pathP3 sql path gdb9998Y, gdb9998B, gdb...
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: commit
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: set current path gdb9998Y, gdb9998A, gdb9998B
sqlCode 0: set current schema gdb9998A
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
sqlCode 0: commit
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: commit
sqlCode 0: drop procedure gdb9998B.pathP1
sqlCode 0: commit
sqlCode 0: create procedure gdb9998B.pathP1(out scNa varchar(20)) determin...
sqlCode 0: create procedure gdb9998.pathP1(out scNa varchar(20)) determini...
sqlCode 0: commit
$#out 20110726 17:50:52
sqlCode 0: set current sqlid = 's100447'
sqlCode -204: drop procedure a540769A.pathP1
sqlCode -204: drop procedure a540769B.pathP1
sqlCode -204: drop procedure a540769.pathP2
sqlCode -204: drop procedure a540769.pathP3
sqlCode -204: drop procedure a540769.pathFak
sqlCode -204: drop procedure gdb9998.pathP1
sqlCode 0: drop procedure gdb9998A.pathP1
sqlCode 0: drop procedure gdb9998B.pathP1
sqlCode 0: drop procedure gdb9998.pathP2
sqlCode 0: drop procedure gdb9998.pathP3
sqlCode 0: drop procedure gdb9998.pathFak
sqlCode 0: create procedure gdb9998A.pathP1(out scNa varchar(20)) determin...
sqlCode 0: create procedure gdb9998B.pathP1(out scNa varchar(20)) determin...
sqlCode 0: create procedure gdb9998.pathP2(out scNa varchar(60)) determini...
sqlCode 0: create procedure gdb9998.pathp3(out scNa varchar(60)) determini...
SQLCODE = 440, WARNING: NO PROCEDURE BY THE NAME PATHFAK HAVING
COMPATIBLE ARGUMENTS WAS FOUND
stmt = execSql create procedure gdb9998.pathFak(in i int, out fak bigInt)
sqlCode 440: create procedure gdb9998.pathFak(in i int, out fak bigInt) de...
*** run error ***
SQLCODE = -199: ILLEGAL USE OF KEYWORD END. TOKEN
MICROSECONDS MICROSECOND SECONDS SECOND MINUTES MINUTE HOURS WAS
EXPECTED
src create procedure gdb9998.pathLoUp(inOut txt varchar(100)) d
+ eterministic contains sql begin declare res varchar(100); set txt =
+ left(lower(txt) || ' <== ' || upper(txt) || ' <== ' || txt, 100) end
> >>>pos 435 of 510>>>
stmt = execSql create procedure gdb9998.pathLoUp(inOut txt varchar(100))
$#out 20110726 17:50:19
sqlCode 0: set current sqlid = 's100447'
sqlCode -204: drop procedure a540769A.pathP1
sqlCode -204: drop procedure a540769B.pathP1
sqlCode -204: drop procedure a540769.pathP2
sqlCode -204: drop procedure a540769.pathP3
sqlCode -204: drop procedure a540769.pathFak
sqlCode -204: drop procedure gdb9998.pathP1
sqlCode 0: drop procedure gdb9998A.pathP1
sqlCode 0: drop procedure gdb9998B.pathP1
sqlCode 0: drop procedure gdb9998.pathP2
sqlCode 0: drop procedure gdb9998.pathP3
sqlCode 0: drop procedure gdb9998.pathFak
sqlCode 0: create procedure gdb9998A.pathP1(out scNa varchar(20)) determin...
sqlCode 0: create procedure gdb9998B.pathP1(out scNa varchar(20)) determin...
sqlCode 0: create procedure gdb9998.pathP2(out scNa varchar(60)) determini...
sqlCode 0: create procedure gdb9998.pathp3(out scNa varchar(60)) determini...
SQLCODE = 440, WARNING: NO PROCEDURE BY THE NAME PATHFAK HAVING
COMPATIBLE ARGUMENTS WAS FOUND
stmt = execSql create procedure gdb9998.pathFak(in i int, out fak bigInt)
sqlCode 440: create procedure gdb9998.pathFak(in i int, out fak bigInt) de...
*** run error ***
SQLCODE = -104: ILLEGAL SYMBOL "=". SOME SYMBOLS THAT MIGHT
BE LEGAL ARE: :
src create proc
+ edure gdb9998.pathLoUp(inOut txt varchar(100)) deterministic contain
+ s sql begin declare res varchar(100); txt = left(lower(txt) || ' ...
> >>>pos 309 of 510>>>
stmt = execSql create procedure gdb9998.pathLoUp(inOut txt varchar(100))
$#out 20110726 17:49:44
sqlCode 0: set current sqlid = 's100447'
sqlCode -204: drop procedure a540769A.pathP1
sqlCode -204: drop procedure a540769B.pathP1
sqlCode -204: drop procedure a540769.pathP2
sqlCode -204: drop procedure a540769.pathP3
sqlCode -204: drop procedure a540769.pathFak
sqlCode 0: drop procedure gdb9998.pathP1
sqlCode 0: drop procedure gdb9998A.pathP1
sqlCode 0: drop procedure gdb9998B.pathP1
sqlCode 0: drop procedure gdb9998.pathP2
sqlCode 0: drop procedure gdb9998.pathP3
sqlCode 0: drop procedure gdb9998.pathFak
sqlCode 0: create procedure gdb9998A.pathP1(out scNa varchar(20)) determin...
sqlCode 0: create procedure gdb9998B.pathP1(out scNa varchar(20)) determin...
sqlCode 0: create procedure gdb9998.pathP2(out scNa varchar(60)) determini...
sqlCode 0: create procedure gdb9998.pathp3(out scNa varchar(60)) determini...
SQLCODE = 440, WARNING: NO PROCEDURE BY THE NAME PATHFAK HAVING
COMPATIBLE ARGUMENTS WAS FOUND
stmt = execSql create procedure gdb9998.pathFak(in i int, out fak bigInt)
sqlCode 440: create procedure gdb9998.pathFak(in i int, out fak bigInt) de...
*** run error ***
SQLCODE = -104: ILLEGAL SYMBOL "VARCHAR". SOME SYMBOLS THAT
MIGHT BE LEGAL ARE: INOUT OUT IN , ) . ( CHECK UNIQUE NOT FOR
PRIMARY AS UPDATE
src create procedure gdb9998.pathLoUp(io txt varchar(100)) determini...
> >>>pos 42 of 510>>>
stmt = execSql create procedure gdb9998.pathLoUp(io txt varchar(100))
$#out 20110725 17:16:20
sqlCode 0: set current sqlid = 's100447'
sqlCode -204: drop procedure a540769A.pathP1
sqlCode -204: drop procedure a540769B.pathP1
sqlCode -204: drop procedure a540769.pathP2
sqlCode -204: drop procedure a540769.pathP3
sqlCode -204: drop procedure a540769.pathFak
sqlCode -204: drop procedure gdb9998.pathP1
sqlCode 0: drop procedure gdb9998A.pathP1
sqlCode -204: drop procedure gdb9998B.pathP1
sqlCode 0: drop procedure gdb9998.pathP2
sqlCode 0: drop procedure gdb9998.pathP3
sqlCode 0: drop procedure gdb9998.pathFak
sqlCode 0: create procedure gdb9998A.pathP1(out scNa varchar(20)) determin...
sqlCode 0: create procedure gdb9998B.pathP1(out scNa varchar(20)) determin...
sqlCode 0: create procedure gdb9998.pathP2(out scNa varchar(60)) determini...
sqlCode 0: create procedure gdb9998.pathp3(out scNa varchar(60)) determini...
SQLCODE = 440, WARNING: NO PROCEDURE BY THE NAME PATHFAK HAVING
COMPATIBLE ARGUMENTS WAS FOUND
stmt = execSql create procedure gdb9998.pathFak(in i int, out fak bigInt)
sqlCode 440: create procedure gdb9998.pathFak(in i int, out fak bigInt) de...
--- called GDB9998A.PATHP1, sqlCode 0
parm 1 o SCNA = gdb9998A.pathP1
sqlCode 0: call gdb9998A.pathP1()
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
sqlCode 0: alter procedure gdb9998.pathP2 qualifier gdb9998B
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: alter procedure gdb9998.pathP3 sql path gdb9998Y, gdb9998B, gdb...
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: commit
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: set current path gdb9998Y, gdb9998A, gdb9998B
sqlCode 0: set current schema gdb9998A
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
sqlCode 0: commit
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: commit
sqlCode 0: drop procedure gdb9998B.pathP1
sqlCode 0: commit
sqlCode 0: create procedure gdb9998B.pathP1(out scNa varchar(20)) determin...
sqlCode 0: create procedure gdb9998.pathP1(out scNa varchar(20)) determini...
sqlCode 0: commit
$#out 20110725 17:14:25
sqlCode 0: set current sqlid = 's100447'
sqlCode -204: drop procedure a540769A.pathP1
sqlCode -204: drop procedure a540769B.pathP1
sqlCode -204: drop procedure a540769.pathP2
sqlCode -204: drop procedure a540769.pathP3
sqlCode -204: drop procedure a540769.pathFak
sqlCode -204: drop procedure gdb9998.pathP1
sqlCode 0: drop procedure gdb9998A.pathP1
sqlCode -204: drop procedure gdb9998B.pathP1
sqlCode 0: drop procedure gdb9998.pathP2
sqlCode 0: drop procedure gdb9998.pathP3
sqlCode 0: drop procedure gdb9998.pathFak
sqlCode 0: create procedure gdb9998A.pathP1(out scNa varchar(20)) determin...
sqlCode 0: create procedure gdb9998B.pathP1(out scNa varchar(20)) determin...
sqlCode 0: create procedure gdb9998.pathP2(out scNa varchar(60)) determini...
sqlCode 0: create procedure gdb9998.pathp3(out scNa varchar(60)) determini...
SQLCODE = 440, WARNING: NO PROCEDURE BY THE NAME PATHFAK HAVING
COMPATIBLE ARGUMENTS WAS FOUND
stmt = execSql create procedure gdb9998.pathFak(in i int, out fak bigInt)
sqlCode 440: create procedure gdb9998.pathFak(in i int, out fak bigInt) de...
--- called GDB9998A.PATHP1, sqlCode 0
parm 1 o SCNA = gdb9998A.pathP1
sqlCode 0: call gdb9998A.pathP1()
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
sqlCode 0: alter procedure gdb9998.pathP2 qualifier gdb9998B
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: alter procedure gdb9998.pathP3 sql path gdb9998Y, gdb9998B, gdb...
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: commit
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: set current path gdb9998Y, gdb9998A, gdb9998B
sqlCode 0: set current schema gdb9998A
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
sqlCode 0: commit
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: commit
sqlCode 0: drop procedure gdb9998B.pathP1
sqlCode 0: commit
sqlCode 0: create procedure gdb9998B.pathP1(out scNa varchar(20)) determin...
sqlCode 0: create procedure gdb9998.pathP1(out scNa varchar(20)) determini...
sqlCode 0: commit
$#out 20110725 17:12:24
sqlCode 0: set current sqlid = 's100447'
sqlCode -204: drop procedure a540769A.pathP1
sqlCode -204: drop procedure a540769B.pathP1
sqlCode -204: drop procedure a540769.pathP2
sqlCode -204: drop procedure a540769.pathP3
sqlCode -204: drop procedure a540769.pathFak
sqlCode -204: drop procedure gdb9998.pathP1
sqlCode 0: drop procedure gdb9998A.pathP1
sqlCode -204: drop procedure gdb9998B.pathP1
sqlCode 0: drop procedure gdb9998.pathP2
sqlCode 0: drop procedure gdb9998.pathP3
sqlCode 0: drop procedure gdb9998.pathFak
sqlCode 0: create procedure gdb9998A.pathP1(out scNa varchar(20)) determin...
sqlCode 0: create procedure gdb9998B.pathP1(out scNa varchar(20)) determin...
sqlCode 0: create procedure gdb9998.pathP2(out scNa varchar(60)) determini...
sqlCode 0: create procedure gdb9998.pathp3(out scNa varchar(60)) determini...
SQLCODE = 440, WARNING: NO PROCEDURE BY THE NAME PATHFAK HAVING
COMPATIBLE ARGUMENTS WAS FOUND
stmt = execSql create procedure gdb9998.pathFak(in i int, out fak bigInt)
sqlCode 440: create procedure gdb9998.pathFak(in i int, out fak bigInt) de...
--- called GDB9998A.PATHP1, sqlCode 0
parm 1 o SCNA = gdb9998A.pathP1
sqlCode 0: call gdb9998A.pathP1()
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
sqlCode 0: alter procedure gdb9998.pathP2 qualifier gdb9998B
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: alter procedure gdb9998.pathP3 sql path gdb9998Y, gdb9998B, gdb...
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: commit
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: set current path gdb9998Y, gdb9998A, gdb9998B
sqlCode 0: set current schema gdb9998A
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
sqlCode 0: commit
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: commit
sqlCode 0: drop procedure gdb9998B.pathP1
sqlCode 0: commit
*** run error ***
SQLCODE = -440: NO PROCEDURE BY THE NAME GDB9998B.PATHP1
HAVING COMPATIBLE ARGUMENTS WAS FOUND IN THE CURRENT PATH
stmt = execSql call GDB9998.PATHP3 using descriptor :M.SQLSTMTCALL
with M.SQLSTMTCALL = M.SQLSTMTCALL
$#out 20110725 17:11:17
sqlCode 0: set current sqlid = 's100447'
sqlCode -204: drop procedure a540769A.pathP1
sqlCode -204: drop procedure a540769B.pathP1
sqlCode -204: drop procedure a540769.pathP2
sqlCode -204: drop procedure a540769.pathP3
sqlCode -204: drop procedure a540769.pathFak
sqlCode -204: drop procedure gdb9998.pathP1
sqlCode 0: drop procedure gdb9998A.pathP1
sqlCode -204: drop procedure gdb9998B.pathP1
sqlCode 0: drop procedure gdb9998.pathP2
sqlCode 0: drop procedure gdb9998.pathP3
sqlCode 0: drop procedure gdb9998.pathFak
sqlCode 0: create procedure gdb9998A.pathP1(out scNa varchar(20)) determin...
sqlCode 0: create procedure gdb9998B.pathP1(out scNa varchar(20)) determin...
sqlCode 0: create procedure gdb9998.pathP2(out scNa varchar(60)) determini...
sqlCode 0: create procedure gdb9998.pathp3(out scNa varchar(60)) determini...
SQLCODE = 440, WARNING: NO PROCEDURE BY THE NAME PATHFAK HAVING
COMPATIBLE ARGUMENTS WAS FOUND
stmt = execSql create procedure gdb9998.pathFak(in i int, out fak bigInt)
sqlCode 440: create procedure gdb9998.pathFak(in i int, out fak bigInt) de...
--- called GDB9998A.PATHP1, sqlCode 0
parm 1 o SCNA = gdb9998A.pathP1
sqlCode 0: call gdb9998A.pathP1()
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
sqlCode 0: alter procedure gdb9998.pathP2 qualifier gdb9998B
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: alter procedure gdb9998.pathP3 sql path gdb9998Y, gdb9998B, gdb...
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: commit
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: set current path gdb9998Y, gdb9998A, gdb9998B
sqlCode 0: set current schema gdb9998A
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
sqlCode 0: commit
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: commit
sqlCode 0: drop procedure gdb9998B.pathP1
sqlCode 0: commit
*** run error ***
SQLCODE = -440: NO PROCEDURE BY THE NAME GDB9998B.PATHP1
HAVING COMPATIBLE ARGUMENTS WAS FOUND IN THE CURRENT PATH
stmt = execSql call GDB9998.PATHP3 using descriptor :M.SQLSTMTCALL
with M.SQLSTMTCALL = M.SQLSTMTCALL
$#out 20110609 11:09:48
*** run error ***
SQLCODE = -724: THE ACTIVATION OF THE PROCEDURE OBJECT
GDB9998.PATHFAK WOULD EXCEED THE MAXIMUM LEVEL OF INDIRECT SQL
CASCADING
stmt = execSql call GDB9998.PATHFAK using descriptor :M.SQLSTMTCALL
with M.SQLSTMTCALL = M.SQLSTMTCALL
$#out 20110609 11:09:02
--- called GDB9998.PATHFAK, sqlCode 0
parm 1 i I = 9
parm 2 o FAK = 362880
sqlCode 0: call gdb9998.pathFak(9,)
$#out 20110609 11:08:45
*** run error ***
sqlCode SQLCODE not numeric
sqlCode SQLCODE sqlState=SQLSTATE
errMC=SQLERRMC
warnings= 0=SQLWARN.0 1=SQLWARN.1 2=SQLWARN.2 3=SQLWARN.3 4=SQLWARN.4 5=SQLW
errD.1=SQLERRD.1 2=SQLERRD.2 3=SQLERRD.3
errD.4=SQLERRD.4 5=SQLERRD.5 6=SQLERRD.6
stmt = execSql call GDB9998A.PATHP1 using descriptor :M.SQLSTMTCALL
with M.SQLSTMTCALL = M.SQLSTMTCALL
$#out 20110609 11:06:54
sqlCode 0: set current sqlid = 's100447'
sqlCode -204: drop procedure a540769A.pathP1
sqlCode -204: drop procedure a540769B.pathP1
sqlCode -204: drop procedure a540769.pathP2
sqlCode -204: drop procedure a540769.pathP3
sqlCode -204: drop procedure a540769.pathFak
sqlCode -204: drop procedure gdb9998A.pathP1
sqlCode -204: drop procedure gdb9998B.pathP1
sqlCode -204: drop procedure gdb9998.pathP2
sqlCode -204: drop procedure gdb9998.pathP3
sqlCode -204: drop procedure gdb9998.pathFak
sqlCode 0: create procedure gdb9998A.pathP1(out scNa varchar(20)) d...
sqlCode 0: create procedure gdb9998B.pathP1(out scNa varchar(20)) d...
sqlCode 0: create procedure gdb9998.pathP2(out scNa varchar(60)) de...
sqlCode 0: create procedure gdb9998.pathp3(out scNa varchar(60)) de...
SQLCODE = 440, WARNING: NO PROCEDURE BY THE NAME PATHFAK HAVING
COMPATIBLE ARGUMENTS WAS FOUND
stmt = execSql create procedure gdb9998.pathFak(in i int, out fak bigInt)
sqlCode 440: create procedure gdb9998.pathFak(in i int, out fak big...
--- called GDB9998A.PATHP1, sqlCode 0
parm 1 o SCNA = gdb9998A.pathP1
sqlCode 0: call gdb9998A.pathP1()
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
sqlCode 0: alter procedure gdb9998.pathP2 qualifier gdb9998B
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: alter procedure gdb9998.pathP3 sql path gdb9998Y, gdb999...
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: commit
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: set current path gdb9998Y, gdb9998A, gdb9998B
sqlCode 0: set current schema gdb9998A
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
sqlCode 0: commit
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: commit
sqlCode 0: drop procedure gdb9998B.pathP1
sqlCode 0: commit
*** run error ***
SQLCODE = -440: NO PROCEDURE BY THE NAME GDB9998B.PATHP1
HAVING COMPATIBLE ARGUMENTS WAS FOUND IN THE CURRENT PATH
stmt = execSql call GDB9998.PATHP3 using descriptor :M.SQLSTMTCALL
with M.SQLSTMTCALL = M.SQLSTMTCALL
$#out 20110609 11:06:25
sqlCode 0: set current sqlid = 's100447'
sqlCode -204: drop procedure a540769A.pathP1
sqlCode -204: drop procedure a540769B.pathP1
sqlCode -204: drop procedure a540769.pathP2
sqlCode -204: drop procedure a540769.pathP3
sqlCode -204: drop procedure a540769.pathFak
sqlCode 0: drop procedure gdb9998A.pathP1
sqlCode -204: drop procedure gdb9998B.pathP1
sqlCode 0: drop procedure gdb9998.pathP2
sqlCode 0: drop procedure gdb9998.pathP3
sqlCode 0: drop procedure gdb9998.pathFak
sqlCode 0: create procedure gdb9998A.pathP1(out scNa varchar(20)) d...
sqlCode 0: create procedure gdb9998B.pathP1(out scNa varchar(20)) d...
sqlCode 0: create procedure gdb9998.pathP2(out scNa varchar(60)) de...
sqlCode 0: create procedure gdb9998.pathp3(out scNa varchar(60)) de...
SQLCODE = 440, WARNING: NO PROCEDURE BY THE NAME PATHFAK HAVING
COMPATIBLE ARGUMENTS WAS FOUND
stmt = execSql create procedure gdb9998.pathFak(in i int, out fak bigInt)
sqlCode 440: create procedure gdb9998.pathFak(in i int, out fak big...
*** run error ***
sqlCode SQLCODE not numeric
sqlCode SQLCODE sqlState=SQLSTATE
errMC=SQLERRMC
warnings= 0=SQLWARN.0 1=SQLWARN.1 2=SQLWARN.2 3=SQLWARN.3 4=SQLWARN.4 5=SQLW
errD.1=SQLERRD.1 2=SQLERRD.2 3=SQLERRD.3
errD.4=SQLERRD.4 5=SQLERRD.5 6=SQLERRD.6
stmt = execSql call GDB9998A.PATHP1 using descriptor :M.SQLSTMTCALL
with M.SQLSTMTCALL = M.SQLSTMTCALL
$#out 20110609 09:42:04
sqlCode 0: set current sqlid = 's100447'
sqlCode -204: drop procedure a540769A.pathP1
sqlCode -204: drop procedure a540769B.pathP1
sqlCode -204: drop procedure a540769.pathP2
sqlCode -204: drop procedure a540769.pathP3
sqlCode -204: drop procedure a540769.pathFak
sqlCode 0: drop procedure gdb9998A.pathP1
sqlCode -204: drop procedure gdb9998B.pathP1
sqlCode 0: drop procedure gdb9998.pathP2
sqlCode 0: drop procedure gdb9998.pathP3
sqlCode 0: drop procedure gdb9998.pathFak
sqlCode 0: create procedure gdb9998A.pathP1(out scNa varchar(20)) d...
sqlCode 0: create procedure gdb9998B.pathP1(out scNa varchar(20)) d...
sqlCode 0: create procedure gdb9998.pathP2(out scNa varchar(60)) de...
sqlCode 0: create procedure gdb9998.pathp3(out scNa varchar(60)) de...
SQLCODE = 440, WARNING: NO PROCEDURE BY THE NAME PATHFAK HAVING
COMPATIBLE ARGUMENTS WAS FOUND
stmt = execSql create procedure gdb9998.pathFak(in i int, out fak bigInt)
sqlCode 440: create procedure gdb9998.pathFak(in i int, out fak big...
*** run error ***
sqlCode SQLCODE not numeric
sqlCode SQLCODE sqlState=SQLSTATE
errMC=SQLERRMC
warnings= 0=SQLWARN.0 1=SQLWARN.1 2=SQLWARN.2 3=SQLWARN.3 4=SQLWARN.4 5=SQLW
errD.1=SQLERRD.1 2=SQLERRD.2 3=SQLERRD.3
errD.4=SQLERRD.4 5=SQLERRD.5 6=SQLERRD.6
stmt = execSql call GDB9998A.PATHP1 using descriptor :M.SQLSTMTCALL
with M.SQLSTMTCALL = M.SQLSTMTCALL
$#out 20110609 09:41:37
sqlCode 0: set current sqlid = 's100447'
sqlCode -204: drop procedure a540769A.pathP1
sqlCode -204: drop procedure a540769B.pathP1
sqlCode -204: drop procedure a540769.pathP2
sqlCode -204: drop procedure a540769.pathP3
sqlCode -204: drop procedure a540769.pathFak
sqlCode 0: drop procedure gdb9998A.pathP1
sqlCode -204: drop procedure gdb9998B.pathP1
sqlCode 0: drop procedure gdb9998.pathP2
sqlCode 0: drop procedure gdb9998.pathP3
sqlCode 0: drop procedure gdb9998.pathFak
sqlCode 0: create procedure gdb9998A.pathP1(out scNa varchar(20)) d...
sqlCode 0: create procedure gdb9998B.pathP1(out scNa varchar(20)) d...
sqlCode 0: create procedure gdb9998.pathP2(out scNa varchar(60)) de...
sqlCode 0: create procedure gdb9998.pathp3(out scNa varchar(60)) de...
SQLCODE = 440, WARNING: NO PROCEDURE BY THE NAME PATHFAK HAVING
COMPATIBLE ARGUMENTS WAS FOUND
stmt = execSql create procedure gdb9998.pathFak(in i int, out fak bigInt)
sqlCode 440: create procedure gdb9998.pathFak(in i int, out fak big...
*** run error ***
sqlCode SQLCODE not numeric
sqlCode SQLCODE sqlState=SQLSTATE
errMC=SQLERRMC
warnings= 0=SQLWARN.0 1=SQLWARN.1 2=SQLWARN.2 3=SQLWARN.3 4=SQLWARN.4 5=SQLW
errD.1=SQLERRD.1 2=SQLERRD.2 3=SQLERRD.3
errD.4=SQLERRD.4 5=SQLERRD.5 6=SQLERRD.6
stmt = execSql call GDB9998A.PATHP1 using descriptor :M.SQLSTMTCALL
with M.SQLSTMTCALL = M.SQLSTMTCALL
$#out 20110608 14:36:41
sqlCode 0: set current sqlid = 's100447'
sqlCode 0: drop procedure a540769A.pathP1
sqlCode -204: drop procedure a540769B.pathP1
sqlCode 0: drop procedure a540769.pathP2
sqlCode 0: drop procedure a540769.pathP3
sqlCode 0: drop procedure a540769.pathFak
sqlCode -204: drop procedure gdb9998A.pathP1
sqlCode -204: drop procedure gdb9998B.pathP1
sqlCode -204: drop procedure gdb9998.pathP2
sqlCode -204: drop procedure gdb9998.pathP3
sqlCode -204: drop procedure gdb9998.pathFak
sqlCode 0: create procedure gdb9998A.pathP1(out scNa varchar(20)) ...
sqlCode 0: create procedure gdb9998B.pathP1(out scNa varchar(20)) ...
sqlCode 0: create procedure gdb9998.pathP2(out scNa varchar(60)) ...
sqlCode 0: create procedure gdb9998.pathp3(out scNa varchar(60)) ...
SQLCODE = 440, WARNING: NO PROCEDURE BY THE NAME PATHFAK HAVING
COMPATIBLE ARGUMENTS WAS FOUND
stmt = execSql create procedure gdb9998.pathFak(in i int, out fak bigInt)
sqlCode 440: create procedure gdb9998.pathFak(in i int, out fak bigInt) ...
--- called GDB9998A.PATHP1, sqlCode 0
parm 1 o SCNA = gdb9998A.pathP1
sqlCode 0: call gdb9998A.pathP1()
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
sqlCode 0: alter procedure gdb9998.pathP2 ...
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: alter procedure gdb9998.pathP3 ...
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998A.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: commit
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: set current path gdb9998Y, gdb9998A, gdb9998B
sqlCode 0: set current schema gdb9998A
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
sqlCode 0: commit
--- called GDB9998.PATHP2, sqlCode 0
parm 1 o SCNA = gdb9998.pathP2: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP2()
--- called GDB9998.PATHP3, sqlCode 0
parm 1 o SCNA = gdb9998.pathp3: ?=gdb9998B.pathP1, A=gdb9998A.pathP1, B=gdb9
sqlCode 0: call gdb9998.pathP3()
sqlCode 0: commit
sqlCode 0: drop procedure gdb9998B.pathP1
sqlCode 0: commit
*** run error ***
SQLCODE = -440: NO PROCEDURE BY THE NAME GDB9998B.PATHP1
HAVING COMPATIBLE ARGUMENTS WAS FOUND IN THE CURRENT PATH
stmt = execSql call GDB9998.PATHP3 using descriptor :M.SQLSTMTCALL
with M.SQLSTMTCALL = M.SQLSTMTCALL
$#out 20110525 17:44:25