How export data using query

Question

Question

Rafael Santos · Feb 26, 2018

#Beginner #Caché

Hi, iam newbie on caché database.

Iam trying, export data from query.

I read in some article that is not so simple.

So I create a view then a execute a query insert into select statement.

I have problem to know the job progress. I execute an hour ago and nothing happened.

Iam using intersystems web IDE.

Thanks for help!

Discussion (6)1

Log in or sign up to continue

Robert Cemper · Feb 26, 2018

You look for INSERT from Query
doc is here http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=RSQL_insert#RSQL_insertselect

As far as I see it should work the way you have written
(assuming data types between target and source match)

To estimate runtime you may try the select count(*) from VwSrcTable first to get a feeling
how many records that will be.

Then during load running Select count(*) from DestTable from a 2nd session may let you see your progress.

1 0

score 0 · Answer 1 · 2018-02-26T15:39:30-05:00

Robert Cemper · Feb 26, 2018

pls. post your query in detail.
it's not obvious what you try to do.

0 0

score 0 · Answer 2 · 2018-02-26T15:56:24-05:00

INSERT INTO DestTable(CPF,Cargo,CodigoUnidade,LotacaoCidade,LotacaoUF,
Matricula,Nome,NomeProduto,NumeroApolice,NumeroParcela,NumeroTitulo,Produto,ValorBruto)
SELECT CPF,Cargo,CodigoUnidade,LotacaoCidade,LotacaoUF,
Matricula,Nome,NomeProduto,NumeroApolice,NumeroParcela,NumeroTitulo,Produto,ValorBruto
FROM VwSrcTable

score 0 · Answer 3 · 2018-02-27T05:57:24-05:00

Eduard Lebedyuk · Feb 27, 2018

Modify second query to return 1 row:

SELECT TOP 1 ....

Check if inserting 1 row works.

0 0

score 0 · Answer 4 · 2018-02-27T06:06:06-05:00

I guess he means Management Portal. And I wonder if a long-running SQL operation initiated from there might be adversely affected by a CSP Web Gateway timeout.

score 0 · Answer 5 · 2018-02-27T02:28:34-05:00

Evgeny Shvarov · Feb 27, 2018

Hi, Rafael!

I wonder, what is InterSystems web IDE?

0 0