Subject | Re: [firebird-support] Scripting |
---|---|
Author | MIDIcat Support |
Post date | 2006-06-01T14:00:10Z |
On 6/1/06, Helen Borrie <helebor@...> wrote:
scripting, where:
1. You run a script using @my_script.sql
2. You can pass parameters to a script and refer to the by &1, &2 and so on
3. You can print something using PROMPT
4. You can ask for a parameter using ACCEPT
5. You can set display options using SET (e.g. SET FEEDBACK OFF)
Regards,
> >Where can I read about FB scripting (how to run a script from isql,No, I'm not. I'm just looking for features similar to Oracle SQL*Plus
> >how to pass parameters, how to control output and so on)?
>
> You can't pass parameters to a script and a script doesn't have
> output. It's just a list of statements that are executed one by one.
> Are you confusing "scripting" with stored procedures?
scripting, where:
1. You run a script using @my_script.sql
2. You can pass parameters to a script and refer to the by &1, &2 and so on
3. You can print something using PROMPT
4. You can ask for a parameter using ACCEPT
5. You can set display options using SET (e.g. SET FEEDBACK OFF)
Regards,