I need pass to parameter to my query in SQL STATEMENT TO EXECUTE BEFORE/AFTER TRANSLATION. For example: I am working with GEOMEDIA. I need to standardize the foreing keys names, pk names, sequences names, and insert to GDOSYS (the metadata for geomedia). I am using dynamic schema from readers to writers for all tables(features) in my folder. I need to pass parameters to queries to be executed before and after the writer. How to do?
Regards,
Sólon
I dont think it is possible, you can try running the sql before and after the translation with a sql creator/executor.
I think it's possible via the Scripted Parameter (Python or Tcl).
If you define two scripted parameters to create Before / After SQL statements based on published parameters, you can link SQL STATEMENT TO EXECUTE BEFORE/AFTER TRANSLATION to them.
Use the following syntax in the script to access a published parameter.
(Python)
FME_MacroValuesa'parameter_name']
(Tcl)
$FME_MacroValues(parameter_name)
Takashi
I solved with WorkspaceRunner.
Thanks All.