#SQL

13

SQL is a standard language for storing, manipulating and retrieving data in relational databases.

Hey Community!

We're happy to share a new video from our InterSystems Developers YouTube:

⏯ Foreign Tables In 2025.2 @ Ready 2025

https://www.youtube.com/embed/pIMa7lqWiHc
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

<--break->

0 0
0 12

Hello!

I'm trying to create some foreign tables to a PostgreSQL database. In some cases, columns with certain datatypes cannot be consumed by IRIS and the following error is thrown:

[SQLCODE: <-237>:<Schema import for foreign table did not return column metadata>]

[%msg: <Unkown data type returned by external database>]

For example: serial4 typed ID columns are typical examples. Is it possible, what's the best way of resolving these datatypes, which- seemingly- don't have proper JDBC metadata mappings?

0 0
0 24