Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem with temp table

Status
Not open for further replies.
la46

la46

Programmer
Mar 15, 2004
26
MA
HI ALL,
I'm using a temp table in a fucntion to store temporary results, but when calling the same function i've a problem saing that the temporary table already exist. What can be the cause and what is the solution?
I use informix Online edition 11. in an AIX serever.

the function begins with
whenevere error continue
DROP TABLE temp_table
whenevere error continue
Any Help?
 
Status
Not open for further replies.

Similar threads

evgeniosc
  • Locked
  • Question
Copy rows as they inserted on a replica table using trigger
Replies
0
Views
295
evgeniosc
evgeniosc
KaronW
  • Locked
  • Question
Do multiple "case" lines run against each line or is each run against the table ?
Replies
0
Views
274
KaronW
KaronW
marcq
  • Locked
  • Question
Table space usage vs tables
Replies
0
Views
210
marcq
marcq
aft5425
  • Locked
  • Question
Avoid duplicates on phn_nbr while joining a table to itself
Replies
1
Views
212
PHV
PHV
aft5425
  • Locked
  • Question
Update with Join Informix 4gl SQL
Replies
4
Views
606
PHV
PHV

Part and Inventory Search

Sponsor

Back
Top