stores_demo -  functions -  metadata

Description

none

Function properties

name	value
name	metadata
created
type	SQL scalar function

Parameters

none

Usage

set @myvar = metadata

Code

create procedure SYSIBM.METADATA() returning integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, lvarchar(4096), varchar(100), varchar(100),varchar(100), varchar(100), varchar(25), varchar(25), integer, integer, integer, varchar(255), integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, varchar(50), varchar(50), varchar(50), integer, varchar(50), integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, varchar(50), integer, integer, integer, integer, varchar(100), varchar(100), varchar(100), varchar(100), varchar(100), varchar(100), varchar(100), varchar(100), varchar(100), varchar(100), varchar(100), integer, integer, integer

define r1, r2, r3, r4, r5, r6, r7, r8, r9, r10, r11, r12, r13, r14 integer;
define r15 lvarchar(4096);
define r16, r17, r18, r19 varchar(100);
define r20, r21 varchar(25);
define r22, r23, r24 integer;

define r25 varchar(255);
define r26, r27, r28, r29, r30, r31, r32, r33, r34, r35, r36, r37, r38, r39, r40, r41 integer;
define r42, r43, r44, r46 varchar(50);
define r45 integer;
define r47, r48, r49, r50, r51, r52, r53, r54, r55, r56, r57, r58, r59, r60, r61 integer;
define r62, r63, r64, r65, r66, r67, r68, r69, r70, r71, r72, r73, r74, r75, r76, r77, r78, r79, r80, r81, r82, r83, r84, r85, r86, r87, r88, r89, r90, r92, r93, r94, r95 integer;
define r91 varchar(50);
define r96, r97, r98, r99, r100, r101, r102, r103, r104, r105, r106  varchar(100);
define r107, r108, r109, r110, r111, r112 integer;

select o1, o2, o3, o4, o5, o6, o7, o8, o9, o10, o11, o12, o13, o14, o15, o16, o17, o18, o19, o20, o21, o22, o23, o24, o25, o26, o27, o28, o29, o30, o31, o32, o33, o34, o35, o36, o37, o38, o39, o40, o41, o42, o43, o44, o45, o46, o47, o48, o49, o50, o51, o52, o53, o54, o55, o56, o57, o58, o59, o60, o61 into r1, r2, r3, r4, r5, r6, r7, r8, r9, r10, r11, r12, r13, r14, r15, r16, r17, r18, r19, r20, r21, r22, r23, r24, r25, r26, r27, r28, r29, r30, r31, r32, r33, r34, r35, r36, r37, r38, r39, r40, r41, r42, r43, r44, r45, r46, r47, r48, r49, r50, r51, r52, r53, r54, r55, r56, r57, r58, r59, r60, r61 from informix.systables where informix.metadata_1(o1 # int, o2 # int, o3 # int, o4 # int, o5 # int, o6 # int, o7 # int, o8 # int, o9 # int, o10 # int, o11 # int, o12 # int, o13 # int, o14 # int, o15 # lvarchar(4096), o16 # varchar(100), o17 # varchar(100), o18 # varchar(100), o19 # varchar(100), o20 # varchar(25), o21 # varchar(25), o22 # int, o23 # int, o24 # int, o25 # varchar(255), o26 # int, o27 # int, o28 # int, o29 # int, o30 # int, o31 # int, o32 # int, o33 # int, o34 # int, o35 # int, o36 # int, o37 # int, o38 # int, o39 # int, o40 # int, o41 # int, o42 # varchar(50), o43 # varchar(50), o44 # varchar(50), o45 # int, o46 # varchar(50), o47 # int, o48 # int, o49 # int, o50 # int, o51 # int, o52 # int, o53 # int, o54 # int, o55 # int, o56 # int, o57 # int, o58 # int, o59 # int, o60 # int, o61 # int) = 1 and tabid = 1;

select o1, o2, o3, o4, o5, o6, o7, o8, o9, o10, o11, o12, o13, o14, o15, o16, o17, o18, o19, o20, o21, o22, o23, o24, o25, o26, o27, o28, o29, o30, o31, o32, o33, o34, o35, o36, o37, o38, o39, o40, o41, o42, o43, o44, o45, o46, o47, o48, o49, o50, o51 into r62, r63, r64, r65, r66, r67, r68, r69, r70, r71, r72, r73, r74, r75, r76, r77, r78, r79, r80, r81, r82, r83, r84, r85, r86, r87, r88, r89, r90, r91, r92, r93, r94, r95, r96, r97, r98, r99, r100, r101, r102, r103, r104, r105, r106, r107, r108, r109, r110, r111, r112 from informix.systables where informix.metadata_2(o1 # int, o2 # int, o3 # int, o4 # int, o5 # int, o6 # int, o7 # int, o8 # int, o9 # int, o10 # int, o11 # int, o12 # int, o13 # int, o14 # int, o15 # int, o16 # int, o17 # int, o18 # int, o19 # int, o20 # int, o21 # int, o22 # int, o23 # int, o24 # int, o25 # int, o26 # int, o27 # int, o28 # int, o29 # int, o30 # varchar(50), o31 # int, o32 # int, o33 # int, o34 # int, o35 # varchar(100), o36 # varchar(100), o37 # varchar(100), o38 # varchar(100), o39 # varchar(100), o40 # varchar(100), o41 # varchar(100), o42 # varchar(100), o43 # varchar(100), o44 # varchar(100), o45 # varchar(100), o46 # int, o47 # int, o48 # int, o49 # int, o50 # int, o51 # int) = 1 and tabid = 1;

return r1, r2, r3, r4, r5, r6, r7, r8, r9, r10, r11, r12, r13, r14, r15, r16, r17, r18, r19, r20, r21, r22, r23, r24, r25, r26, r27, r28, r29, r30, r31, r32, r33, r34, r35, r36, r37, r38, r39, r40, r41, r42, r43, r44, r45, r46, r47, r48, r49, r50, r51, r52, r53, r54, r55, r56, r57, r58, r59, r60, r61, r62, r63, r64, r65, r66, r67, r68, r69, r70, r71, r72, r73, r74, r75, r76, r77, r78, r79, r80, r81, r82, r83, r84, r85, r86, r87, r88, r89, r90, r91, r92, r93, r94, r95, r96, r97, r98, r99, r100, r101, r102, r103, r104, r105, r106, r107, r108, r109 with resume;

end procedure;