Hello,

I was wondering if it is possible with 24x7 scheduler to use bind variables in JAL database statements instead of hard coding values.

Example of bind variable usage:

SELECT name FROM company_list WHERE industry = :strIndustry

Example of hard coding:

SELECT name FROM company_list WHERE industry = 'BANKING'

I have only seen hard coded examples in the documentation.

Thank You

John

Not supported at this time.

But, you don't have to hard code your SQL. It can be build dynamically
like
ConcatEx "SELECT name FROM company_list WHERE industry = '", myVariable, "'", mySELECT
DatabaseRetrieve mySelect, Rows

Another option you have is to create a stored procedure that does the SELECT for you then you can use that procedure for the DatabaseRetrieve. Of course that procedure should be executed with parameters (see second paragraph above).
From your database point of view, there is a big difference as it will not cache all versions of the SELECT created by hardcoded values and thus it will speed up the SQL processing as well as provide more efficient database utilization.

: Hello,

: I was wondering if it is possible with 24x7 scheduler to use bind variables
: in JAL database statements instead of hard coding values.

: Example of bind variable usage: SELECT name FROM company_list WHERE industry
: = :strIndustry

: Example of hard coding: SELECT name FROM company_list WHERE industry =
: 'BANKING'

: I have only seen hard coded examples in the documentation.

: Thank You

: John