limit of sysexecsql

Database
Enthusiast

limit of sysexecsql

Hi,

 I've below 3 questions regarding SYSEXECSQL.

1) call dbc.sysexecsql('string_without_variables_in_it') . What can be the maximum length of the string_without_variables_in_it.

2) call dbc.sysexecsql(variable_declared_in_the_procedure). What length can i assign to 'variable_declared_in_the_procedure' variable during declaration.

3) call dbc.sysexecsql('string_with_variables_in_it') . What can be the maximum length of the string_with_variables_in_it including the length of the variables (after substituting their respective values)

It would be helpful to me if someone could provide answers to above.

Thanks

Shashi