headers
Eric Rosenzweig | 2 Nov 2010 00:41
Favicon

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

This worked great.  

Our CPU utilization went to 0 down from 25%.

Thanks to all!

-----Original Message-----
From: u2-users-bounces <at> listserver.u2ug.org
[mailto:u2-users-bounces <at> listserver.u2ug.org] On Behalf Of Leverett,
Brendon
Sent: Tuesday, October 26, 2010 3:03 PM
To: U2 Users List
Subject: Re: [U2] INPUTIF statement in Universe {Unclassified}

Experienced a similar thing a while back and decided to use NAP as well.
Even went as far as changing the NAP depending on how long the period of
inactivity has been.

Sample code:

        LASTTIME = TIME()
        FOUND.CMD =  <at> FALSE
        LOOP
        UNTIL FOUND.CMD DO
           ELAPSED = TIME() - LASTTIME
           GOSUB SET.NAP.TIME
           IF TIME() - LASTTIME GT QUIT.TIME THEN STOP (or exit or
whatever is best for you)
           INPUTIF TCL.CMD THEN FOUND.CMD =  <at> TRUE ELSE NAP NAPTIME
        REPEAT
(Continue reading)

Permalink | Reply | 13 comments |
headers
David Wolverton | 2 Nov 2010 18:58
Picon

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??
(Continue reading)

Permalink | Reply | 12 comments |
headers
Larry Hiscock | 2 Nov 2010 19:17
Favicon

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-bounces <at> listserver.u2ug.org
[mailto:u2-users-bounces <at> 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!!
(Continue reading)

Permalink | Reply | 1 comment |
headers
Jeff Schasny | 2 Nov 2010 19:25
Picon

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?
>
(Continue reading)

Permalink | Reply | 6 comments |
headers
Charles_Shaffer | 2 Nov 2010 18:32

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 <at> listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Permalink | Reply | 2 comments |
headers
Pamela Robbins | 2 Nov 2010 19:48
Favicon

[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 <at> listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
(Continue reading)

Permalink | Reply | 1 comment |
headers
George Gallen | 2 Nov 2010 20:07

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-bounces <at> listserver.u2ug.org [mailto:u2-users-
> bounces <at> listserver.u2ug.org] On Behalf Of Pamela Robbins
> Sent: Tuesday, November 02, 2010 2:48 PM
> To: u2-users <at> 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.
> 
> 
>
(Continue reading)

Permalink | Reply | 0 comments |
headers
Don P. Nagai | 2 Nov 2010 20:35

[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 <at> listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Permalink | Reply | 17 comments |
headers
Robert Houben | 2 Nov 2010 21:17
Favicon

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-bounces <at> listserver.u2ug.org [mailto:u2-users-bounces <at> 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 <at> listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users <at> listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
(Continue reading)

Permalink | Reply | 0 comments |
headers
HENDERSON MIKE, MR | 2 Nov 2010 21:23
Picon
Favicon

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-----
(Continue reading)

Permalink | Reply | 0 comments |

Gmane