Announcement

Collapse
No announcement yet.

Mapping of application with database

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Mapping of application with database

    Hi All,

    Is it Possible to find out the a column in application mapped with the database table

    Eg:
    In Simple Order ID,Source Location,Destination Location and Early Pick up dates are there i don't know the corresponding back end table's column for this, In this case is there any possible ways to find out the link between the application column and the backed table column.

    Attached Files
    Thanks
    Gokul

  • #2
    Re: Mapping of application with database

    Hi Gokul,

    To me it sounds the following:

    - Enter an order through the screen.
    - Look into the database tables where it is stored.

    You have to have the data dictionairy for that.

    Order releases are stored in ORDER_RELEASE for example.

    Best regards,

    Bob
    Best Regards,

    Bob Romijn

    Comment


    • #3
      Re: Mapping of application with database

      Hi,

      Basically two ways as I see it:

      1. Through experience
      2. Turn on the UI / SQL logs and when you enter something via the UI, check the logs to see what the insert / update / delete commands are doing.

      Comment


      • #4
        Re: Mapping of application with database

        bmj

        thanks for ur rep, may i know where the log will be.
        Thanks
        Gokul

        Comment


        • #5
          Re: Mapping of application with database

          Hello,

          After enabling UI / SQL Logs within the OTM application, the output will go to the glog.app.log files by default, which are in the $OTM_HOME/logs directory on your OTM App server. You can also choose to split these off into separate log files, if you choose.

          --Chris

          Comment

          Working...
          X