TM1 Forum

Guys,

As far as I can tell (and experienced in the past) ODBCOutput does not return any kind of error code when executing a query. The IBM documentation only mentions the 255 character limit. I plan on writing a sub process to validate the DB after the query has executed but if there's a better way I'd love to know what it is. BTW the query I'm executing is running an SQL stored procedure to load a table before TM1 pulls the info in,

Jim.

jim wood wrote: ↑Wed Feb 27, 2019 7:22 pm Guys,

As far as I can tell (and experienced in the past) ODBCOutput does not return any kind of error code when executing a query. The IBM documentation only mentions the 255 character limit. I plan on writing a sub process to validate the DB after the query has executed but if there's a better way I'd love to know what it is. BTW the query I'm executing is running an SQL stored procedure to load a table before TM1 pulls the info in,

Jim.

You don't have to use ODBCOutput to execute a query. You can do that by using it as a data source in a TI as well. For example, if you had a stored procedure called "DoSomething" that inserted into tables or whatever and inside that stored procedure a sent output based on the success (by doing SELECT 'Success' AS Msg or SELECT 'Failure' AS Msg) then you could use DoSomething as a TI data source in a TI. When the TI is executed, the stored procedure does the inserts and then returns the Success or Failure message. You could write that message to a cube.

Thanks Tom, that's a nice suggestion. I have a system process for executing store procedures so that's something I could instead of building the code with the prolog,

Jim.