Re: [U2] I've run out of quotes
I haven't seen this one, so I thought I'd throw it in: * use ~ within the VAR instead of \ to code everything inline VAR = \mysql --user username -e LOAD DATA infile '/mnt/mount/FILE.TXT' REPLACE INTO TABLE database.updates FIELDS TERMINATED BY ',' LINES TERMINATED BY '~n' (Emailaddress, Reference) SET UpdateType = 'D', DateAdded = current_timestamp(); LOAD DATA infile '/mnt/mount/FILE.TXT' REPLACE INTO TABLE database.updates FIELDS TERMINATED BY ',' LINES TERMINATED BY '~n' (Emailaddress, Reference) SET UpdateType = 'A', DateAdded = current_timestamp(); database\ * convert so ~n becomes \n CONVERT ~ TO \ IN VAR * we'll wrap the command in double quotes when executing SH -c, * so we need to double them within VAR EQU DQ TO '' VAR = CHANGE(VAR, DQ, DQ:DQ) * now execute the shell command wrapped in double quotes EXECUTE SH -c :DQUOTE(VAR) *NOTE* in testing it seems \n in the VAR string may be changed by SH -c into n, so look out for that behavior on your system. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Division Issues
Hello, I ran into an issue when dividing 2 numbers. I debugged through the first program and here is the result... TEST1: 27: IF LOAD.VALUE THEN :: S TEST1: 28: ANS = TOP.VALUE/BOTTOM.VALUE ::S ::TOP.VALUE/ NUMBER: 0.3 :: BOTTOM.VALUE/ NUMBER: 0.006554707 :: ANS/ NUMBER: 61.02484472 I created a little test program to divide the same 2 numbers and I came up with this... TEST.DIV: 3: NUM1 = 0.3 :: S TEST.DIV: 4: NUM2 = 0.006554707 :: S TEST.DIV: 5: PRINT NUM1/NUM2 :: S 61.024848098 As you can see 61.024848098 does not equal 61.02484472? I have messed around with the PRESICION statement and I still have not gotten this to work? Can someone advise? Thanks!!! 'We act as though comfort and luxury were the chief requirements of life, when all that we need to make us happy is something to be enthusiastic about.' ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Division Issues
Is it possible the value you're seeing in the debugger is from a prior loop iteration? I would try stepping through 1 or 2 more lines and rechecking the value of ANS. It's been my experience that the current line of source code reported by the debugger and the current line of object code being executed can sometimes be slightly off. You might also try ANS = SDIV(TOP.VALUE, BOTTOM.VALUE, 9) to see if you get a different result. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Shawn Hayes Sent: Friday, June 18, 2010 1:26 PM To: u2-users@listserver.u2ug.org Subject: [U2] Division Issues Hello, I ran into an issue when dividing 2 numbers. I debugged through the first program and here is the result... TEST1: 27: IF LOAD.VALUE THEN :: S TEST1: 28: ANS = TOP.VALUE/BOTTOM.VALUE ::S ::TOP.VALUE/ NUMBER: 0.3 :: BOTTOM.VALUE/ NUMBER: 0.006554707 :: ANS/ NUMBER: 61.02484472 I created a little test program to divide the same 2 numbers and I came up with this... TEST.DIV: 3: NUM1 = 0.3 :: S TEST.DIV: 4: NUM2 = 0.006554707 :: S TEST.DIV: 5: PRINT NUM1/NUM2 :: S 61.024848098 As you can see 61.024848098 does not equal 61.02484472? I have messed around with the PRESICION statement and I still have not gotten this to work? Can someone advise? Thanks!!! 'We act as though comfort and luxury were the chief requirements of life, when all that we need to make us happy is something to be enthusiastic about.' ___ 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
[U2] UV Windows SSH without telnet service
We have a user running on a Windows UniVerse server who has a security requirement which forbids running any telnet services. They want to use ssh to connect and have installed bitvise winsshd. It allows us to kick of a uvsh.exe upon authentication. We are able to login to our software or the uv account fine. But, once we are in, we are having serious terminal emulation problems. I haven't found a term type which will work. vt100, console, ansi, etc all display incorrectly (CRLF looks like LF). Commands such as PTERM CRMODE do not work, etc. Has anyone out there connected to a UniVerse windows server without the telnet service via ssh? Steve McConnell Columbia Ultimate ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV Windows SSH without telnet service
I've never run an sshd service on Windows, but we do it all the time on Linux. We usually shut telnet down completely. Terminal emulation should be identical between telnet and ssh. What terminal emulator / ssh client are you using? Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve McConnell Sent: Friday, June 18, 2010 4:45 PM To: U2 Users List Subject: [U2] UV Windows SSH without telnet service We have a user running on a Windows UniVerse server who has a security requirement which forbids running any telnet services. They want to use ssh to connect and have installed bitvise winsshd. It allows us to kick of a uvsh.exe upon authentication. We are able to login to our software or the uv account fine. But, once we are in, we are having serious terminal emulation problems. I haven't found a term type which will work. vt100, console, ansi, etc all display incorrectly (CRLF looks like LF). Commands such as PTERM CRMODE do not work, etc. Has anyone out there connected to a UniVerse windows server without the telnet service via ssh? Steve McConnell Columbia Ultimate ___ 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] UV Windows SSH without telnet service
The most recent issue of Spectrum magazine detailed a process which I will summarize here: 1. Use PuTTY to establish an SSH session from Windows client to Windows server. 2. In Putty, open a local port forward, so that a particular socket on the client is forwarded to the server. 3. Run your favorite telnet client, in telnet mode, to connect to localhost and the socket (port) referenced in item 2 above. The telnet client connects to the local port, which forwards it (within the secure SSH connection) to the server. The SSH daemon on the server forwards the connection to the telnet port (usually 23) on the server, wher UV receives it. As far as UV is concerned, it is running telnet. However, all external traffic is authenticated and encrypted. On Fri, 18 Jun 2010, Steve McConnell wrote: We have a user running on a Windows UniVerse server who has a security requirement which forbids running any telnet services. They want to use ssh to connect and have installed bitvise winsshd. It allows us to kick of a uvsh.exe upon authentication. We are able to login to our software or the uv account fine. But, once we are in, we are having serious terminal emulation problems. I haven't found a term type which will work. vt100, console, ansi, etc all display incorrectly (CRLF looks like LF). Commands such as PTERM CRMODE do not work, etc. Has anyone out there connected to a UniVerse windows server without the telnet service via ssh? Steve McConnell Columbia Ultimate ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Regards, Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: r...@anzio.com company e-mail: r...@anzio.com voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com street address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 USA ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV Windows SSH without telnet service
AccuTerm is SSH enabled. You can use it to connect to the WinSSHD server then forward that, via telnet, to the UV server. HTH, Bill Steve McConnell said the following on 6/18/2010 4:45 PM: We have a user running on a Windows UniVerse server who has a security requirement which forbids running any telnet services. They want to use ssh to connect and have installed bitvise winsshd. It allows us to kick of a uvsh.exe upon authentication. We are able to login to our software or the uv account fine. But, once we are in, we are having serious terminal emulation problems. I haven't found a term type which will work. vt100, console, ansi, etc all display incorrectly (CRLF looks like LF). Commands such as PTERM CRMODE do not work, etc. Has anyone out there connected to a UniVerse windows server without the telnet service via ssh? Steve McConnell Columbia Ultimate ___ 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