Answer

You can use IBM i green screen command Create DB2 Web Query synonym (CRTWQSYN) to refresh a one-part name synonym, but most Web Query users can use the BI Portal or Developer WorkBench.

(Developer WorkBench does not have an option to refresh a one-part naming synonym)

Here's the BI Portal steps:

1) Sign on to the BI Portal

2) Find the Top Level Folder that has the synonym to refresh on the left hand tree view

3) Right click on the Top Level Folder name, Metadata -> New

4) A new window pops up - this called the 'reporting server console'.

5) Again find the Top Level Folder name that has the synonym.

Note that on this screen the Top Level Folder name may be slightly different.

- due to rename of the Top Level Folder, etc.

6) Expand DB2 cli

7) Right click on *LOCAL -> Create or Update Synonym

8) Enter the library name that has the table - to be used as the template for the synonym refresh

9) You are on now on the "Create Synonym for DB2 (*LOCAL)" screen

9a) You do NOT need to update 'One-part name' under Miscellaneous Parameters

9b) You do want to make sure under Customize data type mappings that your 'Application', 'Prefix', 'Suffix' values are set.

- This information is used to 'find' the correct Web Query synonym to update

9b) Still within Customize data type mappings, you must change the 'Update or Create Metadata' to Update.

9c) Finally find the correct table in the list provided at the bottom of this window

9d) Select Next when ready

10) You are now on the "Update Synonyms for DB2 (*LOCAL)" screen. Do not change anything on this screen, select Next.

11) You should arrive at the "Create Synonym for DB2 Status" screen and you should see a success message.

Note that if the table is the IBM i user's *CURLIB, the refresh will work.

(Parameter CURLIB on the CHGUSRPRF/CRTUSRPRF commands)

The Developer WorkBench instructions are similar:

a) Developer WorkBench -> yourIBMi -> Data Servers -> EDASERVE -> Applications

b) Find the Top Level Folder that has the synonym to refresh on the left hand tree view

c) Right click on the Top Level Folder name, New -> Synonym

d) A new dialog box pops up - 'Select adapter to configure or Select connection ...'

e) Expand the 'DB2 cli' folder if need be

f) Double click on yourIBMi again.

g) On the 'Select Synonym Candidates for DB2' dialog box, enter in the IBM i library name for the 'Library' parameter where your logical file (SQL View) or physical file (table) is located, select "Next"

h) On the 'Create Synonym for DB2' dialog box, expand "Miscellaneous Parameter" and select 'One-part name'. Do steps h, i, j together.

i) On the same 'Create Synonym for DB2' dialog box, change "Update or Create Metadata" from Create to Update. Do steps h, i, j together.

j) Still on the 'Create Synonym for DB2' dialog box, select the synonym to update. Do steps h, i, j together.

k) Select Next

l) A new dialog box 'Update Synonyms for DB2' pops up. Select what should be updated, select Next.

m) Another dialog box - it does not clearly state that it was successful - but does not give an error either