In the course of a project to improve some of our documentation I was interested to come across the Remarks column in the SYS.SYSPROCPARM system view. I checked the syntax of COMMENT and as I had remembered, parameters of procedures aren't mentioned. My disappointment was complete (a sad reflection on my aspirations these days) when I looked at the view definition and saw

cast(null as long varchar) as remarks
I presume it is there for compatibility reasons or as an idea for a future enhancement. Perhaps this idea and or compatibility requirement could assume a more tangible form in a later version?

asked 06 Aug '15, 14:53

Justin%20Willey's gravatar image

Justin Willey
6.7k108141208
accept rate: 20%

edited 06 Aug '15, 15:18


It existed in the real SYSPROCPARM table up to V9 but I don't think there was any way to use COMMENT ON to populate it.

It was dropped from the real ISYSPROCPARM table and the SYSPROCPARM view in V10 as part of The Great Leap Forward In System Table Design.

It was restored to the SYSPROCPARM view in V12 as described in the V12 and V16 docs...

remarks LONG VARCHAR Always returns NULL. Provided to allow the use of previous versions of ODBC drivers with newer personal database servers.

What are the chances of it being implemented? Wait here, it'll be along soon... :)

alt text

permanent link

answered 06 Aug '15, 15:42

Breck%20Carter's gravatar image

Breck Carter
25.7k428592852
accept rate: 20%

edited 06 Aug '15, 15:43

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×201
×107
×24

question asked: 06 Aug '15, 14:53

question was seen: 331 times

last updated: 06 Aug '15, 15:43