View previous topic :: View next topic
|
Author |
Message |
Vkp321
New User
Joined: 05 Jan 2009 Posts: 56 Location: Dublin
|
|
|
|
Is it possible to use one skeleton to write multiple steps in a file.
skeleton
select col1 from &Tbname
where col2=&val;
Below multiple lines in a file
select col1 from T1
where col2=10;
select col1 from T3
where col2=20;
select col1 from T2
where col2=30; |
|
Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
|
|
Vkp321 wrote: |
Is it possible to use one skeleton to write multiple steps in a file.
skeleton
select col1 from &Tbname
where col2=&val;
Below multiple lines in a file
select col1 from T1
where col2=10;
select col1 from T3
where col2=20;
select col1 from T2
where col2=30; |
Certainly. Although I won't be able to test for a few hours, the logic will go about like this:
Code: |
address ispexec "FTOPEN"
do i = 1 to lots
tbname = tables.i /*assume stem tables. contains all table names */
val = values.i /* assume stem values. contains all values searched for */
address ispexec "FTINCL SKELETON"
end
address ispexec "FTCLOSE QUERIES" |
You could also put the data in a table and use the )DOT construct in your skeleton. |
|
Back to top |
|
|
|