MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 6 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Altering Tablespace
satishsv

Replies: 2
Views: 1391

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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 ...
 
Page 1 of 1
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group