MVSFORUMS.com

satishsv · Posted: Mon Mar 29, 2004 11:28 pm Post 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 variable.

Is this possible? If so, how?

Thanking you in advance.

Satish

satishsv · Posted: Tue Mar 30, 2004 12:53 am Post subject:

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 here.

I have a small doubt here i.e., will this query work if I have more than 5 or 10 spaces after the first name.

Thanks & Regards,
Satish

satishsv · Posted: Tue Mar 30, 2004 1:27 am Post subject:

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

vini · Posted: Tue Mar 30, 2004 10:36 am Post subject:

Ravi said:

vini · Posted: Tue Mar 30, 2004 12:08 pm Post subject:

When computing Table columns its a fast and efficient way to use SQL Column Functions in the Select itself as opposed to doing the same thing via the Program logic. The only exception to this is when a corresponding function does not exist for what you need , in the SQL.