New post
Question
· Aug 21, 2020

IRIS SQL Linked Table

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

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