What does this mean

[zrazzaq]

Hi all I am new to db2 sql
Basically need to know what does
substr(digits(field),1,9) || field || mean....thanks
Zishan

 

[gregsimpson]

It's as regards the processing it will do on your "field" when it retrieves it.

There's an explanation of digits here

http://www.idugdb2-l.org/adminscripts/wa.exe?A2=ind0111a&L=db2-l&T=0&F=&S=&P=22044

The substr is saying use from characters 1 to 9.

So effectively on retrieval your field goes though a digits routine, and of the results from this, characters 1 through 9 are then returned through the use of the substr function.

Cheers
Greg

 

[MarcLodge]

zrazzaq,
This piece of code looks at a numeric column, turns it into a character column (that's the DIGITS bit), and then outputs from position 1 for 9 characters (the SUBSTR 1,9 bit).

Hope this helps.

Marc

 

[PruSQLer]

Marc,

Your link sent me to the Web Traffic Analysis Module of the Web CEO site.

 

[MarcLodge]

Pru,

What link?

If there is a link, I think it's one the tek-tips have added for advertising means.

Marc

 

[PruSQLer]

Ah yes, I got snookered by the old advertising highlight!