Is it possible to pass a null value parameter to a MS SQL stored procedure? I need to be able to pass null values to a stored procedure. I've tried many things but none of them seem to work. Has anyone been able to do this successfully? I am including my code and the trace below.
You may require some Dialogue Manager code if these variables could contain null or some other value as passed by a prior process, but if they are constantly null, this should work.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
March 27, 2017, 08:26 AM
gerndude
I have tried that. This is the error message I get.
(FOC1400) SQLCODE IS 8114 (HEX: 00001FB2) XOPEN: 22018 : Microsoft OLE DB Provider for SQL Server: [22018] Error converting data : type varchar to datetime. L (FOC1405) SQL PREPARE ERROR.
It seems that WF will not allow me to pass a variable that does not match the format in the stored procedure. If you execute the stored procedure directly inside MSSQL without WF, it will accept the 'null' value. Any suggestions on how this can be overcome?
WebFOCUS 8203 Gen 43 App Studio 8203 Gen 04232018 Hyperstage 8203M Gen 1320 MS Sequel Server 2014 Windows 10 Excel/AHTML/PDF/HTML Chrome, IE11
March 27, 2017, 08:50 AM
Francis Mariani
That is a SQL error message, not a WebFOCUS one. Is the null in quotes? It shouldn't be.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
March 27, 2017, 09:17 AM
gerndude
Francis, Thanks so much for your wise help on this. I have been struggling with this for one week. I finally have results. Awesome!
WebFOCUS 8203 Gen 43 App Studio 8203 Gen 04232018 Hyperstage 8203M Gen 1320 MS Sequel Server 2014 Windows 10 Excel/AHTML/PDF/HTML Chrome, IE11