I am experiencing an issue while executing a stored procedure in InterSystems Cache. Here’s the procedure I created
CREATE PROCEDURE Silk.sp_InsertRecord ( IN RecordDate TIMESTAMP, IN UserName VARCHAR(50), IN RecordType INT, IN RecordID VARCHAR(50), IN CategoryID INT, IN ApprovalDate TIMESTAMP, IN FileSize BIGINT, IN WorkstationName VARCHAR(50) ) BEGIN INSERT INTO DummyRecords ( RecordKey, FilePath, RecordDate, UserName,
I have set up an ODBC driver for InterSystems and would like to set up a linked server. This all works except I cannot see the columns details. If I access the database from excel I can get the columns and types of the various tables