-inp Startup Parameter

[cluc]

Hello All,

I've been trying to find out if there's a way to display the -inp value in the procedure editor or from the data administrator.
Because the -inp file was not specified in the startup parameter, I'm assuming it is using 4096 characters for the max value, but I have two databases started up and they seem to be having different -inp values, with no -inp parameter supplied.

Thanks in advance.
Calv

 

[joey.jeremiah]

databases and -inp ?

isn't -inp the max characters in a single statement i.e. they're a client startup parameter not a database server parameter

from the client you can run - MESSAGE SESSION:STARTUP-PARAMETERS VIEW-AS ALERT-BOX. to show any startup parameters supplied to the current session, including parameters from .pf file

 

[cluc]

Sorry, you are right.
Thanks for the tip.

cheers.