Hello all,
I have a table and need to update the FINAL_FFE column based on the following.
FINAL_FFE is FFE divided by count of ASSIGN_ID's in the table.
ID ASSIGN_ID FFE FINAL_FFE
1 ABC123 1.0
1 ABC456 0.5
2 ABC789 0.5
3 ABC123 1.0
3 ABC456 0.5
3 ABC789 0.5
4 ABC123 1.0
After the update statement the table is expected to have the...
ibmdb2user
Last Activity: Apr 8 '09, 09:09 PM
Joined: Aug 15 '06
Location:
-
Estimating size of a table with LOB column
Hi all,
The table in question has 4 fields:
UNID 19 chars
DATA 2147483647 (BLOB)
ROW 19 chars
DT 10 chars
Second column can take upto 2GB (attachments etc). So I am trying to figure out the growth of these attachments in the database in terms of space.
But the actual value in this column in not the attachment itself but a pointer/descriptor to this attachment stored somewhere...
No activity results to display