Professional Web Applications Themes

Bug or feature in SQL SP - IBM DB2

Hi all. In db2diag.log I found next record 2003-07-03-13.21.46.812000 Instance:DB2 Node:000 PID:2096(db2dari.exe) TID:3144 Appid: base_sys_utilities sqle_isMappingNeeded Probe:10 Mapping is not defined for the following types: 2003-07-03-13.21.46.812001 Instance:DB2 Node:000 PID:2096(db2dari.exe) TID:3144 Appid: base_sys_utilities sqle_isMappingNeeded Probe:20 Passed type: ec01 ?. 2003-07-03-13.21.46.812002 Instance:DB2 Node:000 PID:2096(db2dari.exe) TID:3144 Appid: base_sys_utilities sqle_isMappingNeeded Probe:30 Signature type: c001 ?. I try determine a problem through statement monitor without success. After many hours problem was located inside sql sp code procedure p1 ... declare v_param1 as bigint; declare v_param2 as varchar; call p2(v_param1); -- bug, need v_param2 but procedure p2 declared with procedure p2 (in v_param varchar) Procedure p1 ...

  1. #1

    Default Bug or feature in SQL SP

    Hi all.

    In db2diag.log I found next record

    2003-07-03-13.21.46.812000 Instance:DB2 Node:000
    PID:2096(db2dari.exe) TID:3144 Appid:
    base_sys_utilities sqle_isMappingNeeded Probe:10

    Mapping is not defined for the following types:

    2003-07-03-13.21.46.812001 Instance:DB2 Node:000
    PID:2096(db2dari.exe) TID:3144 Appid:
    base_sys_utilities sqle_isMappingNeeded Probe:20

    Passed type: ec01 ?.


    2003-07-03-13.21.46.812002 Instance:DB2 Node:000
    PID:2096(db2dari.exe) TID:3144 Appid:
    base_sys_utilities sqle_isMappingNeeded Probe:30

    Signature type: c001 ?.


    I try determine a problem through statement monitor without success. After
    many hours problem was located inside sql sp code

    procedure p1
    ...
    declare v_param1 as bigint;
    declare v_param2 as varchar;
    call p2(v_param1); -- bug, need v_param2

    but procedure p2 declared with

    procedure p2 (in v_param varchar)


    Procedure p1 is compiled without errors and warnings :-(

    Andy

    andreyp#Antispam@mapsitnA#e-vision-group.com Guest

  2. #2

    Default Re: Bug or feature in SQL SP

    Er, sorry, responded too quickly my previous answer...in v7, this create
    /exec will get by because call is not a compiled statement, in v8,
    you'll get an error. (in v7, you can ever create a procedure a that
    calls procedure b when procedure b is not cataloged...but not in v8).

    andreyp#AntispammapsitnA#e-vision-group.com wrote:
    > Hi all.
    >
    > In db2diag.log I found next record
    >
    > 2003-07-03-13.21.46.812000 Instance:DB2 Node:000
    > PID:2096(db2dari.exe) TID:3144 Appid:
    > base_sys_utilities sqle_isMappingNeeded Probe:10
    >
    > Mapping is not defined for the following types:
    >
    > 2003-07-03-13.21.46.812001 Instance:DB2 Node:000
    > PID:2096(db2dari.exe) TID:3144 Appid:
    > base_sys_utilities sqle_isMappingNeeded Probe:20
    >
    > Passed type: ec01 ?.
    >
    >
    > 2003-07-03-13.21.46.812002 Instance:DB2 Node:000
    > PID:2096(db2dari.exe) TID:3144 Appid:
    > base_sys_utilities sqle_isMappingNeeded Probe:30
    >
    > Signature type: c001 ?.
    >
    >
    > I try determine a problem through statement monitor without success. After
    > many hours problem was located inside sql sp code
    >
    > procedure p1
    > ..
    > declare v_param1 as bigint;
    > declare v_param2 as varchar;
    > call p2(v_param1); -- bug, need v_param2
    >
    > but procedure p2 declared with
    >
    > procedure p2 (in v_param varchar)
    >
    >
    > Procedure p1 is compiled without errors and warnings :-(
    >
    > Andy
    >
    Sean McKeough Guest

Similar Threads

  1. Bug or feature ?
    By Laiverd.COM in forum Macromedia Contribute General Discussion
    Replies: 1
    Last Post: June 2nd, 06:08 PM
  2. Feature or Bug
    By Neal Duitz in forum Windows Vista
    Replies: 5
    Last Post: March 15th, 02:40 AM
  3. Log-in feature
    By Jeremy Williams in forum Macromedia Dynamic HTML
    Replies: 16
    Last Post: November 30th, 09:15 PM
  4. the 3d feature
    By steven_edward_jones@adobeforums.com in forum Adobe Illustrator Macintosh
    Replies: 29
    Last Post: February 16th, 09:03 AM
  5. feature or bug?
    By Shel Blauman [MSFT] in forum ASP.NET Security
    Replies: 1
    Last Post: August 11th, 07:02 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139