Subject | Re: [IBO] key links for newbie |
---|---|
Author | Helen Borrie |
Post date | 2003-06-12T21:47:35Z |
At 04:55 PM 12/06/2003 +0000, you wrote:
the server is holding for the statement. In PSQL, FOR SELECT DO cycles
through an input set. It's often used in combination with SUSPEND to
return an output set to the client.
mentioned are ordinary variables in the C program that are declared for the
purpose of receiving the values specified by a SELECT statement. Stored
procedure language (PSQL) is a set of SQL language extensions that enables
you to write server-based code modules (SPs and triggers). The ability to
use local variables (i.e. local to the module) is one of these language
extensions.
deadline right now, and this is something all non-newbies know. But I'll
get the other message and try to give you a brief rundown.
Helen
>hi does this mean that for update is something like the for do selectNo. Its purpose is to return one row at a time from the output set that
>statement in stored procedure?
the server is holding for the statement. In PSQL, FOR SELECT DO cycles
through an input set. It's often used in combination with SUSPEND to
return an output set to the client.
>and you have mention variables? isNo. Embedded applications are C programs. The "host variables" I
>that the same variable we use in the store procedure?
mentioned are ordinary variables in the C program that are declared for the
purpose of receiving the values specified by a SELECT statement. Stored
procedure language (PSQL) is a set of SQL language extensions that enables
you to write server-based code modules (SPs and triggers). The ability to
use local variables (i.e. local to the module) is one of these language
extensions.
>Thanks for the well explanation, but you have not touch the topicYeah, well, I was hoping someone else would do that, since I'm racing for a
>about using different kind of sql statement in TIB_lookupcombo setup,
>and the different use of keylinks and etc ...
deadline right now, and this is something all non-newbies know. But I'll
get the other message and try to give you a brief rundown.
Helen