Hi,

I am doing


ENGINE SQLODBC SET DEFAULT_CONNECTION kuku

SQL SQLODBC PREPARE HO FOR
select ....
END
-RUN

and after that several time doing things like
DEFINE HO
dd/a3= ....
END
TABLE FILE HO
PRINT *
WHERE XX EQ 1
END

DEFINE HO
dd/a3= ....
END
TABLE FILE HO
PRINT *
WHERE XX EQ 6
END

etc.

When I look on log, it is showing me that WF runs select that I wrote to extract file HO each time when I do TABLE FILE HO. Each time this select goes with additional consitionsl like XX=1 or XX=6 etc.

Is it normal?
Do I need to do imidiately after SQL extract something like
TABLE FILE HO
PRINT *
ON TABLE HOLD AS HO2
END

and then use HO2 doing all necessary transformations?

This message has been edited. Last edited by: <Kathryn Henning>,

A SQL passthru will run everytime you run that fex file. I think what you are trying to accomplish is to create a permanent hold file where you take your SQL passthru, run it and then save the subsequent table so you can use it in other fexes, such as...

ENGINE SQLORA SET DEFAULT_CONNECTION <databasename>
SQL SQLORA PREPARE SQLOUT FOR
SELECT 
<whatever your SQL code is>
END

APP HOLD <name of folder on app server where you want to store the table>

TABLEF FILE SQLOUT
PRINT
<WF code here, this will be the structure and fields of the table you save>
END


APP HOLD

Hopefully this helps

Another way to do this is to:

SQL
SELECT ........
FROM ......
WHERE .....
;
TABLE
ON TABLE HOLD AS ...... FORMAT ......
END
-RUN


Then do your defines. Your SQL will only run once.

Thanks, Toma and MattC!