IRIS SQL Linked Table

Question

Question

Joao Palma · Aug 21, 2020

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...

Discussion (4)2

Log in or sign up to continue

Asaf Sinay · Sep 2, 2020

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

0 1

score 0 · Answer 1 · 2020-08-21T08:50:52-04:00

Eduard Lebedyuk · Aug 21, 2020

Reimport linked table.

0 0

score 0 · Answer 2 · 2020-08-21T09:04:46-04:00

Joao Palma · Aug 21, 2020

That's not ideal for me a I would have to drop the table first.

0 0

score 0 · Answer 3 · 2020-09-14T08:50:42-04:00

Great. Thank you both.

I will do this next time.

- Backup class

- Drop table

- Reimport table

Best Regards,

Joao