External Stored Procedures Limitations?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • pompeyoc
    #1

    External Stored Procedures Limitations?

    Hi. I was wondering if anyone out here knows if there is a limit to
    the size of an external stored procedure? I am currently using VB
    programs in Windows to call small COBOL stored procs residing in AIX
    without any problems. This time, however, I am planning to have
    another VB program call a COBOL stored proc that, in turn, calls other
    COBOL programs via ordinary COBOL CALLs.

    Any ideas?
    Tags: None
    • Serge Rielau
      #2
      Re: External Stored Procedures Limitations?

      pompeyoc wrote:
      Hi. I was wondering if anyone out here knows if there is a limit to
      the size of an external stored procedure? I am currently using VB
      programs in Windows to call small COBOL stored procs residing in AIX
      without any problems. This time, however, I am planning to have
      another VB program call a COBOL stored proc that, in turn, calls other
      COBOL programs via ordinary COBOL CALLs.
      Once you are in the external world it's up to the OS.
      Only when you do the CALL via SQL does and can DB2 count.
      The current limit for SQL CALLs is 64 (entirely arbitrary).

      Cheers
      Serge

      --
      Serge Rielau
      DB2 Solutions Development
      IBM Toronto Lab

        Comment

        • pompeyoc
          #3
          Re: External Stored Procedures Limitations?

          On Jan 8, 7:31 pm, Serge Rielau <srie...@ca.ibm .comwrote:
          pompeyoc wrote:
          Hi. I was wondering if anyone out here knows if there is a limit to
          the size of an external stored procedure? I am currently using VB
          programs in Windows to call small COBOL stored procs residing in AIX
          without any problems. This time, however, I am planning to have
          another VB program call a COBOL stored proc that, in turn, calls other
          COBOL programs via ordinary COBOL CALLs.
          >
          Once you are in the external world it's up to the OS.
          Only when you do the CALL via SQL does and can DB2 count.
          The current limit for SQL CALLs is 64 (entirely arbitrary).
          >
          Cheers
          Serge
          >
          --
          Serge Rielau
          DB2 Solutions Development
          IBM Toronto Lab
          Thanks for the reply, Serge. Which OS are you referring to? Windows or
          AIX?

            Comment

            • Serge Rielau
              #4
              Re: External Stored Procedures Limitations?

              pompeyoc wrote:
              On Jan 8, 7:31 pm, Serge Rielau <srie...@ca.ibm .comwrote:
              >pompeyoc wrote:
              >>Hi. I was wondering if anyone out here knows if there is a limit to
              >>the size of an external stored procedure? I am currently using VB
              >>programs in Windows to call small COBOL stored procs residing in AIX
              >>without any problems. This time, however, I am planning to have
              >>another VB program call a COBOL stored proc that, in turn, calls other
              >>COBOL programs via ordinary COBOL CALLs.
              >Once you are in the external world it's up to the OS.
              >Only when you do the CALL via SQL does and can DB2 count.
              >The current limit for SQL CALLs is 64 (entirely arbitrary).
              Thanks for the reply, Serge. Which OS are you referring to? Windows or
              AIX?
              Whichever your OS is... DB2 loads the library and invokes it - hands of.

              Cheers
              Serge
              --
              Serge Rielau
              DB2 Solutions Development
              IBM Toronto Lab

                Comment

                Previous template Next
                Working...