User Profile

Collapse

Profile Sidebar

Collapse
cardscat
cardscat
Last Activity: Mar 18 '08, 12:51 PM
Joined: Feb 21 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • cardscat
    started a topic Passing an array to a Web Service
    in .NET

    Passing an array to a Web Service

    Would anyone have a C# example of passing a string array to a Web Service?

    Thanks

    cardscat
    See more | Go to post

  • cardscat
    replied to DB2 Stored Procedure Select
    in DB2
    I have discovered the error of my ways. I am used to SQLServer and the like where numeric values are a set size (int, smallint, long,etc.). My Create Procedure statment should have looked like this:

    Code:
    create procedure cardscat(
    parmdec1           DEC(5) IN,
    parmchar1          Char(6) IN,
    parmdec2           DEC(12) IN,
    parmchar2          CHAR(2) IN)
    Just declaring DEC didn't get it.
    ...
    See more | Go to post

    Leave a comment:


  • cardscat
    replied to DB2 Stored Procedure Select
    in DB2
    Code:
    Thank you for your responses.
    
    The database shows the following properties for the decimal values:
    valdec1 Decimal, Precision-5, Scale-0
    valdec2 Decimal, Precision-12, Scale-0
    
    The Create Procedure statement is:
    create procedure cardscat(
    parmdec1           DEC IN,
    parmchar1          Char(6) IN,
    parmdec2           DEC IN,
    parmchar2          CHAR(2) IN)
    LANGUAGE COBOL
    ...
    See more | Go to post

    Leave a comment:


  • cardscat
    started a topic DB2 Stored Procedure Select
    in DB2

    DB2 Stored Procedure Select

    I am having a problem with a DB2 stored Procedure written in COBOL. This sp takes several input parameters of different types:
    Code:
    Linkage Section.
    01  PARMDEC1         PIC S9(5) COMP-3.
    01  PARMCHAR1        PIC X(3).
    01  PARMDEC2         PIC S9(12) COMP-3.
    01  PARMCHAR2        PIC X(6)
    
    IN PROCEDURE DIVISION:
    
    THIS SELECT WORKS:
    SELECT * FROM TABLE A
    WHERE A.VALDEC1  = :PARMDEC1
    ...
    See more | Go to post
    Last edited by docdiesel; Feb 22 '08, 09:45 AM. Reason: Added code tags
No activity results to display
Show More
Working...