IRIS SQL Linked Table
Hi everyone
Anyone knows how can we add a column to an existing linked table in Cache to reflect the external SQL table?
I've tried different queries. It does not fail but does not add the column either...
Hi everyone
Anyone knows how can we add a column to an existing linked table in Cache to reflect the external SQL table?
I've tried different queries. It does not fail but does not add the column either...
Reimport linked table.
That's not ideal for me a I would have to drop the table first.
Hello Joao,
You should be able to edit the linked table's class definition, but reimporting it should be the safest approach.
Please note that linked tables don't actually persist the data locally, but simply define the metadata for the remote table.
I would suggest backing up your linked table class definition first.
Sincerely,
Asaf
Great. Thank you both.
I will do this next time.
- Backup class
- Drop table
- Reimport table
Best Regards,
Joao