I'm working on the same task as I prepare for a 5.5 to 6.3 upgrade.  Here's a
good starting point for updating select statements for TSM 6:


https://pic.dhe.ibm.com/infocenter/tsminfo/v6r3/index.jsp?topic=%2Fcom.ibm.itsm.srv.upgrd.doc%2Fr_srv_upgrd_cmd_select.html

There's also an IBM tech note about it, but I don't have the link handy.

=Dave


On 11/20/2013 10:13 AM, Ben Bullock wrote:

I recently upgraded the server from 5.5 to 6.3.4 and am also working at
changing out the failing scripts. Having to add a lot of cast statements
to get the column formatting to be nicely formatted. The date arithmetic
is also the one that has me the most  stymied.

I have used the, "cast((current_timestamp-lastacc_time)days as decimal)" 
statement, but I also haven't found a workaround.

Any enlightenment would be appreciated here also. ;-)

Thanks,
Ben

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Loon, EJ van - SPLXM
Sent: Wednesday, November 20, 2013 8:40 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] SQL query in v6 server

Hi TSM-ers!

We just migrated a second server to v6 and now I need to 'patch' TSM
Operational Reporter. Among others, the following SQL statement no longer
works:


select node_name, platform_name, date(lastacc_time) from nodes where 
cast((current_timestamp-lastacc_time)days as decimal) >=2 and contact like 
'Component Team Linux%%'


It must have something to do with the cast part, because when I leave that
out it works fine.

I have a hard time finding the correct information about rewriting your
SQL queries, so if somebody could help me out, I'll appreciate it!

Kind regards,

Eric van Loon

AF/KLM Storage Engineering

--
Hello World.                                David Bronder - Systems Architect
Segmentation Fault                                      ITS-EI, Univ. of Iowa
Core dumped, disk trashed, quota filled, soda warm.   david-bronder AT uiowa 
DOT edu