CREATE PROCEDURE "informix".test( code int )
returns nvarchar( 64 );
  DEFINE toRet nvarchar( 64 );
  DEFINE somevar int;
  LET somevar = code;
  LET toRet = CAST(somevar AS nvarchar( 64 ));
  RETURN toRet;
END PROCEDURE;

private IfxCommand lCommand;
		private void CreateCommand( )
		{
			// command init
			IfxConnection lConnection = new IfxConnection( "Client Locale=ru_ru.1251;Connection Timeout=30;Database=zak_3;Database Locale=ru_ru.1251;Host=ois3;Persist Security Info=True;Protocol=olsoctcp;Password=111;Server=ol_svr_custom;Service=9088;User ID=informix" );
			this.lCommand = new IfxCommand( "test", lConnection );
			this.lCommand.CommandType = CommandType.StoredProcedure;
			this.lCommand.Parameters.Add( new IfxParameter( "RETURN_VALUE", IfxType.Integer,  4 , System.Data.ParameterDirection.ReturnValue, false, ( (System.Byte)(  0  ) ), ( (System.Byte)(  0  ) ), null, System.Data.DataRowVersion.Current, null ) );
			this.lCommand.Parameters.Add( new IfxParameter( "code", IfxType.Integer,  4 , System.Data.ParameterDirection.Input, false, ( (System.Byte)(  0  ) ), ( (System.Byte)(  0  ) ), null, System.Data.DataRowVersion.Current, null ) );
		}
		private void btnCallProc_Click( object sender, EventArgs e )
		{
			if( this.lCommand == null )
				// bdc: create command if not exists
				this.CreateCommand( );

			// set parameter value:
			lCommand.Parameters["code"].Value =  111 ;

			try
			{
				lCommand.Connection.Open( );
				lCommand.ExecuteNonQuery( );
				MessageBox.Show( "Success call: " + lCommand.Parameters["RETURN_VALUE"].Value.ToString( ) );
			}
			catch( Exception ex )
			{
				MessageBox.Show( ex.Message );
			}
			finally
			{
				lCommand.Connection.Close( );
			}
		}

		private IfxCommand lCommand;
		private void CreateCommand( )
		{
			// command init
			IfxConnection lConnection = new IfxConnection( "Client Locale=ru_ru.1251;Connection Timeout=30;Database=sysmaster;Database Locale=ru_ru.1251;Host=ois3;Persist Security Info=True;Protocol=olsoctcp;Password=111;Server=ol_svr_custom;Service=9088;User ID=informix" );
			this.lCommand = new IfxCommand( "select * from logmessage where message_num = ?", lConnection );
			this.lCommand.CommandType = CommandType.Text;
			this.lCommand.Parameters.Add( new IfxParameter( "message_num", IfxType.Integer,  4 , System.Data.ParameterDirection.Input, false, ( (System.Byte)(  0  ) ), ( (System.Byte)(  0  ) ), null, System.Data.DataRowVersion.Current, null ) );
		}
		private void btnCallProc_Click( object sender, EventArgs e )
		{
			if( this.lCommand == null )
				// bdc: create command if not exists
				this.CreateCommand( );

			// set parameter value:
			lCommand.Parameters["message_num"].Value =  111 ;

			try
			{
				lCommand.Connection.Open( );
				lCommand.ExecuteNonQuery( );
				MessageBox.Show( "Success call");
			}
			catch( Exception ex )
			{
				MessageBox.Show( ex.Message );
			}
			finally
			{
				lCommand.Connection.Close( );
			}
		}

public int test() 
        {
            IfxCommand Cmd = new IfxCommand("", IfxConn);
            Cmd.CommandText = "execute function urc_check_auth(?, ?)";
            Cmd.Parameters.Add("user", IfxType.Integer);
            Cmd.Parameters.Add("BFunc", "");

            // IfxConn.Open( );   // это видимо уже сделано где то ранее
            int UserType = - 1 ;
            Cmd.Parameters["user"].Value =  1 ;
            IfxDataReader rdm = Cmd.ExecuteReader();
            if (rdm.Read()) UserType =  11 ;
            rdm.Close();
            IfxConn.Close( );

            IfxConn.Open( );
            Cmd.Parameters["user"].Value =  2 ;
            rdm = Cmd.ExecuteReader();
            if (rdm.Read()) UserType =  22 ;
            rdm.Close();
            IfxConn.Close( );

            return (UserType);
        }