Re: [U2] INPUTIF statement in Universe {Unclassified}
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 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. Using TO DELIM ^009 will not work that I can see. And I think in this day and age, having to write a program to generate this simple of a file seems a bit over the top!! The other choice - building a dictionary called tab -- but I need to extract about 40 fields for this issue, so I was hoping to NOT have to build a 'hard coded' dictionary that was itself just a CHAR(9) so that my command line does not have 'tab' as every other word and get near the 'max length' along the way! That is, I didn't think I should have to do this: list CLIENT.MASTER field-a tab field-b tab field-c TO c:\test.txt I mean, tab delimited file. How routine is that?? Why would I have to build a 'fake dictionary' to handle that? Am I missing something? How do others deal with this issue? Or is the 'fake dictionary' the 'state of the art' methodology today?? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] INPUTIF statement in Universe {Unclassified}
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 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. Using TO DELIM ^009 will not work that I can see. And I think in this day and age, having to write a program to generate this simple of a file seems a bit over the top!! The other choice - building a dictionary called tab -- but I need to extract about 40 fields for this issue, so I was hoping to NOT have to build a 'hard coded' dictionary that was itself just a CHAR(9) so that my command line does not have 'tab' as every other word and get near the 'max length' along the way! That is, I didn't think I should have to do this: list CLIENT.MASTER field-a tab field-b tab field-c TO c:\test.txt I mean, tab delimited file. How routine is that?? Why would I have to build a 'fake dictionary' to handle that? Am I missing something? How do others deal with this issue? Or is the 'fake dictionary' the 'state of the art' methodology today?? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] INPUTIF statement in Universe {Unclassified}
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 field-a field-b TO DELIM CHAR(9) c:\Test.txt Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] RICOH Copiers
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 Windows server. We don't use drivers, the printer is set up to use TCP/IP RAW protocol and we simply send PCL commands to control the printer. We set the copier up the same way, but couldn't get a test page to print. When I talked to tech support, they said that we needed to install a PCL driver. They also said that to get around the validation code, we should set the printer device as a black and white printer. We still cannot get a test page. Any advice will be appreciated. Pamela J Robbins Sr Programmer Analyst University of Pennsylvania School of Veterinary Medicine New Bolton Center 610-925-6438 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] RICOH Copiers
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, November 02, 2010 2:48 PM To: u2-users@listserver.u2ug.org Subject: [U2] RICOH Copiers 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 Windows server. We don't use drivers, the printer is set up to use TCP/IP RAW protocol and we simply send PCL commands to control the printer. We set the copier up the same way, but couldn't get a test page to print. When I talked to tech support, they said that we needed to install a PCL driver. They also said that to get around the validation code, we should set the printer device as a black and white printer. We still cannot get a test page. Any advice will be appreciated. Pamela J Robbins Sr Programmer Analyst University of Pennsylvania School of Veterinary Medicine New Bolton Center 610-925-6438 ___ 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] UniVerse DOS Command - Batch File Error
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 so) before the EXIT command is issued and the system returns to TCL, but the batch file doesn't run. The UV User Ref is pretty vague on details for the DOS command. Any ideas on what I might be missing? TiA ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse DOS Command - Batch File Error
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 List' Subject: [U2] UniVerse DOS Command - Batch File Error 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 so) before the EXIT command is issued and the system returns to TCL, but the batch file doesn't run. The UV User Ref is pretty vague on details for the DOS command. Any ideas on what I might be missing? TiA ___ 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] UniVerse DOS Command - Batch File Error {Unclassified}
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 - DECLARE GCI UVRunCommand DOS.COMMAND.STRING = the DOS Command you want to run MY.GCI.STATUS = UVRunCommand('c:\WINDOWS\system32\cmd.exe /c ':DOS.COMMAND.STRING) IF MY.GCI.STATUS NE 0 THEN error process END -- I'm sure UVRunCommand is documented somewhere (apart from the Release Notes when it was introduced), I'm just not sure where. Nor do I understand why they just didn't fix the DOS command. Hope this helps Regards Mike -Original Message- From: u2-users-boun...@listserver.u2ug.org On Behalf Of Don P. Nagai Sent: Wednesday, 3 November 2010 08:35 To: 'U2 Users List' Subject: [U2] UniVerse DOS Command - Batch File Error 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 so) before the EXIT command is issued and the system returns to TCL, but the batch file doesn't run. The UV User Ref is pretty vague on details for the DOS command. Any ideas on what I might be missing? TiA ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] How to create tab-delimited LIST output
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: Tuesday, November 02, 2010 12:33 PM To: U2 Users List Subject: Re: [U2] INPUTIF statement in Universe {Unclassified} 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 field-a field-b TO DELIM CHAR(9) c:\Test.txt Charles Shaffer Senior Analyst NTN-Bower Corporation ___ 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] INPUTIF statement in Universe {Unclassified}
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 the answer is 'it is not there' then I will be forced to ask if someone from Rocket can address 'why not'?? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Tuesday, November 02, 2010 1:25 PM To: U2 Users List Subject: Re: [U2] INPUTIF statement in Universe {Unclassified} 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 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. Using TO DELIM ^009 will not work that I can see. And I think in this day and age, having to write a program to generate this simple of a file seems a bit over the top!! The other choice - building a dictionary called tab -- but I need to extract about 40 fields for this issue, so I was hoping to NOT have to build a 'hard coded' dictionary that was itself just a CHAR(9) so that my command line does not have 'tab' as every other word and get near the 'max length' along the way! That is, I didn't think I should have to do this: list CLIENT.MASTER field-a tab field-b tab field-c TO c:\test.txt I mean, tab delimited file. How routine is that?? Why would I have to build a 'fake dictionary' to handle that? Am I missing something? How do others deal with this issue? Or is the 'fake dictionary' the 'state of the art' methodology today?? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ 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] INPUTIF statement in Universe {Unclassified}
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-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Tuesday, November 02, 2010 2:24 PM To: 'U2 Users List' Subject: Re: [U2] INPUTIF statement in Universe {Unclassified} 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 the answer is 'it is not there' then I will be forced to ask if someone from Rocket can address 'why not'?? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Tuesday, November 02, 2010 1:25 PM To: U2 Users List Subject: Re: [U2] INPUTIF statement in Universe {Unclassified} 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 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. Using TO DELIM ^009 will not work that I can see. And I think in this day and age, having to write a program to generate this simple of a file seems a bit over the top!! The other choice - building a dictionary called tab -- but I need to extract about 40 fields for this issue, so I was hoping to NOT have to build a 'hard coded' dictionary that was itself just a CHAR(9) so that my command line does not have 'tab' as every other word and get near the 'max length' along the way! That is, I didn't think I should have to do this: list CLIENT.MASTER field-a tab field-b tab field-c TO c:\test.txt I mean, tab delimited file. How routine is that?? Why would I have to build a 'fake dictionary' to handle that? Am I missing something? How do others deal with this issue? Or is the 'fake dictionary' the 'state of the art' methodology today?? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ 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-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Tab Delimitted LIST Output...
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 'enter'. OK - good deal that this works. And it's intuitive except that it's not pretty, nor is it 'usable' from within SB+. So I have a work-around!! Hopefully the new 'command line' interface that is coming out Real Soon Now works more like SQL does will have the ability to handle this more 'neatly' than this as well. Thanks Larry! I should have read the oldest response first!! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: Tuesday, November 02, 2010 1:18 PM To: 'U2 Users List' Subject: Re: [U2] INPUTIF statement in Universe {Unclassified} I just tested ... TO DELIM ... (i.e. press the tab key in between the quotes) and it worked for me. UD 6.1.12 Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Tuesday, November 02, 2010 10:59 AM To: 'U2 Users List' Subject: Re: [U2] INPUTIF statement in Universe {Unclassified} 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 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. Using TO DELIM ^009 will not work that I can see. And I think in this day and age, having to write a program to generate this simple of a file seems a bit over the top!! The other choice - building a dictionary called tab -- but I need to extract about 40 fields for this issue, so I was hoping to NOT have to build a 'hard coded' dictionary that was itself just a CHAR(9) so that my command line does not have 'tab' as every other word and get near the 'max length' along the way! That is, I didn't think I should have to do this: list CLIENT.MASTER field-a tab field-b tab field-c TO c:\test.txt I mean, tab delimited file. How routine is that?? Why would I have to build a 'fake dictionary' to handle that? Am I missing something? How do others deal with this issue? Or is the 'fake dictionary' the 'state of the art' methodology today?? ___ 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-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] INPUTIF statement in Universe {Unclassified}
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 Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Tuesday, November 02, 2010 3:24 PM To: 'U2 Users List' Subject: Re: [U2] INPUTIF statement in Universe {Unclassified} 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 the answer is 'it is not there' then I will be forced to ask if someone from Rocket can address 'why not'?? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] INPUTIF statement in Universe {Unclassified}
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 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 the answer is 'it is not there' then I will be forced to ask if someone from Rocket can address 'why not'?? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Tuesday, November 02, 2010 1:25 PM To: U2 Users List Subject: Re: [U2] INPUTIF statement in Universe {Unclassified} 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 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. Using TO DELIM ^009 will not work that I can see. And I think in this day and age, having to write a program to generate this simple of a file seems a bit over the top!! The other choice - building a dictionary called tab -- but I need to extract about 40 fields for this issue, so I was hoping to NOT have to build a 'hard coded' dictionary that was itself just a CHAR(9) so that my command line does not have 'tab' as every other word and get near the 'max length' along the way! That is, I didn't think I should have to do this: list CLIENT.MASTER field-a tab field-b tab field-c TO c:\test.txt I mean, tab delimited file. How routine is that?? Why would I have to build a 'fake dictionary' to handle that? Am I missing something? How do others deal with this issue? Or is the 'fake dictionary' the 'state of the art' methodology today?? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse DOS Command - Batch File Error - Found word(s) list error in the Text body
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 error in the Text body Thank you for all the suggestions. I do appreciate them. I've tried the cmd.exe and EXECUTE STMT options and they both appear to run the batch file, but it looks as if something is preventing the app within the batch file from processing... which seems strange since the app runs if the batch file is triggered directly from Windows Explorer. The app is Print Wizard 4. I've been able to use the DOS command from UniVerse on a 2003 Server system. The failure is occurring on a W2K machine. I'll have a go at the GCI approach next. -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 List' Subject: [U2] UniVerse DOS Command - Batch File Error 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 so) before the EXIT command is issued and the system returns to TCL, but the batch file doesn't run. The UV User Ref is pretty vague on details for the DOS command. Any ideas on what I might be missing? TiA ___ 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-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse DOS Command - Batch File Error
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: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don P. Nagai Sent: Tuesday, November 02, 2010 4:05 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse DOS Command - Batch File Error Yes. I've actually moved the .bat file to the C:\ root directory and tested it there as well with the same results. The test have been: Executing .bat from Windows Explorer - Works OK. Triggering DOS and typing in the batch command manually - fails Placing the batch file in a variable and using EXECUTE to trigger it - fails This is really weird -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard Lewis Sent: Tuesday, November 02, 2010 3:57 PM To: U2 Users List Subject: Re: [U2] UniVerse DOS Command - Batch File Error Is the path set correctly, so that the application can be seen from the cmd or EXECUTEd environment? Best Regards, Richard Lewis On Tue, Nov 2, 2010 at 4:33 PM, Don P. Nagai dpna...@nei-pro-info.comwrote: Thank you for all the suggestions. I do appreciate them. I've tried the cmd.exe and EXECUTE STMT options and they both appear to run the batch file, but it looks as if something is preventing the app within the batch file from processing... which seems strange since the app runs if the batch file is triggered directly from Windows Explorer. The app is Print Wizard 4. I've been able to use the DOS command from UniVerse on a 2003 Server system. The failure is occurring on a W2K machine. I'll have a go at the GCI approach next. -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 List' Subject: [U2] UniVerse DOS Command - Batch File Error 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 so) before the EXIT command is issued and the system returns to TCL, but the batch file doesn't run. The UV User Ref is pretty vague on details for the DOS command. Any ideas on what I might be missing? TiA ___ 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-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-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse DOS Command - Batch File Error
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 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Woodward Sent: Tuesday, November 02, 2010 4:12 PM To: U2 Users List Subject: Re: [U2] UniVerse DOS Command - Batch File Error 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: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don P. Nagai Sent: Tuesday, November 02, 2010 4:05 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse DOS Command - Batch File Error Yes. I've actually moved the .bat file to the C:\ root directory and tested it there as well with the same results. The test have been: Executing .bat from Windows Explorer - Works OK. Triggering DOS and typing in the batch command manually - fails Placing the batch file in a variable and using EXECUTE to trigger it - fails This is really weird -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard Lewis Sent: Tuesday, November 02, 2010 3:57 PM To: U2 Users List Subject: Re: [U2] UniVerse DOS Command - Batch File Error Is the path set correctly, so that the application can be seen from the cmd or EXECUTEd environment? Best Regards, Richard Lewis On Tue, Nov 2, 2010 at 4:33 PM, Don P. Nagai dpna...@nei-pro-info.comwrote: Thank you for all the suggestions. I do appreciate them. I've tried the cmd.exe and EXECUTE STMT options and they both appear to run the batch file, but it looks as if something is preventing the app within the batch file from processing... which seems strange since the app runs if the batch file is triggered directly from Windows Explorer. The app is Print Wizard 4. I've been able to use the DOS command from UniVerse on a 2003 Server system. The failure is occurring on a W2K machine. I'll have a go at the GCI approach next. -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 List' Subject: [U2] UniVerse DOS Command - Batch File Error 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 so) before the EXIT command is issued and the system returns to TCL, but the batch file doesn't run. The UV User Ref is pretty vague on details for the DOS command. Any ideas on what I might be missing? TiA ___ 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-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-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] UniVerse DOS Command - Batch File Error
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 Users List Subject: Re: [U2] UniVerse DOS Command - Batch File Error Rather than double clicking to run the bat, have you tried opening a dos command prompt (Start Run cmd) and then cd'ing to the directory the batch file is in and running the bat from there, as this should keep the window open and hopefully display a message that may point to why the uv shell isn't running as expected? HTH. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Woodward Sent: Wednesday, 03 November 2010 10:12 AM To: U2 Users List Subject: Re: [U2] UniVerse DOS Command - Batch File Error 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. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse DOS Command - Batch File Error unclassified
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 is C:\Documents and Settings\Default User\Local Settings\Temp. You have got to have write access to the folder for it to work. Andy Mack -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don P. Nagai Sent: Wednesday, 3 November 2010 12:22 p.m. To: 'U2 Users List' Subject: Re: [U2] UniVerse DOS Command - Batch File Error 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 Users List Subject: Re: [U2] UniVerse DOS Command - Batch File Error Rather than double clicking to run the bat, have you tried opening a dos command prompt (Start Run cmd) and then cd'ing to the directory the batch file is in and running the bat from there, as this should keep the window open and hopefully display a message that may point to why the uv shell isn't running as expected? HTH. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Woodward Sent: Wednesday, 03 November 2010 10:12 AM To: U2 Users List Subject: Re: [U2] UniVerse DOS Command - Batch File Error 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. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Using LIST to generate a delimited file.
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 settings! Generating a tab-delimited file is something a novice SQL users can do - it's point and shoot for the most part. I'm hoping our interpretation is as nice! David W. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Tuesday, November 02, 2010 4:37 PM To: U2 Users List Subject: Re: [U2] INPUTIF statement in Universe {Unclassified} 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 Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Tuesday, November 02, 2010 3:24 PM To: 'U2 Users List' Subject: Re: [U2] INPUTIF statement in Universe {Unclassified} 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 the answer is 'it is not there' then I will be forced to ask if someone from Rocket can address 'why not'?? ___ 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