Adding a column to a View Table

Adding a column to a View Table

Issue/Symptom/Question

How to add a column to a View Table

Applies To

PLEdit. GoldView, Golden

Resolution/Fix/Answer

  • Connect to the customer's database through Golden.
  • All the tables in the Customer's database can be seen by going to: Tools → GoldView.

  • However, to update the tables one needs to go to: Tools → PLEdit. Search and click on the table that needs to be updated.

  • Within the parenthesis in the 'View' statement add the name one wants to identify the column with.
  • In the 'Select' statement add the column name.

  • Once the necessary updates have been made, click on 'Code' and then 'Compile'.

 

  • To check, if the changes are reflected correctly, run and check the relevant script in Golden.Â