IRIS SQL Linked Table

Primary tabs

SQL, Caché

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

Replies

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