IBM Support

Passing Null Values to a Stored Procedure

Troubleshooting


Problem

If you have a stored procedure that has a default behavior when a null is passed as one or more of its parameters (particularly datetime parameters where you need to use a type-in prompt to pass the value), how can pass a null value when the prompt is not entered?

[{"Product":{"code":"SSQJTZ","label":"Cognos Impromptu"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Version Independent","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

1018592

Document Information

Modified date:
09 May 2025

UID

swg21339454