Potentially simple approach is to have separate server or virtual machine for your other UDT environment setup with the desired timezone. No code changes. On AIX, you can setup a WPAR for stuff like this pretty easily.
Or change you source code... The best solution depends on if you control the source code for the application and how it currently extracts and utilises the time information. By implication, you will also need to separately maintain the date information as well in your application. Especially, if it cross the multiple timezones or the international dateline... One approach is to ask the user to specify the timezone they wish or simply force it when they get into the respective account. Then you merely store a time offset (to your servers real time zone) in a separate field in addition to the time / date fields in your respective files (perhaps using a file based trigger if you don't want to change the code). Then just update date & time display routines (a good time to make sure you have a single routine) to check if there is an offset and apply prior to displaying. -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Frailey Sent: Thursday, 24 January 2013 4:45 AM To: U2 Users List Subject: [U2] Database time question Running unidata on hpux11.11i I have two databases in unidata that I would like to operate at different time zones. Lets say my Midvale database is set to mountain standard, USA which is also the base unix kernal time. I have an account called Austrailia, I would like it to run on australian time. Any ideas on making a unidata database independant of the unix kernal time. Thank You Robert Frailey Manager Information Systems Utah Medical Products Inc. Femcare-Nikomed Ltd. rfrai...@utahmed.com 801-569-4016 _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ************** IMPORTANT MESSAGE ***************************** This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ************************************************************** _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users