I'm creating a rather complicated view... or at least trying to do
so...
We have a table like this:
Key 123
Key1 123
Key2 456
Key3 789
data1 A
data2 B
data3 C
that we wold like to view as such: (rotated view from above)
Key data
123 A
465 B
789 C
further if the data looks like
Key 123_Z
Key1 123
Key2 456
Key3 789
data1 A
data2 B
data3 C
we want to see:
Key data
123_Z A
465_Z B
789_Z C
our data is actually keys1-6 and spans several tables...
I've created a view of the data of a union of selects.. but am getting
an error:
E_PS0F02 There is no more available memory. Try again later.
(Wed Jun 18 13:42:32 2003)
E_SC022A Insufficient system/server resources to complete the current
query. Consult the system administrator and/or error log.
(Wed Jun 18 13:42:32 2003)
and in errlog.log:
TMC3_AST::[54713 , 20ac8f80]: Wed Jun 18 13:42:32 2003 E_PS0F02_MEMORY_FULL There is no more available memory. Try again later.
(tmc3 is our server)
****************
The resulting view would have around 3000 rows... so it's not that big really.
anything i can tweak to get this view to work?
I've tried "set nojournaling" in the terminal monitor.
i might try rebooting the machine off hours and going from a fresh
startup with the minimum number of other processes running on the
machine...
perhaps i'm expecting too much from the view?
any ideas/advice?
--
be safe.
flip
^___^ Count to three. Make a wish. Close your eyes.
\^.^/ Wait. Scratch that, reverse it.
==u== - apologies to Roald Dahl