RE: [U2] [UV] HP, Cron, Como, Execute, Capturing . Not
Have you changed the code yet to avoid problem? You haven't mentioned version of UV -- if not current, check later GTARs to see if issue identified/resolved. Get the customer going with a redirection/read ... obviously (?) new code, but an ls -l /tmp/unique_filename will work across ANY *nix platform -- assume cron is running as same user/permissions as when you fire from TCL Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Tony G Sent: Tuesday, 24 February 2009 8:45 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] HP, Cron, Como, Execute, Capturing . Not Thanks for responses so far. Scott - this code is also doing 'ls', and the output gets captured in COMO as you have seen, but it doesn't continue into the Capturing var. At least we can confirm COMO is supposed to see the output (for better or worse) but not at the expense of BASIC not seeing it. I'm wondering if this is an OS-specific issue where UV/HP is capturing in COMO but not in Capturing, or maybe this is only occurring when run through Cron. They could be doing something like this too: echo PHANTOM RUNREPORT | uv ...with the phantom being the platform-specific culprit. I'll get the details and report back, then maybe someone with the same platform here can check this before we file a bug report. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Email now working properly Don't forget Pickwiki.com! From: Scott Ballinger I do this all the time on UV 10.1.4 on RH AS 3. I have not seen a conflict with COMO and EXECUTE CAPTURING, except that the COMO records the results of the execute as well as the CAPTURING variable. E.g. EXECUTE SH -c 'ls' CAPTURING DIR.LIST Not only does DIR.LIST contain all the files in the directory, but the COMO records them as well, making for very verbose COMO files! Note that I have not tried the combination of cron + COMO + EXECUTE CAPTURING {+ PHANTOM?} so perhaps there is something going on there, but I do use cron + EXECUTE CAPTURING in many places without problems. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] HP, Cron, Como, Execute, Capturing . Not
If it's just to get the file names and not the other information like the group owners, permission bits why not simply do a pointer to the directory then select the directory ? EI: IF @USERNO 0 THEN TMP.NAME = (65536 + @USERNO):.TMPTR END ELSE TMP.NAME = @USERNO:.TMPTR OPEN , VOC TO VOC ELSE STOP 201, VOC TMPTR = F]/tmp/]D_PH CONVERT ] TO @AM IN TMPTR WRITE TMPTR ON VOC, TMPNAME OPEN , TMPNAME TO F.TMPTR ELSE STOP 201, TMPNAME FILELIST = ' SELECT F.TMPTR LOOP WHILE READNEXT FILENAME FILELIST-1 = FILENAME REPEAT You can get a lot of the other information on a file with the STAT command and the FILEINFO function. - Original Message From: Ross Ferris ro...@stamina.com.au To: u2-users@listserver.u2ug.org Sent: Tuesday, February 24, 2009 7:04:16 AM Subject: RE: [U2] [UV] HP, Cron, Como, Execute, Capturing . Not Have you changed the code yet to avoid problem? You haven't mentioned version of UV -- if not current, check later GTARs to see if issue identified/resolved. Get the customer going with a redirection/read ... obviously (?) new code, but an ls -l /tmp/unique_filename will work across ANY *nix platform -- assume cron is running as same user/permissions as when you fire from TCL Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Tony G Sent: Tuesday, 24 February 2009 8:45 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] HP, Cron, Como, Execute, Capturing . Not Thanks for responses so far. Scott - this code is also doing 'ls', and the output gets captured in COMO as you have seen, but it doesn't continue into the Capturing var. At least we can confirm COMO is supposed to see the output (for better or worse) but not at the expense of BASIC not seeing it. I'm wondering if this is an OS-specific issue where UV/HP is capturing in COMO but not in Capturing, or maybe this is only occurring when run through Cron. They could be doing something like this too: echo PHANTOM RUNREPORT | uv ...with the phantom being the platform-specific culprit. I'll get the details and report back, then maybe someone with the same platform here can check this before we file a bug report. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Email now working properly Don't forget Pickwiki.com! From: Scott Ballinger I do this all the time on UV 10.1.4 on RH AS 3. I have not seen a conflict with COMO and EXECUTE CAPTURING, except that the COMO records the results of the execute as well as the CAPTURING variable. E.g. EXECUTE SH -c 'ls' CAPTURING DIR.LIST Not only does DIR.LIST contain all the files in the directory, but the COMO records them as well, making for very verbose COMO files! Note that I have not tried the combination of cron + COMO + EXECUTE CAPTURING {+ PHANTOM?} so perhaps there is something going on there, but I do use cron + EXECUTE CAPTURING in many places without problems. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] HP, Cron, Como, Execute, Capturing . Not
Jacques - that's great info but the situation is more involved. Thanks anyway. Ross - I'm fairly confident this is one of those issues that never comes up in QA, only in the field. The cron line executes a script, the script executes: uv PNAME /outfile That's a Paragraph that looks like this: 001 PA 002 COMO ON FOO 003 RUN BP PROG 004 COMO OFF So it's a prog wrapped in COMO, in a paragraph, with stdout redirected, executed from uv, within a script, called from cron. (Sometimes I'm amazed any of this works.) I've asked the client to remove COMO for now, then if the problem persists to avoid redirection from the uv command. When the exact behaviour is determined, I've recommended that an issue report be filed with IBM through the client's DBMS provider. I've already suggested that if required, we can redirect the PROG OS queries back into OS files and then read from there, rather than attempting to Capture the output directly. However, the code doing this is our product activation subroutine (documented in my blog, search for activate key protect). For many reasons that code should not be writing anything to the host OS. I'll post a follow-up when we get something solid. Thanks again! T From: Ross Ferris Have you changed the code yet to avoid problem? You haven't mentioned version of UV -- if not current, check later GTARs to see if issue identified/resolved. Get the customer going with a redirection/read ... obviously (?) new code, but an ls -l /tmp/unique_filename will work across ANY *nix platform -- assume cron is running as same user/permissions as when you fire from TCL --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] HP, Cron, Como, Execute, Capturing . Not
Tony - It just occurred to me that cron is running uv as root and that when root starts uv, the LOGIN proc does not run except in the uv account. Try changing the user in cron to a normal uv user and I bet your problem will go away. Ken At 09:54 AM 2/24/2009, you wrote: Jacques - that's great info but the situation is more involved. Thanks anyway. Ross - I'm fairly confident this is one of those issues that never comes up in QA, only in the field. The cron line executes a script, the script executes: uv PNAME /outfile That's a Paragraph that looks like this: 001 PA 002 COMO ON FOO 003 RUN BP PROG 004 COMO OFF So it's a prog wrapped in COMO, in a paragraph, with stdout redirected, executed from uv, within a script, called from cron. (Sometimes I'm amazed any of this works.) I've asked the client to remove COMO for now, then if the problem persists to avoid redirection from the uv command. When the exact behaviour is determined, I've recommended that an issue report be filed with IBM through the client's DBMS provider. I've already suggested that if required, we can redirect the PROG OS queries back into OS files and then read from there, rather than attempting to Capture the output directly. However, the code doing this is our product activation subroutine (documented in my blog, search for activate key protect). For many reasons that code should not be writing anything to the host OS. I'll post a follow-up when we get something solid. Thanks again! T From: Ross Ferris Have you changed the code yet to avoid problem? You haven't mentioned version of UV -- if not current, check later GTARs to see if issue identified/resolved. Get the customer going with a redirection/read ... obviously (?) new code, but an ls -l /tmp/unique_filename will work across ANY *nix platform -- assume cron is running as same user/permissions as when you fire from TCL --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Script to Install a Printer on AIX that is Run from a BASIC Program
We would like to know if it is possible to write a script, that will run from a UniData BASIC program, which will install a printer in AIX given parameters passed to it from the BASIC program. Do you think it is possible to write such a script? Know anyone who has written such a script or who might know how to write such a script? tia, Dave Taylor Sysmark Information Systems, Inc. Authorized IBM Business Partner 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Announcing IBM UniVerse 10.3 [AD]
Announcing the Release of IBM UniVerse 10.3 In todaybs demanding IT environment, a conventional database isnbt always enough. Developers need a high-performance, highly scalable, easy-to-use database offering rapid deployment and a rapid return on investment. Accordingly, the U2 team is delighted to announce the latest release of IBM UniVerse, an extended relational database designed for embedding into vertical solutions for the small-to-medium business market. UniVerse delivers the unique combination of an intuitive development environment and a powerful, reliable engine underneath. Contact your U2 Representative today to learn more about how you can deliver valuable, cost-effective data management, or email us at u2as...@us.ibm.com. Read the full product announcement at: http://www-01.ibm.com/software/data/u2/universe/universe10-3.html Posted for Martha Schraer, U2 Marketing Manager --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Script to Install a Printer on AIX that is Run from a BASIC Program
Larry, Thank you very much! This will be very helpful, Dave Taylor Sysmark Information Systems, Inc. Authorized IBM Business Partner 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.com - Original Message - From: Larry Hiscock lar...@wcs-corp.com To: u2-users@listserver.u2ug.org Sent: Tuesday, February 24, 2009 12:17 PM Subject: RE: [U2] Script to Install a Printer on AIX that is Run from a BASIC Program If you run smit on the AIX box, and go thru the steps of defining the printer, but at the end instead of executing the command, use the 'display command' option it will give you the entire command-line syntax to define the printer. Then you can use that as a template for building the command, and PCPERFORM it from your BASIC program. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Dave Taylor Sent: Tuesday, February 24, 2009 11:17 AM To: u2-users@listserver.u2ug.org Subject: [U2] Script to Install a Printer on AIX that is Run from a BASIC Program We would like to know if it is possible to write a script, that will run from a UniData BASIC program, which will install a printer in AIX given parameters passed to it from the BASIC program. Do you think it is possible to write such a script? Know anyone who has written such a script or who might know how to write such a script? tia, Dave Taylor Sysmark Information Systems, Inc. Authorized IBM Business Partner 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/