Author |
Message |
Topic: Altering Tablespace |
satishsv
Replies: 2
Views: 1391
|
Forum: Database Posted: Thu Jun 15, 2006 10:50 am Subject: Altering Tablespace |
Kolusu,
Your reply is really helpful to me. I shall go ahead and try the option that you have given me of updating SYSIBM.SYSTABLEPART.
Thanks,
Satish |
Topic: Altering Tablespace |
satishsv
Replies: 2
Views: 1391
|
Forum: Database Posted: Wed Jun 14, 2006 6:26 pm Subject: Altering Tablespace |
Hi,
We have a tablespace created in the following way.
CREATE TABLESPACE ABC123
IN $DBNAME$
USING STOGROUP $STRGRP$
PRIQTY 192
SECQTY 48
ERASE NO
FREE ... |
Topic: Repairing the tablespace |
satishsv
Replies: 1
Views: 1212
|
Forum: Database Posted: Thu Apr 01, 2004 9:02 am Subject: Repairing the tablespace |
Hi,
I have got this strange error. I was loading data into a table using loadjob and it had failed because of some reason. It went into UTUT state. I have corrected all the corresponding errors and ... |
Topic: Regarding Substring in DB2 |
satishsv
Replies: 7
Views: 2179
|
Forum: Database Posted: Tue Mar 30, 2004 1:27 am Subject: Regarding Substring in DB2 |
Thank you very much Ravi. I have checked up the query in the way you have given in QMF and it gives the same result as I was expecting.
Thanks & Regards,
Satish |
Topic: Regarding Substring in DB2 |
satishsv
Replies: 7
Views: 2179
|
Forum: Database Posted: Tue Mar 30, 2004 12:53 am Subject: Regarding Substring in DB2 |
Thank you very much for the timely help, Ravi.
Infact, I was breaking my head to get this one as the requirement restricts me from using host language.
Moreover, performance is not an issue over ... |
Topic: Regarding Substring in DB2 |
satishsv
Replies: 7
Views: 2179
|
Forum: Database Posted: Mon Mar 29, 2004 11:28 pm Subject: Regarding Substring in DB2 |
Hi,
I have a field called FIRST_NM in a table. It is declared as CHAR(30).
The field can contain a value as 'JOHN B'
My requirement is to get the character 'B' into a working-storage varia ... |
|