•Create
your query based on the fields and transformations
required
•Use
OPS Navigator or my freeware SQLThing tool.
•Create
the query as it will be used in your application.
–If
you are using replacement parms, then you must do the replacement
parms in the query