SV: SQL timestamp not working when upgraded to 4.2.2 for summary tabl e

Patch 4.2.2.10 has just been released ! Regards, Henrik Hansen EuroTrust NetVaulting A/S -Oprindelig meddelelse- Fra: L'Huillier, Denis [mailto:[EMAIL PROTECTED]] Sendt: 15. august 2002 15:39 Til: [EMAIL PROTECTED] Emne: SQL timestamp not working when upgraded to 4.2.2 for summary tabl

Re: SQL timestamp not working when upgraded to 4.2.2 for summary tabl e

Hi Denis, Just for information : I tested your query on my system (4.2.2.15) and it worked like a charm (except I had to modify Node Name to Node_Name) Did you apply the latest PTF's to get 4.2.2.15 ? Maybe it could help ... Good luck anyway !

Re: SQL timestamp not working when upgraded to 4.2.2 for summary tabl e

Hey look what I found... * $$4225 Interim fixes delivered by patch 4.2.2.5 $$Patches are cumulative, just like PTFs. So Interim fixes $$delivered as 4.2.2.5 include those delivered in previous patches

SQL timestamp not working when upgraded to 4.2.2 for summary tabl e

Hello - Since I upgraded our 4.1 server to 4.2.2 my sql query against the summary table no longer works. Has anyone run into this problem before? Here's the query... /* --- Query Summary Table */ /* --- Run as a macro - */ select cast(entity as varchar(12)) as Node Name, \

Re: SQL timestamp not working when upgraded to 4.2.2 for summary tabl e

Yep... this issue had a lllooonnnggg discussion thread back when it first occurred -- search on the APAR number for the gory details, and there are caveats about which 5.1.? level has the fix (last I saw it was 5.1.1.5, I think)... it's in the APAR. Don France Technical Architect -- Tivoli