Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Char to decimal
Hi Pekka, it's a little long winded, but you could try the following (assuming in this case your value is in a field called CHAR_10): SELECT DEC(STRIP(TRANSLATE(SUBSTR(CHAR_10,1,2),' ','.'),B) || STRIP(TRANSLATE(SUBSTR(CHAR_10,3,2),' ','.'),B) ||... -
Current Date
Hi Kacy, you need something like this: SELECT CURRENT DATE FROM SYSIBM.SYSDUMMY1; You may also find this useful... SELECT CURRENT DATE - (DAY (CURRENT DATE)) DAYS gives you the last day of the previous month. The first day of this month is CURRENT DATE - (DAY(CURRENT DATE) - 1) DAYS... -
How do I determine a table from a tablespace page?
I have a job that occasionally fails due to an unavailable resource type 302 (tablespace page). The tablespace in question contains 49 tables. So the question is - how can I find the table given the tablespace page ID? e.g DFPREC13.FSAPP013.X'000192' Many thanks Zeat
