IBM Support

JR35551: ON WINDOWS , MS SQL SERVER FEDERATED PROCEDURE CONTAINING QUERY STATEMENT AND ANY OTHER STATEMENTS CAN NOT RETURN RESULT SET

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • On Windows platforms, when you create a federated procedure for
    a remote Microsoft SQL Server stored procedure, if there is any
    other statement defined before or after query statement in that
    stored procedure, after calling this federated procedure you
    can't get any records or description of result set.
    
     For example:
    
    1. Create a remote procedure like follow on SQL Server
    
     CREATE PROCEDURE SQLProcedure @V1 INTEGER AS
     BEGIN
     IF ( @V1 = 0 )
     SELECT * FROM SQLTable
     END
    
    2. Create an federated procedure like follow on Federation
    Server
    
    CREATE PROCEDURE FedProcedure SOURCE SQLSchema.SQLProcedure  FOR
    SERVER "SQLSERVER" WITH RETURN TO CLIENT ALL READS SQL DATA
    
    3. Call the federated procedure on Windows platform
    
    call SQLProcedure(0)
    
    You will get message "Return Status = 0" with no result set
    returned. This problem is because of that ODBC driver on Windows
    platform (SQL Server Native Client), as opposed to those on
    other platforms, returns an extra informational result set when
    stored procedure includes any other statement besides query
    statement, and Federation takes this informational result set as
    the first real result set.
    

Local fix

Problem summary

  • Users affected:
       Users of the MS SQL Server wrapper in InfoSphere Federation
    Server
    Problem description and summary:
       See error description.
    

Problem conclusion

  • Problem was first fixed in Version 9.1 FixPak 9 (s100326 ). This
    fix should be applied on the federation server.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR35551

  • Reported component name

    FEDERATION SERV

  • Reported component ID

    5724N9700

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-02-02

  • Closed date

    2010-04-14

  • Last modified date

    2010-04-14

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    FEDERATION SERV

  • Fixed component ID

    5724N9700

Applicable component levels

  • R910 PSN

       UP

  • R911 PSN

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS2K5T","label":"InfoSphere Federation Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 October 2021