如何将来自IBM SQL查询服务的结果存储到IBM Db2 on Cloud? [英] How to store results from IBM SQL Query service into IBM Db2 on Cloud?

问题描述

我对使用IBM SQL Query服务查​​询Cloud上的IBM Db2有疑问.假设我有一个在IBM SQL Query控制台上运行的查询语句，我想从SQL Query服务连接到IBM Db2 on Could，以便可以将查询结果保存到数据库中. 我已经在Cloud lite实例上创建了IBM SQL Query服务和Db2.

I have a question regarding using IBM SQL Query service to query IBM Db2 on Cloud. Let's say I have a query statement that is running on the IBM SQL Query console I want to make a connection to IBM Db2 on Could from SQL Query service so that I can save the query result into the database. I have created the IBM SQL Query service and Db2 on Cloud lite instance.

你们可以帮助我吗?

推荐答案

data_henrik已经为此提供了很好的博客资源.

data_henrik has already provided a good blog resource for that.

有关正式文档，请参见 https://cloud.ibm.com/docs/services/sql-query?topic=sql-query-overview#db-location

For formal documentation see here https://cloud.ibm.com/docs/services/sql-query?topic=sql-query-overview#db-location

还要在样本"->/ETL&中找到Db2目标样本. ELT查询"在用户界面中下拉.

Also check out the Db2 target samples in the "Samples"->/ETL & ELT queries" pull down in the UI.

这篇关于如何将来自IBM SQL查询服务的结果存储到IBM Db2 on Cloud?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！