/ Forside / Teknologi / Udvikling / SQL / Nyhedsindlæg
Login
Glemt dit kodeord?
Brugernavn

Kodeord


Reklame
Top 10 brugere
SQL
#NavnPoint
pmbruun 1704
niller 962
fehaar 730
Interkril.. 701
ellebye 510
pawel 510
rpje 405
pete 350
gibson 320
10  smorch 260
[DB2] Temp Table Probelm
Fra : Stefan Kristensen


Dato : 10-12-02 21:13

Hello Group.

I'm a total newbie regarding DB2.
My system is running on an OS/390 box, and my problem is as follows:

I'm creating a temp table and inserting some data into it with a select
statement.
Then I'm reading the table with a cursor, but there is no output.
If I instead insert a new post, open the cursor and then insert the data
with the select statement, I get the expected result.
I have tried to declare/create the temp table with and without the on commit
preserve rows clause.
What am I missing here?

c",)
Stefan





 
 
Søg
Reklame
Statistik
Spørgsmål : 177501
Tips : 31968
Nyheder : 719565
Indlæg : 6408522
Brugere : 218887

Månedens bedste
Årets bedste
Sidste års bedste