Re: [U2] A readnext within a VOC?
George
Here's a very simple but very utility:
PROGRAM SRUN
*
---
* @@Name: SRUN
* @@Description : Run a command against each element of a select list
* @@Version : 1.0
*
---
* Brief Description
* -
* @@INFO {
* Syntax SRUN Command {} params
* where {} substitutes each select list entry in turn.
* eg SELECT VOC WITH F1 LIKE F... AND WITH F2 UNLIKE .../...
* SRUN RESIZE {} * * *
* }
*
---
* Warnings
*
*
*
---
* Modification History
*
*
---
* Keywords
*
* @@KEY UTILS,SRUN
* --
* To Do List
* --
*
* --
$OPTIONS PICK
Open 'SAVEDLISTS' To Sl Else
Print 'Cannot Open Saved Lists File'
Stop
End
ProgramName = SRUN
TCL = @Sentence
Locate ProgramName In Convert( ,@FM, TCL ) Setting Pos Then
RestOfLine = TCL[ ,Pos+1, Len(TCL)]
End Else
RestOfLine = ''
End
If RestOfLine = '' Then
GoSub Usage
STOP
End
Ix = Index(RestOfLine,{},1)
If Not(Ix) Then
Crt 'no include specification'
STOP
end
ReadList List Else
Crt 'No items Selected'
STOP
End
Loop
Remove Id from List Setting DVAR
Command = Change(RestOfLine,{},Id)
Crt Command
Execute Convert(;,@FM,Command)
While DVAR Do
Repeat
STOP
*---
* Usage
*---
Usage:
Crt 'SRUN - Run a Command against a select list'
Crt 'Syntax - SELECT '
Crt 'SRUN Command {} ...'
Crt '{} substitutes the select list element'
Crt
Crt 'Example:'
Crt ' SELECT VOC WITH F1 LIKE F...'
Crt ' SRUN LIST {} '
Crt
Crt 'Multiple commands can be specified semicolon delimited'
Crt
Return
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: 10 December 2009 7:03 PM
To: U2 Users List
Subject: [U2] A readnext within a VOC?
I'd like to setup a VOC to select a list, then run a program for each entry
in the list (like below...)
PA
GET-LIST LISTNAME
LOOP
READNEXT ID ELSE EXIT
DATA ID
RUN LIB PROGRAMNAME
REPEAT
I Thought there was a way to do this...but just can't remember how.
In the meantime, I pass the list to another program (on another channel)
which reads each item
and EXECUTEs the PROGRAMNAME
George Gallen
Senior Programmer/Analyst
Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com
ph:856.848.9005 Ext 220
The Wyanoke Group
http://www.wyanokegroup.com
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.709 / Virus Database: 270.14.102/2556 - Release Date: 12/10/09
07:36:00
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Run SQL statement through shell script?
I think it's a CASE problem - you have !!Start which doesn't match !!start - just a guess. On Thu, 2009-12-10 at 20:58 -0800, Dattatraya wrote: Dear All How to run sql statement through shell? I am trying following way but no success. /unidata/udt !!Start SET LINESIZE 290; SET HEADING OFF; SET SPACE 2; SET PAGES 0; como on studentinfo; SELECT ID,LNAME,FNAME from STUDENT; como off; exit !!start Regards Dattatraya -- Jeff Butera, Ph.D. Manager of ERP Systems, IT Hampshire College jbut...@hampshire.edu 413-559-5556 Maybe they're slow because they didn't get enough sleep last night. Catherine Butera ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] A readnext within a VOC?
Thanks. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Friday, December 11, 2009 4:29 AM To: 'U2 Users List' Subject: Re: [U2] A readnext within a VOC? George Here's a very simple but very utility: PROGRAM SRUN * --- * @@Name: SRUN * @@Description : Run a command against each element of a select list * @@Version : 1.0 * --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] How to receive XML RPC request with uv
Does anyone know how to receive an XML RPC request on AIX, and process it with uv? This is not a SOAP request, but purely XML RPC. I can handle SOAP requests using a web service built with the Web Services Developer, but this does not do XML only requests. -- Carl Dula Voice: 973-227-8440 X111 Pulsar Systems, Inc.Fax: 973-227-8440 271 Route 46 West, Suite H209 email:c...@pulsarsystems.com Fairfield, NJ 07004-2474http://www.pulsarsystems.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Security and Permissions
Bill, We've had to resolve a similar issue. We're on AIX, but maybe our solution will give you an idea. We have created two userids. The first is user-specific and has the folder privileges required to use UD. But the login is restricted so that they're forced into UD screens and can't get to the OS level. The second ID is shared (wouldn't have to be, though) and has read-only access to the UD folders but broader access to the rest of the system. So maybe your client sets up two ID's for each of the admins that don't get full control. The first forces them to run the UD app, the second has reduced access to UD but gets them to the OS and admin stuff. Brad. A client of ours is running UD. The client has a corporate dbms account that they only want two people to have access to. Their regular dbms account is defined, via Windows permissions, to allow access to their UniData users and Windows administrators. There are several administrators for this machine, three of which they don't want to have access to this corporate dbms directory/account and one they do. We've created a group corporate and assigned this group, and only this group, as having full control of the corporate directory. However, UniData won't work unless this directory gives access to the administrators group. How can I accommodate our clients requirements? Thanks, Bill Haskett U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
