Re: [U2] Open Excel and Import a file or execute a command from a localPC
Ralph, I am not familiar with a utility that will send a file to windows, but, Accuterm will do this for you. Lee >>> [EMAIL PROTECTED] 07/27/05 04:06PM >>> Are there any utilities to pass as comma delimited file from Unidata/Universe and have it open/imported into Excel? Any way to execute a command from a local PC workstation? Thanks, Ralph - Start your day with Yahoo! - make it your home page --- 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] making 00001 our of 1
Try X=1 Y=LEN(X) Z=STR(0,4-Y):X HTH >>> [EMAIL PROTECTED] 03/02/05 01:30PM >>> Hi all, I have a need to search through our program files for any code that format a number from 1 through 9 with leading 0's. I have always used "R%5" but I may miss programs that use other techniques to arrive at the same result. Can someone give me examples that they have seen for changing 1 to 1? Thanks much, Scott --- 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] Run phantom as another user
If you are on a unix box you should be able to run a cron daemon. Lee >>> [EMAIL PROTECTED] 01/25/05 10:09AM >>> I think I have this problem as well. I have a SQL command which works when I run it, but when my RedBack phantom run's it it fails with : Error text is [Ardent][SQL Client][ODBC][Microsoft][ODBC Driver Manager] Co nnection not open Anyone know how to run a Unidata subroutine as someone else? I cannot find the article in u2ug. Thanks Graham Graham Forbes Trading Systems BT Consulting & Systems Integration -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baakkonen, Rodney Sent: 25 January 2005 15:47 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [UV] Run phantom as another user I am looking at this AUTHORIZE statement in Unidata. I am not able to compile a program using it and cannot find anything in the manuals about it. Is this a Universe sql only extension to Basic? -Original Message- From: David Jordan [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 10:33 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Run phantom as another user In a BASIC program you can use the AUTHORIZE statement to set a different security credential. (See the U2UG newsletter on the U2UG web site for the article of security) You set the statement to AUTHORIZE username Then compile the program as that user. Anyone running that program will run under that usernames credentials. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Buss, Troy (Logitek Systems) Sent: Tuesday, 25 January 2005 1:20 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Run phantom as another user Is there a way to run a phantom process as another user using the PHANTOM command? --- 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/ This email may contain information which is privileged or confidential. If you are not the intended recipient of this email, please notify the sender immediately and delete it without reading, copying, storing, forwarding or disclosing its contents to any other person Thank you Check us out at http://www.bt.com/consulting --- 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] Capturing screen output in Unidata Enviornment
Good Morning Frank, The simple answer is to use your terminal emulator. For a more complex Paragraph use the COMO verb. HTH. Lee >>> [EMAIL PROTECTED] 12/13/04 07:53AM >>> Good Morning All: I would like your help. I want to capture the screen output from a VOC Paragraph. But I want to know if there is a command line command that would allow me to do this? I do not want to edit the paragraph. Thanks in advance! Frank [EMAIL PROTECTED] ___ Frank M. Bright [EMAIL PROTECTED] Administrative Computing University of the Arts (A15) http://www.uarts.edu 320 S. Broad St. 215-717-6081(w) Philadelphia, PA 19102 215-717-6087(f) Colleague 17.0.14 AIX 5.2.0.2 Unidata 6.03 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UD] - Transaction Processing
I USE UNIDATA ON AIX, THE FOLLOWING TWO LINES DO THE JOB. PERFORM '!who am i' CAPTURING LOCATION ADDRESS=OCONV(OCONV(LOCATION, 'G1(1'),'G0)1') HTH >>> [EMAIL PROTECTED] 11/23/04 10:18AM >>> On Solaris I user a 'who -u | grep user (@LOGNAME)'. I capture the output and TRIM() it. Then I do a field on '(', to get the IP. Here is a sample output from Sun: who -u | grep lmgold lmgold pts/601 Nov 23 12:19 0:54 22331 (142.41.170.185) lmgold pts/615 Nov 23 12:20 0:50 22385 (142.41.170.185) And here is some sample Unibasic code: who.command ='who | grep ': @LOGNAME: ' | grep ': @TTY 022: PCPERFORM who.command CAPTURING who.output 023: ip.part = FIELD(who.output, '(', 2) 024: ip.address = FIELD(ip.part, ')', 1) -Original Message- From: Chauhan, Savita [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 23, 2004 11:23 AM To: [EMAIL PROTECTED] Subject: [U2][UD] - Transaction Processing Hi, This question is probably for someone who is a UniData administrator and system administrator with a little knowledge of Networking. We have a Requisitions file with on the fields as who authorized person a particular requisition. This field is in an association because several people have to authorize a requisition. I want to know from which machine (the IP address) a particular person authorized a requisition in Nov 2003. Assuming that we use static IP addressing. Can someone please direct me on how to do this? Is there a way I can see the transactions performed by UniData? Thanks in advance. Savita. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/