Re: [U2] Very Weird Trigger Behavior
Hi, Kevin. Shaun wasn't reporting a problem. He was answering my questions about his trigger that does what I'm trying to do. Kevin King-2 wrote: Shaun, have you checked the trigger code on that file? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- View this message in context: http://old.nabble.com/Very-Weird-Trigger-Behavior-tp31450305p31471367.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Very Weird Trigger Behavior
Thanks for the info, Shaun. Shaun.Ferguson wrote: HP Itanium UniData Release 7.1 Basictype p Records cannot be deleted from TCL (ECL?) even with a select list active: 1 records selected to list 0. DELETE COUNTY Do you want to delete records in select list?(Y/N) Y 'KEY':cannot be deleted, due to trigger constraint. --- Wow! This is really similar to what I'm trying to do. What is your: OS, Unidata version, BASICTYPE? Also, are you having success with both ECL DELETEs and UniBasic DELETEs? Thanks! Jonathan Shaun.Ferguson wrote: We are doing this with a county and zip file - the trigger is on the county file and a record cannot be deleted if it's referenced in the zip file: SUBROUTINE TRIG.COUNTY.DEL (EXECSTAT, DICTFLAG, FILENAME, COUNTY_ID) EQU DELETE_DENIED TO 0 EQU DELETE_ALLOWED TO 1 EXECSTAT = DELETE_DENIED IF (UNASSIGNED(FILENAME) OR (FILENAME NE COUNTY)) THEN RETURN END IF (UNASSIGNED(COUNTY_ID) OR (TRIM(COUNTY_ID) EQ )) THEN RETURN END CMD = 'SELECT P_ZIP WITH COUNTY_ID EQ ':COUNTY_ID:'' ZIP_LIST = EXECUTE CMD RTNLIST ZIP_LIST CAPTURING OUTPUT IF @SYSTEM.RETURN.CODE EQ 0 THEN EXECSTAT = DELETE_ALLOWED END RETURN Shaun Ferguson Applications Architect I Wolseley Group Services - 12500 Jefferson Avenue - Newport News - VA - 23602-4314 T: (757) 989-2916 - F: (757) 989-2801 - E: shaun.fergu...@wolseley.com www.wolseley.com blocked::http://www.wolseley.com/ Wolseley plc registered office Parkview 1220 Arlington Business Park Theale Nr Reading RG7 4GA United Kingdom Registration No. 29846 England Shaun Ferguson Applications Architect I Wolseley Group Services - 12500 Jefferson Avenue - Newport News - VA - 23602-4314 T: (757) 989-2916 - F: (757) 989-2801 - E: shaun.fergu...@wolseley.com www.wolseley.com blocked::http://www.wolseley.com/ Wolseley plc registered office Parkview 1220 Arlington Business Park Theale Nr Reading RG7 4GA United Kingdom Registration No. 29846 England ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- View this message in context: http://old.nabble.com/Very-Weird-Trigger-Behavior-tp31450305p31471381.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Saying Goodbye...
Hi Karl, Your story/post sound very similar to one that I would post. I am relatively new to this forum and have not posted much either. I too am a 25+ year veteran of Pick/Multivalue/U2 sytems and find myself unemployed. I live in Canada and in the past 6 months or so, there has been 2 Pick related job posting. So I too am trying to abandon Pick as my wife and kids need cash to survive :-). Best wishes and congrats on your new job. Elio Karl Pearson wrote: I'm not sure if most, or any, of you actually know me, but here's what amounts to my swan song. For the past 18+ years I've been a decent UV DBA. I took classes from Mark Baldridge and later Joel Yates way back when to learn how to manually repair corrupt files, and was proficient before uniVerse became so stable that corrupt files happened infrequently and fixtool worked. But during that time, I've maintained a personal email and web server, running Majordomo v1.94.5, etc. and have learned a bit about the LAMP stack in so doing. I've been a layed-off DBA, for a small retail company, for the past 22 months, consulting my previous employer because they got rid of me so they could have salary cap to hire a different type of IT manager and move off UV to Profit21, which failed after $250,000 lost. They are back on UV and will stay now. I, however, have to move on because I've received the proverbial offer one can't refuse ($5000US signing bonus and the option for 5000 shares of company stock), plus no one in the 'PICK' world has offered me anything, though there may be a few things still in the works, which will now go quietly away. I will be working in the LAMP world now, making a living doing my hobby, so to speak. (FYI: LAMP = Linux, Apache, MySQL and PHP or Perl, depending on who you listen to) I may hang around on the list for a bit, but will eventually have to unsubscribe as my life moves farther and father away from a field I have grown to respect and enjoy. Best wishes to all of you, and like others before me, I'm sure I'll miss the group association you've provided, though I'm mostly just a quiet observer. Thanks and I'll never forget this group of intelligent, insightful, thought-provoking and often entertaining, professionals. --- Karl Pearson ka...@ourldsfamily.com Owner/Administrator of the sites at http://ourldsfamily.com --- To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote. --Benjamin Franklin --- Children seldom misquote you. In fact, they usually repeat word for word what you shouldn't have said. --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- View this message in context: http://old.nabble.com/Saying-Goodbye...-tp28702652p31472264.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] html 2 xls
Anyone know of a conversion tool that will take html and produce xls (Excel spreadsheet) formatted files? We are running UniData on HPUX but could probably use a utility on a windows server if necessary. Thanks! Shaun Ferguson Applications Architect I Wolseley Group Services - 12500 Jefferson Avenue - Newport News - VA - 23602-4314 T: (757) 989-2916 - F: (757) 989-2801 - E: shaun.fergu...@wolseley.com www.wolseley.com blocked::http://www.wolseley.com/ Wolseley plc registered office Parkview 1220 Arlington Business Park Theale Nr Reading RG7 4GA United Kingdom Registration No. 29846 England ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] html 2 xls
Is the HTML just a collection of table rows and columns? (table)(tr) and (td)'s? If so, Excel should load it just fine. You might need to use the (F)ile, Open instead of just clicking on it (which would open the browser). George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of shaun.fergu...@ferguson.com Sent: Monday, April 25, 2011 3:38 PM To: u2-users@listserver.u2ug.org Subject: [U2] html 2 xls Anyone know of a conversion tool that will take html and produce xls (Excel spreadsheet) formatted files? We are running UniData on HPUX but could probably use a utility on a windows server if necessary. Thanks! Shaun Ferguson Applications Architect I Wolseley Group Services - 12500 Jefferson Avenue - Newport News - VA - 23602-4314 T: (757) 989-2916 - F: (757) 989-2801 - E: shaun.fergu...@wolseley.com www.wolseley.com blocked::http://www.wolseley.com/ Wolseley plc registered office Parkview 1220 Arlington Business Park Theale Nr Reading RG7 4GA United Kingdom Registration No. 29846 England ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] html 2 xls
I use xlwt for this kind of work. Its not perfect, but does what I need. Will need a developer to setup your html - xls transform. On Mon, Apr 25, 2011 at 3:37 PM, shaun.fergu...@ferguson.com wrote: Anyone know of a conversion tool that will take html and produce xls (Excel spreadsheet) formatted files? We are running UniData on HPUX but could probably use a utility on a windows server if necessary. Thanks! Shaun Ferguson Applications Architect I Wolseley Group Services - 12500 Jefferson Avenue - Newport News - VA - 23602-4314 T: (757) 989-2916 - F: (757) 989-2801 - E: shaun.fergu...@wolseley.com www.wolseley.com blocked::http://www.wolseley.com/ Wolseley plc registered office Parkview 1220 Arlington Business Park Theale Nr Reading RG7 4GA United Kingdom Registration No. 29846 England ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users