Re: [U2] INPUTIF statement in Universe {Unclassified}

2010-11-02 Thread David Wolverton
UniData 7.1.9 --- Using list filename field-a field-b TO DELIM | c:\Test.txt Works and generates a Pipe Delimited text file... (I have to use 'lowercase LIST' so that it does work due to ECLTYPE, but that's OK) BUT -- I need the resulting file to be tab-delimited - the 'consumer' for the file

Re: [U2] INPUTIF statement in Universe {Unclassified}

2010-11-02 Thread Jeff Schasny
Cedarville Download David Wolverton wrote: UniData 7.1.9 --- Using list filename field-a field-b TO DELIM | c:\Test.txt Works and generates a Pipe Delimited text file... (I have to use 'lowercase LIST' so that it does work due to ECLTYPE, but that's OK) BUT -- I need the resulting file to

Re: [U2] INPUTIF statement in Universe {Unclassified}

2010-11-02 Thread Charles_Shaffer
BUT -- I need the resulting file to be tab-delimited - the 'consumer' for the file is a stupid old program and cannot accept XML. It can only eat tab, or comma delimited files. And since some of the data CONTAINS commas, the TAB seems to be the better choice. How about list filename

[U2] RICOH Copiers

2010-11-02 Thread Pamela Robbins
Anyone have experience using RICOH multi-purpose copiers as printers? We've just purchased a RICOH Aficio MP6001. When someone copies something or sends a job to it from Windows, they have to enter a user validation code. We started out by setting it up just like we do the HP printers on our

Re: [U2] RICOH Copiers

2010-11-02 Thread George Gallen
I Wonder if the printer accepts PJC (printer job control), and there might be an embedded command for the validation code. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Pamela Robbins Sent: Tuesday,

[U2] UniVerse DOS Command - Batch File Error

2010-11-02 Thread Don P. Nagai
I have a batch file on a server running UniVerse. This file can be executed from Windows Explorer with no problems. If I attempt to run the same batch file using the UniVerse DOS command, the batch file will not process. The DOS command line is displayed, there is a slight delay (2 sec or

Re: [U2] UniVerse DOS Command - Batch File Error

2010-11-02 Thread Robert Houben
If your batch file is named myfile.bat, then try executing the DOS command cmd.exe /c myfile.bat. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don P. Nagai Sent: Tuesday, November 02, 2010 12:35 PM To: 'U2 Users

Re: [U2] UniVerse DOS Command - Batch File Error {Unclassified}

2010-11-02 Thread HENDERSON MIKE, MR
Don, The DOS command is pretty badly broken, particularly if you need to try to use a quoted string with embedded spaces (e.g. '... C:\Program Files\MyApp\AppName.exe ...'). After I bitched about it, a new GCI function UVRunCommand was introduced (in 10.0 IIRC). You need code like this

[U2] How to create tab-delimited LIST output

2010-11-02 Thread David Wolverton
Does that syntax work on your UniData?!? I just barfs up trying that syntax on mine. If it does work, let me know your version. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent:

Re: [U2] INPUTIF statement in Universe {Unclassified}

2010-11-02 Thread David Wolverton
WELL -- I guess I could go the 3rd Party Product route -- but come on! EVERY database product can do what I'm asking. It's not rocket science or anything! (pun unintended!) I could just write BASIC code if I wanted - I'm trying to find what I'm thinking should already be 'inside' of UniData. If

Re: [U2] INPUTIF statement in Universe {Unclassified}

2010-11-02 Thread Garry Smith
Here in the U.S.A it is election day Nov 2nd. And as such it puts me in a 'political' frame of mind. So: ASK NOT WHAT YOUR DATABASE CAN DO FOR YOU, BUT WHAT CAN YOU DO FOR YOUR DATABASE. besides dropping indexes and adding null keys. Garry L. Smith -Original Message- From:

[U2] Tab Delimitted LIST Output...

2010-11-02 Thread David Wolverton
WELL - found that this worked for me also - from REAL ECL only. And it looked hideous typing (wrapped the code around to the start.) I found that this method would NOT work from the TCL shell provided in SB+, as the tab entry caused the 'shell command line' to close up as if you were pressing

Re: [U2] INPUTIF statement in Universe {Unclassified}

2010-11-02 Thread Wally Terhune
2 line program works: STMT = 'LIST CUSTOMER NAME TO DELIM ' :CHAR(9): ' wwtestjunk' EXECUTE STMT Also - if you are using dictionary items with conversion codes and want the data in the output file to have the conversion code applied, don't forget to first run the ECL command: UDT.OPTIONS 91 ON

Re: [U2] INPUTIF statement in Universe {Unclassified}

2010-11-02 Thread Jeff Schasny
Well I'm running Universe as as far as I know TO DELIM does not exist here. DOWNLOAD is free, it works well, and you can be using it in under 30 minutes. David Wolverton wrote: WELL -- I guess I could go the 3rd Party Product route -- but come on! EVERY database product can do what I'm

Re: [U2] UniVerse DOS Command - Batch File Error - Found word(s) list error in the Text body

2010-11-02 Thread Mark Eastwood
Permissions? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don P. Nagai Sent: Tuesday, November 02, 2010 3:33 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse DOS Command - Batch File Error - Found word(s) list

Re: [U2] UniVerse DOS Command - Batch File Error

2010-11-02 Thread Bob Woodward
Something I've run into before is location of the TEMP directory. I had a C:\tmp but was pointed to C:\TEMP in the environment variables. This caused a problem with executing DOS commands from within Universe. Long time ago, though. -Original Message- From:

Re: [U2] UniVerse DOS Command - Batch File Error

2010-11-02 Thread Don P. Nagai
Thanks. I'm using a different folder name to contain the batch file so I'll try moving it back to TEMP proper and see if it makes a difference. I'll also have a look at the environment variables. -Original Message- From: u2-users-boun...@listserver.u2ug.org

Re: [U2] UniVerse DOS Command - Batch File Error

2010-11-02 Thread Don P. Nagai
Thank you. I'll give this a try right after testing to see if the Temp folder issue has an impact. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Whitehorn Sent: Tuesday, November 02, 2010 4:17 PM To: U2

Re: [U2] UniVerse DOS Command - Batch File Error unclassified

2010-11-02 Thread MACK ANDREW, MR
Like Bob, I had a similar problem on Windows 2003 (UV 10.2.10) and found it was permissions on the temp folder that was causing the problem. Check ENV at TCL to see if the temp folder for UV is different from the temp folder you use when logged into windows. By default Windows is C:\temp and UV

[U2] Using LIST to generate a delimited file.

2010-11-02 Thread David Wolverton
Yes -- this does work -- It also turns out it DOES work using the 'tab' key, but looks bad, but that it will not work from an SB+ '/TCL shell'. I'm sort of hoping the new features (which includes a 'database viewer' I hear) will make this kind of thing better for us going into SQL-land