Mindmajix

Create a macro to modify multi-lingual column names dynamically

Create a macro to modify multi-lingual column names dynamically : (Know definition of MACRO, for a clear understanding).

  • From MODEL
  • Expand the SALES namespace
  • Select the query subject return_reason
  • Right click
  • Click on Edit definition
  • Delete the default SQL query from SQL pane
  • Expand Gosl
  • From available database objects pane
  • Select table returns_reason
  • Select the following query items
  • Return_reason_code
  • Return_description_fr
  • Drop on SQL pane
  • From Query
  • Delete fr
  • Click on insert macro
  • Expand parameter maps
  • Double click on localemap
  • Using last arrow key
  • Place the cursor between braces
  • Expand session parameters
  • Double click on run locale
  • Delete space between } and #
  • Click on OK
  • Click on Test tab
  • Click on Test sample
  • Click on OK

Screenshot_246

Screenshot_247

Screenshot_248

Screenshot_249

Screenshot_250

Screenshot_251

 

http://ibm.co/1s6Ab3S

 


 

0 Responses on Create a macro to modify multi-lingual column names dynamically"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.