Article
· Jan 27, 2023 1m read

Global-Streams-to-SQL #3

Seeing results in SMP or Terminal

If you run the suggested queries from Terminal in  SQL shell you see:



This is not so thrilling as the Stream OID doesn't show the content.
So I have added a dump function to show the stream  rcc.dumps(<column name>)
of course dumping of binaries doesn't make much sense in terminal so CHR and CZIP are typical.
see:


And it works even in SMP { IRIS for Windows (x86-64) 2022.3 (Build 589U)  } processing in foreground


 

Online Demo:  SuperServer Port for external ODBC / JDBC is 60001

I hope for your votes in the contest.

Discussion (0)1
Log in or sign up to continue