Skip to main content
Question

Pass and Modify Publish Parameter for Writer clause SQL STATEMENT TO EXECUTE BEFORE/AFTER TRANSLATION

  • October 23, 2013
  • 3 replies
  • 38 views
S
Hi all,

 

 

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
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

fmelizard
Safer
Forum|alt.badge.img+22
  • fmelizardSafer
  • Safer
  • October 23, 2013
Hi,

 

 

I dont think it is possible, you can try running the sql before and after the translation with a sql creator/executor.
takashi
Celebrity
  • takashiCelebrity
  • October 24, 2013
Hi Sólon,

 

 

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_MacroValues['parameter_name']

 

(Tcl)

 

$FME_MacroValues(parameter_name)

 

 

Takashi
Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
S
  • s_lon
  • Author
  • November 13, 2013
Ok. Resolved.

 

I solved with WorkspaceRunner.

 

 

Thanks All.  

Community Stats

32,707
Posts
124,103
Replies
41,180
Members
Terms & ConditionsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.