Re: [U2] [Redback/Unix/UniVerse] Security of "redback" login

[Andy Pflueger]

We secure our RedBack login with a little BASH scripted menu that I
put together. When "redback" logs onto our system, the "menu" script
is executed and there are the following options...startrgw, stoprgw,
showrgw, perfrgw, run UDT, exit/logout. We've taken an extra step of
locking down our RedBack login by changing the default password.

HTH,
Andy Pflueger
Ivy Hill Corp.
Louisville, KY


On 8/9/05, Womack, Adrian <[EMAIL PROTECTED]> wrote:
> We're still newbies with redback and are just setting up our first
> production account to use it.
> 
> When we start redback, with "startrgw", one or more "responders" (I
> assume these are basically phantoms) are started on the box with the
> username "redback". For these processes to work correctly they obviously
> have to have the correct permissions to update production files.
> 
> But because the "redback" login is not locked into any menu structure,
> isn't it a gaping security hole - i.e. login as redback and I have full
> access to production files from unix level.
> 
> Currently on our systems anyone (other than root) that has update access
> to production files is locked into a menu. We obviously can't use that
> method with the redback user.
> 
> How does everyone else secure the redback login?
> 
> Adrian
> 
> 
> 
> 
> 
> DISCLAIMER:
> Disclaimer.  This e-mail is private and confidential. If you are not the
> intended recipient, please advise us by return e-mail immediately, and delete
> the e-mail and any attachments without using or disclosing the contents in any
> way. The views expressed in this e-mail are those of the author, and do not
> represent those of this company unless this is clearly indicated. You should
> scan this e-mail and any attachments for viruses. This company accepts no
> liability for any direct or indirect damage or loss resulting from the use of
> any attachments to this e-mail.
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] [Redback/Unix/UniVerse] Security of "redback" login

[Andy Pflueger]

Moreover, for those that are interested, here's the script to which
I'm referring. Keep in mind that pathing to the RGWHOME, RGWBIN,
UDTHOME, and UDTBIN are important. You could always leave out the EXIT
section and make it LOGOUT instead to force the connection to be
broken...we "trust" our RedBack admins with a Unix shell. :)

#!/bin/ksh
# This is the main menu for the REDBACK APPLICATION SERVER config

clear
echo REDBACK APPLICATION SERVER MAIN MENU
echo

select word in START STOP RESTART SHOW PERF UDT EXIT; do
  #echo word is $word
  #echo reply is $REPLY

  if [[ "$word" = "START" ]] ; then
./rgw/bin/startrgw
  fi

  if [[ "$word" = "STOP" ]] ; then
./rgw/bin/stoprgw
  fi

  if [[ "$word" = "RESTART" ]] ; then
./rgw/bin/restartrgw
  fi

  if [[ "$word" = "SHOW" ]] ; then
./rgw/bin/showrgw
  fi

  if [[ "$word" = "PERF" ]] ; then
echo "Please enter the application to run performance monitor on:
" ; read appname
echo "How many itirations would you like to perform? " ; read nint
./rgw/bin/perfrgw -a $appname -n $nint
  fi

  if [[ "$word" = "UDT" ]] ; then
echo "Enter RedBack account to logto: " ; read appname
cd /usr/ud/redback/$appname;
exec /usr/ud/bin/udt;
exit;
  fi

  if [[ "$word" = "EXIT" ]] ; then
exit;
  fi

  if [[ "$word" = "LOGOUT" ]] ; then
exit;
logout;
  fi

done

On 8/9/05, Andy Pflueger <[EMAIL PROTECTED]> wrote:
> We secure our RedBack login with a little BASH scripted menu that I
> put together. When "redback" logs onto our system, the "menu" script
> is executed and there are the following options...startrgw, stoprgw,
> showrgw, perfrgw, run UDT, exit/logout. We've taken an extra step of
> locking down our RedBack login by changing the default password.
> 
> HTH,
> Andy Pflueger
> Ivy Hill Corp.
> Louisville, KY
> 
> 
> On 8/9/05, Womack, Adrian <[EMAIL PROTECTED]> wrote:
> > We're still newbies with redback and are just setting up our first
> > production account to use it.
> >
> > When we start redback, with "startrgw", one or more "responders" (I
> > assume these are basically phantoms) are started on the box with the
> > username "redback". For these processes to work correctly they obviously
> > have to have the correct permissions to update production files.
> >
> > But because the "redback" login is not locked into any menu structure,
> > isn't it a gaping security hole - i.e. login as redback and I have full
> > access to production files from unix level.
> >
> > Currently on our systems anyone (other than root) that has update access
> > to production files is locked into a menu. We obviously can't use that
> > method with the redback user.
> >
> > How does everyone else secure the redback login?
> >
> > Adrian
> >
> >
> >
> >
> >
> > DISCLAIMER:
> > Disclaimer.  This e-mail is private and confidential. If you are not the
> > intended recipient, please advise us by return e-mail immediately, and 
> > delete
> > the e-mail and any attachments without using or disclosing the contents in 
> > any
> > way. The views expressed in this e-mail are those of the author, and do not
> > represent those of this company unless this is clearly indicated. You should
> > scan this e-mail and any attachments for viruses. This company accepts no
> > liability for any direct or indirect damage or loss resulting from the use 
> > of
> > any attachments to this e-mail.
> > ---
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] True random select lists?

[Dave Walker]

I've posted the following to the OpenQM user's list, and thought I'd have a
crack at U2-users as well.

I've been playing with OpenQM at home for a couple of days now. Most of the
questions I've had were quickly answered by consulting the manual.

But because of the app I'm building at home, I have a question that could
just as easily pertain to D3, U2, OpenQM or any of the other various
multivalue databases.

I've built a database of all my mp3s. Now I want to generate a random list
of 100 songs. s there a way to do that with a SELECT statement, or must I
muck around in basic to do so.

I've searched c.d.p. and the U2 users mailing list. I use U2 at work, and am
familiar with "SELECT ... SAMPLE 100", but it returns the same 100 records
every time.

Any thoughts?

Thanks,
--
Dave Walker
8..7 4(())  -:&:-
  -:&:-8.74 .74(())
 ((88.74  ..74  -:&:-
((88.74   * Peace
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] New UV Accout VOC

[Richard Taylor]

As a general statement, want you are doing is not something you want to
experiment with unless you have a completely separate development machine
to work with that you can refresh if you mess it up.  You need to have a
much better understanding of the file structure used by your application
before proceeding further.

See additional responses below:

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:owner-u2-
> [EMAIL PROTECTED] On Behalf Of Brutzman, Bill
> Sent: Monday, August 08, 2005 3:34 PM
> To: 'u2-users@listserver.u2ug.org'
> Subject: RE: [U2] New UV Accout VOC
> 
> [1] An example Q Pointer would help.  It seems the downside to using
> Q-Pointers is that we
> would need a few hundred of them.  On the other hand, for a
SAND-BOX,
> the Q-Pointers could
> be added as needed.

You miss-understand me. When you copied the VOC from another account it
may have/probably contained Q-pointers that were valid for the production
account.  For example if you have a CORPORATE account with a file called
GL there might have been a pointer that looked like:
Q
CORPORATE
GL
This would be potentially disastrous in your SANDBOX account as any writes
performed to GL would up the live account. You should NEVER have a
Q-pointer to a application file in the production/live account(s).  In
this scenario you would want to also create a SANDBOX-CORPORATE that is a
copy of CORPORATE and change the Q-pointer in your. 

> 
> [2] I copied NEWACC to NEWACC.BAK and then overwrote NEWACC with VOC and
> then ran
> UPDATE.ACCOUNT.  Doing so did not work.  A message came back
saying...
> "The following records appear in NEWACC but not in VOC."  Of course,
> these well
> all of the records that we need.
> 
I am not sure what you are trying to accomplish here.  The  NEWACC
file is the repository for UV to keep the VOC entries it needs/wants in a
clean account.  Basically, you should NOT be doing what you did.  As I
said before my preferred method is to copy the account at the OS level
then do an UPDATE.ACCOUNT to be sure the UV entries are correct for the
development system.  Alternatively you could have setup a new account,
which would already have a clean VOC install.  Then create a Q-pointer to
the other VOC file and copy the entries from the Q-pointer with NO
OVERWRITE.  If there are any conflicts make a note of them and deal with
them manually.
  
> [3] While our baseline ERP system is from www.GRMS.com, most of what we
> use
> is homegrown.
> 
I am not familiar with them so I can't help there.

> [4] Copies of VOC appear in half a dozen different places.  When I
change
> VOC in our baseline
> system, I can see the date change on the HP-Ux side.   I was hoping
> that
> the only VOC that
> matters is the one under the account itself.
> 

Again, this is dependant on the application.  If you are not familiar with
the account structure this software you should contact your vendor before
attempting something like this!!!

> [5] I am unable to get change directories to get to
> /u2/METAL/&TEMP&/NEWACC
> and
> 
> /u2/SANDBOX/&TEMP&/NEWACC to try the above
> procedure.
> 
> [6] Somehow our production system knows that the compiled code lives
> here
> 
>   /u2/METAL/SOFTWARE/ACC.BPAccounting Code
> /PUR.BPPurchasing Code
>   ...   /etc   etc
> 
> while the data files are in...
> 
>   /u2/METAL/*
> 
> Further suggestions would be appreciated.
> 
> Thanks to those who responded...
> 
> --Bill Brutzman
> Manager, IT
> HK MetalCraft Mfg Corp
> PO Box 775
> 35 Industrial Road
> Lodi  NJ  07644-0775
> 
> [EMAIL PROTECTED]
> 
> 973.471.7770 x145 .voice
> 973.471.9666 .fax



Rich Taylor | Senior Programmer/Analyst| VERTIS
250 W. Pratt Street | Baltimore, MD 21201
P 410.361.8688 | F 410.528.0319 
[EMAIL PROTECTED] | http://www.vertisinc.com
 
Vertis is the premier provider of targeted advertising, media, and
marketing services that drive consumers to marketers more effectively.
 
"The more they complicate the plumbing
  the easier it is to stop up the drain"
 
- Montgomery Scott NCC-1701
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] True random select lists?

[Christophe Marchal]

I'va made something like this on U2 too.
Juste make a derived field that use RND(@TIME) to generate a random 
number. (maybe in a subroutine)


And use select like this :
SELECT MYFILE BY RANDOM_FIELD SAMPLE 100

But, as ordering record is made before sampling, it could take a little 
time if you have a lot of mp3


Don't know if other system has rnd() function...

Dave Walker a icrit :


I've posted the following to the OpenQM user's list, and thought I'd have a
crack at U2-users as well.

I've been playing with OpenQM at home for a couple of days now. Most of the
questions I've had were quickly answered by consulting the manual.

But because of the app I'm building at home, I have a question that could
just as easily pertain to D3, U2, OpenQM or any of the other various
multivalue databases.

I've built a database of all my mp3s. Now I want to generate a random list
of 100 songs. s there a way to do that with a SELECT statement, or must I
muck around in basic to do so.

I've searched c.d.p. and the U2 users mailing list. I use U2 at work, and am
familiar with "SELECT ... SAMPLE 100", but it returns the same 100 records
every time.

Any thoughts?

Thanks,
--
Dave Walker

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] True random select lists?

[Martin Phillips]

Hi Dave,

> I've built a database of all my mp3s. Now I want to generate a random list
> of 100 songs. s there a way to do that with a SELECT statement, or must I
> muck around in basic to do so.

This depends what you mean by "random". If you are happy to agree that the
hashing process is effectively random from an external point of view, simply
use
   SELECT filename FIRST 100

However, you seem to want a different 100 records each time. I cannot see
any way to do this aside from using a Basic program. Even then, you will
have to start with a list of all the records and then extract 100 items
randomly...

OPEN 'filename' TO FVAR ELSE STOP
SELECT FVAR
READLIST LIST THEN
   N = DCOUNT(LIST, @FM)
   FOR I = 1 TO 100
  X = RND(N) + 1
  ID = LIST
  DEL LIST
  N -= 1
   NEXT I
END

The above idea assumes that the list has over 100 items in it

The basic problem here is that computers are supposed to be repeatable. What
you want is random behaviour so you are unlikely to find it in the standard
toolset.


Martin Phillips
Ladybridge Systems
17b Coldstream Lane, Hardingstone, Northampton NN4 6DB
+44-(0)1604-709200
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] [Redback/Unix/UniVerse] Security of "redback" login

[John Godzina]

Can you set the redback user's login shell to /bin/false, or lock the account 
via passwd (passwd -l option or some *nix systems, or manual editing with vipw 
or similar).

I start redback via init scripts something like this:
/bin/su - rbuser -c /u2/redback354/server/redback/rgw/bin/startrgw >> $LOC 2>&1

that way, on boot redback is up, or root can manually stop/start as needed.

John

On Tue, 9 Aug 2005, Womack, Adrian wrote:

> We're still newbies with redback and are just setting up our first
> production account to use it.
> 
> When we start redback, with "startrgw", one or more "responders" (I
> assume these are basically phantoms) are started on the box with the
> username "redback". For these processes to work correctly they obviously
> have to have the correct permissions to update production files.
> 
> But because the "redback" login is not locked into any menu structure,
> isn't it a gaping security hole - i.e. login as redback and I have full
> access to production files from unix level.
> 
> Currently on our systems anyone (other than root) that has update access
> to production files is locked into a menu. We obviously can't use that
> method with the redback user.
> 
> How does everyone else secure the redback login?
> 
> Adrian
> 
> 
> 
> 
> 
> DISCLAIMER:
> Disclaimer.  This e-mail is private and confidential. If you are not the
> intended recipient, please advise us by return e-mail immediately, and delete
> the e-mail and any attachments without using or disclosing the contents in any
> way. The views expressed in this e-mail are those of the author, and do not
> represent those of this company unless this is clearly indicated. You should
> scan this e-mail and any attachments for viruses. This company accepts no
> liability for any direct or indirect damage or loss resulting from the use of
> any attachments to this e-mail.
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] New UV Accout VOC

[Brutzman, Bill]

Will's answer is quite excellent but...

1.  The SandBox VOC needs to know about files.  So, I did something similar
like...

SELECT MYPOINTER WITH F1 = "F"
  COPY FROM MYPOINTER TO VOC

SELECT MYPOINTER WITH F1 = "PA"
  COPY FROM MYPOINTER TO VOC

2.  The first program that I tried ran OK.  The second and third programs
ended abnormally with 
messages like...

"Improper data type"  when trying to read a record from a file newly
defined in the SANDBOX 
VOC... like

read R.Record from F.FileName  else  R.Record = ''

I suspect that it has to do with line three of the following...

  ED VOC FILENAME  

1: F
2: FILENAME
3: D_FILENAME

3.  Thus, further commentary would be appreciated.

--Bill

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED]
Sent: Monday, August 08, 2005 7:23 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] New UV Accout VOC


Bill. From your sandbox account create a Q-pointer to your production
account 
like this. Let's say the production account is called PRODUCTION
ED VOC MYPOINTER
NEW ITEM
TOP
.I
001 Q
002 PRODUCTION
003 VOC
004
.FI
'MYPOINTER' filed

Now do this
SELECT MYPOINTER WITH F1 = "V"
963 items selected
COPY MYPOINTER
TO: (VOC

This should copy all the missing 'verbs' from PRODUCTION to SANDBOX.

Will Johnson
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] True random select lists?

[Geoffrey Mitchell]

This doesn't work (at least on UV).  The sample happens before the sort, 
not after. 

Otherwise, however, it's an ingenious idea.  Incidentally, you could do 
the same thing (at least in UV) without creating a new dictionary, by 
using EVAL.


i.e.,
SELECT MYFILE BY EVAL "RND(@TIME)"

That way you don't need an extra bogus dictionary in every file you want 
to do this on.


Christophe Marchal wrote:


I'va made something like this on U2 too.
Juste make a derived field that use RND(@TIME) to generate a random 
number. (maybe in a subroutine)


And use select like this :
SELECT MYFILE BY RANDOM_FIELD SAMPLE 100

But, as ordering record is made before sampling, it could take a 
little time if you have a lot of mp3


Don't know if other system has rnd() function...


---
[This E-mail scanned for viruses by Declude Virus]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] True random select lists?

[Dave Walker]

Yes, I would like a DIFFERENT 100 every time, otherwise the FIRST would have
worked. The first thing I thought of was your basic routine, but I just
wondered if I'd overlooked a SELECT option that I wasn't familiar with.

I'm wondering which would be more efficient; the basic subroutine or
Christophe's suggestion of an I descriptor?

Thanks,
--
Dave Walker
8..7 4(())  -:&:-
  -:&:-8.74 .74(())
 ((88.74  ..74  -:&:-
((88.74   * Peace

 

> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of 
> Martin Phillips
> Sent: Tuesday, August 09, 2005 10:46 AM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] True random select lists?
> 
> 
> Hi Dave,
> 
> > I've built a database of all my mp3s. Now I want to 
> generate a random list
> > of 100 songs. s there a way to do that with a SELECT 
> statement, or must I
> > muck around in basic to do so.
> 
> This depends what you mean by "random". If you are happy to 
> agree that the
> hashing process is effectively random from an external point 
> of view, simply
> use
>SELECT filename FIRST 100
> 
> However, you seem to want a different 100 records each time. 
> I cannot see
> any way to do this aside from using a Basic program. Even 
> then, you will
> have to start with a list of all the records and then extract 
> 100 items
> randomly...
> 
> OPEN 'filename' TO FVAR ELSE STOP
> SELECT FVAR
> READLIST LIST THEN
>N = DCOUNT(LIST, @FM)
>FOR I = 1 TO 100
>   X = RND(N) + 1
>   ID = LIST
>   DEL LIST
>   N -= 1
>NEXT I
> END
> 
> The above idea assumes that the list has over 100 items in it
> 
> The basic problem here is that computers are supposed to be 
> repeatable. What
> you want is random behaviour so you are unlikely to find it 
> in the standard
> toolset.
> 
> 
> Martin Phillips
> Ladybridge Systems
> 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB
> +44-(0)1604-709200
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] True random select lists?

[harjinder . dhothar]

Note truly random but you could try

SELECT  SAMPLED x SAMPLE 100  where x is a number to specify how often 
to select a recod, you could change this number every time you did the 
select

h



[EMAIL PROTECTED] 
Sent by: [EMAIL PROTECTED]
09/08/2005 15:04
Please respond to
u2-users@listserver.u2ug.org


To
u2-users@listserver.u2ug.org
cc

Subject
[U2] True random select lists?






I've posted the following to the OpenQM user's list, and thought I'd have 
a
crack at U2-users as well.

I've been playing with OpenQM at home for a couple of days now. Most of 
the
questions I've had were quickly answered by consulting the manual.

But because of the app I'm building at home, I have a question that could
just as easily pertain to D3, U2, OpenQM or any of the other various
multivalue databases.

I've built a database of all my mp3s. Now I want to generate a random list
of 100 songs. s there a way to do that with a SELECT statement, or must I
muck around in basic to do so.

I've searched c.d.p. and the U2 users mailing list. I use U2 at work, and 
am
familiar with "SELECT ... SAMPLE 100", but it returns the same 100 records
every time.

Any thoughts?

Thanks,
--
Dave Walker
8..7 4(())  -:&:-
  -:&:-8.74 .74(())
 ((88.74  ..74  -:&:-
((88.74   * Peace
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] True random select lists?

[Mark Eastwood]

Try creating an "I" Descriptor dictionary item that uses the RND()
function.
SSELECT xxx BY NEWDICT
READNEXT first item, should be different each time?

Mark.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] New UV Accout VOC

[harjinder . dhothar]

The problem here is that anything in the PRODUCTION voc that looks like
<1>F
<2>FILENAME
<3>D_FILENAME

will need to be changed in the SANDBOX account to 
<1>Q
<2>PRODUCTION
<3>FILENAME

this is because these are actual files in the PRODUCTION account and they 
dont exist in the SANDBOX account, so you need to change these file 
defintions to pointers which tell you where the actual file is

h




[EMAIL PROTECTED] 
Sent by: [EMAIL PROTECTED]
09/08/2005 15:58
Please respond to
u2-users@listserver.u2ug.org


To
u2-users@listserver.u2ug.org
cc

Subject
RE: [U2] New UV Accout VOC






Will's answer is quite excellent but...

1.  The SandBox VOC needs to know about files.  So, I did something 
similar
like...

 SELECT MYPOINTER WITH F1 = "F"
  COPY FROM MYPOINTER TO VOC

 SELECT MYPOINTER WITH F1 = "PA"
  COPY FROM MYPOINTER TO VOC

2.  The first program that I tried ran OK.  The second and third programs
ended abnormally with 
messages like...

"Improper data type"  when trying to read a record from a file newly
defined in the SANDBOX 
VOC... like

 read R.Record from F.FileName  else  R.Record = ''

I suspect that it has to do with line three of the following...

  ED VOC FILENAME 

 1: F
 2: FILENAME
 3: D_FILENAME

3.  Thus, further commentary would be appreciated.

--Bill

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED]
Sent: Monday, August 08, 2005 7:23 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] New UV Accout VOC


Bill. From your sandbox account create a Q-pointer to your production
account 
like this. Let's say the production account is called PRODUCTION
ED VOC MYPOINTER
NEW ITEM
TOP
.I
001 Q
002 PRODUCTION
003 VOC
004
.FI
'MYPOINTER' filed

Now do this
SELECT MYPOINTER WITH F1 = "V"
963 items selected
COPY MYPOINTER
TO: (VOC

This should copy all the missing 'verbs' from PRODUCTION to SANDBOX.

Will Johnson
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] New UV Accout VOC

[George Gallen]

Bill, you copied the VOC to the account (and a new unix directory I'm assuming)
but...the actual FILE and contents were not copied, only the VOC entry.

1. delete the VOC entry
2. CREATE-FILE FILENAME (1/19/30 - your choice) (in the sandbox)
3. LOGTO production
4. Create a Q pointer (QPFILE) in the VOC called NEWFILE <1>Q 
<2>sandbox-account-name <3>FILENAME
5. COPY FROM FILENAME TO QPFILE ALL
   COPY FROM DICT FILENAME TO DICT QPFILE ALL

You will need to do that for all VOC entries in production that have F1 like 
"F..."

George

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Brutzman, Bill
Sent: Tuesday, August 09, 2005 10:58 AM
To: 'u2-users@listserver.u2ug.org'
Subject: RE: [U2] New UV Accout VOC


2.  The first program that I tried ran OK.  The second and third programs
ended abnormally with 
messages like...

"Improper data type"  when trying to read a record from a file newly
defined in the SANDBOX 
VOC... like

read R.Record from F.FileName  else  R.Record = ''

I suspect that it has to do with line three of the following...

  ED VOC FILENAME  

1: F
2: FILENAME
3: D_FILENAME

3.  Thus, further commentary would be appreciated.

--Bill
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] New UV Accout VOC

[George Gallen]

I wouldn't change them to Q pointers. Otherwise the sandbox account
will CHANGE the data in the PRODUCTION account, you need to copy them
to the new account so you have your own files to muck with.

George

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: Tuesday, August 09, 2005 11:42 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] New UV Accout VOC


The problem here is that anything in the PRODUCTION voc that looks like
<1>F
<2>FILENAME
<3>D_FILENAME

will need to be changed in the SANDBOX account to 
<1>Q
<2>PRODUCTION
<3>FILENAME

this is because these are actual files in the PRODUCTION account and they 
dont exist in the SANDBOX account, so you need to change these file 
defintions to pointers which tell you where the actual file is

h




[EMAIL PROTECTED] 
Sent by: [EMAIL PROTECTED]
09/08/2005 15:58
Please respond to
u2-users@listserver.u2ug.org


To
u2-users@listserver.u2ug.org
cc

Subject
RE: [U2] New UV Accout VOC






Will's answer is quite excellent but...

1.  The SandBox VOC needs to know about files.  So, I did something 
similar
like...

 SELECT MYPOINTER WITH F1 = "F"
  COPY FROM MYPOINTER TO VOC

 SELECT MYPOINTER WITH F1 = "PA"
  COPY FROM MYPOINTER TO VOC

2.  The first program that I tried ran OK.  The second and third programs
ended abnormally with 
messages like...

"Improper data type"  when trying to read a record from a file newly
defined in the SANDBOX 
VOC... like

 read R.Record from F.FileName  else  R.Record = ''

I suspect that it has to do with line three of the following...

  ED VOC FILENAME 

 1: F
 2: FILENAME
 3: D_FILENAME

3.  Thus, further commentary would be appreciated.

--Bill

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED]
Sent: Monday, August 08, 2005 7:23 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] New UV Accout VOC


Bill. From your sandbox account create a Q-pointer to your production
account 
like this. Let's say the production account is called PRODUCTION
ED VOC MYPOINTER
NEW ITEM
TOP
.I
001 Q
002 PRODUCTION
003 VOC
004
.FI
'MYPOINTER' filed

Now do this
SELECT MYPOINTER WITH F1 = "V"
963 items selected
COPY MYPOINTER
TO: (VOC

This should copy all the missing 'verbs' from PRODUCTION to SANDBOX.

Will Johnson
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] True random select lists?

[Martin Phillips]

Dave,

> I'm wondering which would be more efficient; the basic subroutine or
> Christophe's suggestion of an I descriptor?

Both solutions require that the entire file is read to construct the list.
There probably isn't a lot in it either way.


Martin Phillips
Ladybridge Systems
17b Coldstream Lane, Hardingstone, Northampton NN4 6DB
+44-(0)1604-709200
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] New UV Accout VOC

[George Gallen]

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of George Gallen
Sent: Tuesday, August 09, 2005 11:43 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] New UV Accout VOC


Bill, you copied the VOC to the account (and a new unix directory I'm assuming)
but...the actual FILE and contents were not copied, only the VOC entry.

1. delete the VOC entry

delte the VOC in the sandbox account, do not DELETE anything in the production 
account :)


2. CREATE-FILE FILENAME (1/19/30 - your choice) (in the sandbox)
3. LOGTO production
4. Create a Q pointer (QPFILE) in the VOC called NEWFILE <1>Q 
<2>sandbox-account-name <3>FILENAME

just to clarify:
   Create a Q pointer in the VOC called QPFILE with <1>Q  
<2>sandbox-account-name   <3>FILENAME


5. COPY FROM FILENAME TO QPFILE ALL
   COPY FROM DICT FILENAME TO DICT QPFILE ALL

You will need to do that for all VOC entries in production that have F1 like 
"F..."



Oh and one other thing.

Before you go ANY further...make sure you a valid backup, not just a tape, but 
attempt to "restore" a 
file that doesn't not exist, so you know the tape is fully readable, and 
doesn't bomb out half way
through the restore attempt (*** big time important ***)

George

-
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] New UV Accout VOC

[Anthony Dzikiewicz]

Sometimes this can be dangerous.  We had a routine to open files in a
common area.  We had a live account in one directory and a test in
another.  If you switched back and forth between live and test you were
still pointing to the same files.  We had to create a 'close files'
routine when switching back and forth.  Anyway, we no longer share test
and production on the same machine.  Equipment is so cheap these days we
bought a test server. Be careful !
Anthony

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Tuesday, August 09, 2005 11:42 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] New UV Accout VOC


The problem here is that anything in the PRODUCTION voc that looks like
<1>F <2>FILENAME <3>D_FILENAME

will need to be changed in the SANDBOX account to 
<1>Q
<2>PRODUCTION
<3>FILENAME

this is because these are actual files in the PRODUCTION account and
they 
dont exist in the SANDBOX account, so you need to change these file 
defintions to pointers which tell you where the actual file is

h




[EMAIL PROTECTED] 
Sent by: [EMAIL PROTECTED]
09/08/2005 15:58
Please respond to
u2-users@listserver.u2ug.org


To
u2-users@listserver.u2ug.org
cc

Subject
RE: [U2] New UV Accout VOC






Will's answer is quite excellent but...

1.  The SandBox VOC needs to know about files.  So, I did something 
similar
like...

 SELECT MYPOINTER WITH F1 = "F"
  COPY FROM MYPOINTER TO VOC

 SELECT MYPOINTER WITH F1 = "PA"
  COPY FROM MYPOINTER TO VOC

2.  The first program that I tried ran OK.  The second and third
programs ended abnormally with 
messages like...

"Improper data type"  when trying to read a record from a file newly
defined in the SANDBOX 
VOC... like

 read R.Record from F.FileName  else  R.Record = ''

I suspect that it has to do with line three of the following...

  ED VOC FILENAME 

 1: F
 2: FILENAME
 3: D_FILENAME

3.  Thus, further commentary would be appreciated.

--Bill

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED]
Sent: Monday, August 08, 2005 7:23 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] New UV Accout VOC


Bill. From your sandbox account create a Q-pointer to your production
account 
like this. Let's say the production account is called PRODUCTION ED VOC
MYPOINTER NEW ITEM TOP .I 001 Q 002 PRODUCTION 003 VOC 004 .FI
'MYPOINTER' filed

Now do this
SELECT MYPOINTER WITH F1 = "V"
963 items selected
COPY MYPOINTER
TO: (VOC

This should copy all the missing 'verbs' from PRODUCTION to SANDBOX.

Will Johnson
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] True random select lists?

[Allen E. Elwood]

The I-desc is a nice idea, however you're going to get multiple hits on the
same song, and don't we all hate that when we hear the same song?

The basic idea is very similar to something that I did with the thought of
the day.  I used to select the entire file put it into an array, and then
base the random number based off of the time of the day with a modulo of a
prime number close to the total number of records selected and use that to
prime RND.  Or maybe visa versa.  It was a LONG time ago in a universe very
very far away ;)

This was similar to hashing in pick, and where I got the idea.  Using the
time, gave as close to a really random number as possible.  Since I was only
selecting one record a day, I would post a 1 to that record so it would not
be selected the next time.  When my select didn't return any records I would
just clear all the 1's in the file and start over.  Worked great!

But but but, why not just get the free winamp www.winamp.com and just click
on random???

Allen

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Dave Walker
Sent: Tuesday, August 09, 2005 08:22
To: 'u2-users@listserver.u2ug.org'
Subject: RE: [U2] True random select lists?


Yes, I would like a DIFFERENT 100 every time, otherwise the FIRST would have
worked. The first thing I thought of was your basic routine, but I just
wondered if I'd overlooked a SELECT option that I wasn't familiar with.

I'm wondering which would be more efficient; the basic subroutine or
Christophe's suggestion of an I descriptor?

Thanks,
--
Dave Walker
8..7 4(())  -:&:-
  -:&:-8.74 .74(())
 ((88.74  ..74  -:&:-
((88.74   * Peace



> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of
> Martin Phillips
> Sent: Tuesday, August 09, 2005 10:46 AM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] True random select lists?
>
>
> Hi Dave,
>
> > I've built a database of all my mp3s. Now I want to
> generate a random list
> > of 100 songs. s there a way to do that with a SELECT
> statement, or must I
> > muck around in basic to do so.
>
> This depends what you mean by "random". If you are happy to
> agree that the
> hashing process is effectively random from an external point
> of view, simply
> use
>SELECT filename FIRST 100
>
> However, you seem to want a different 100 records each time.
> I cannot see
> any way to do this aside from using a Basic program. Even
> then, you will
> have to start with a list of all the records and then extract
> 100 items
> randomly...
>
> OPEN 'filename' TO FVAR ELSE STOP
> SELECT FVAR
> READLIST LIST THEN
>N = DCOUNT(LIST, @FM)
>FOR I = 1 TO 100
>   X = RND(N) + 1
>   ID = LIST
>   DEL LIST
>   N -= 1
>NEXT I
> END
>
> The above idea assumes that the list has over 100 items in it
>
> The basic problem here is that computers are supposed to be
> repeatable. What
> you want is random behaviour so you are unlikely to find it
> in the standard
> toolset.
>
>
> Martin Phillips
> Ladybridge Systems
> 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB
> +44-(0)1604-709200
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] True random select lists?

[Rex Gozar]

To build on Christophe Marchal's idea, why not

>SELECT MYFILE BY EVAL "RND(@TIME)"
>SELECT MYFILE SAMPLE 100
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] True random select lists?

[Dave Walker]

I use xmms for playing the music, but until now have used a mysql database
to generate the playlists.

What I'm actually trying to do is learn how to talk to OpenQM with qmclilib.
I've managed to create a python wrapper for the library, and have now built
the database using the same program I wrote to learn how to program python.
I've just stripped out the mysql bits and put in the OpenQM equivalent. (The
database structure has also changed, of course, to take advantage of
multivalues!)

I'll eventually put a pretty face on the frontend with PyQT, and possibly
give it multiple personalities with apache2 and mod_python.

But I have to learn to walk before I can run, and an mp3 application is the
easiest way I have to generate a fair sized database. I can populate it from
the mp3 tags themselves, and do so many fun things with it after it's built!

Thanks for the comments,
--
Dave Walker
8..7 4(())  -:&:-
  -:&:-8.74 .74(())
 ((88.74  ..74  -:&:-
((88.74   * Peace

 

> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Allen 
> E. Elwood
> Sent: Tuesday, August 09, 2005 12:11 PM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] True random select lists?
> 
> 
> The I-desc is a nice idea, however you're going to get 
> multiple hits on the
> same song, and don't we all hate that when we hear the same song?
> 
> The basic idea is very similar to something that I did with 
> the thought of
> the day.  I used to select the entire file put it into an 
> array, and then
> base the random number based off of the time of the day with 
> a modulo of a
> prime number close to the total number of records selected 
> and use that to
> prime RND.  Or maybe visa versa.  It was a LONG time ago in a 
> universe very
> very far away ;)
> 
> This was similar to hashing in pick, and where I got the 
> idea.  Using the
> time, gave as close to a really random number as possible.  
> Since I was only
> selecting one record a day, I would post a 1 to that record 
> so it would not
> be selected the next time.  When my select didn't return any 
> records I would
> just clear all the 1's in the file and start over.  Worked great!
> 
> But but but, why not just get the free winamp www.winamp.com 
> and just click
> on random???
> 
> Allen
> 
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Dave Walker
> Sent: Tuesday, August 09, 2005 08:22
> To: 'u2-users@listserver.u2ug.org'
> Subject: RE: [U2] True random select lists?
> 
> 
> Yes, I would like a DIFFERENT 100 every time, otherwise the 
> FIRST would have
> worked. The first thing I thought of was your basic routine, 
> but I just
> wondered if I'd overlooked a SELECT option that I wasn't 
> familiar with.
> 
> I'm wondering which would be more efficient; the basic subroutine or
> Christophe's suggestion of an I descriptor?
> 
> Thanks,
> --
> Dave Walker
> 8..7 4(())  -:&:-
>   -:&:-8.74 .74(())
>  ((88.74  ..74  -:&:-
> ((88.74   * Peace
> 
> 
> 
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] Behalf Of
> > Martin Phillips
> > Sent: Tuesday, August 09, 2005 10:46 AM
> > To: u2-users@listserver.u2ug.org
> > Subject: Re: [U2] True random select lists?
> >
> >
> > Hi Dave,
> >
> > > I've built a database of all my mp3s. Now I want to
> > generate a random list
> > > of 100 songs. s there a way to do that with a SELECT
> > statement, or must I
> > > muck around in basic to do so.
> >
> > This depends what you mean by "random". If you are happy to
> > agree that the
> > hashing process is effectively random from an external point
> > of view, simply
> > use
> >SELECT filename FIRST 100
> >
> > However, you seem to want a different 100 records each time.
> > I cannot see
> > any way to do this aside from using a Basic program. Even
> > then, you will
> > have to start with a list of all the records and then extract
> > 100 items
> > randomly...
> >
> > OPEN 'filename' TO FVAR ELSE STOP
> > SELECT FVAR
> > READLIST LIST THEN
> >N = DCOUNT(LIST, @FM)
> >FOR I = 1 TO 100
> >   X = RND(N) + 1
> >   ID = LIST
> >   DEL LIST
> >   N -= 1
> >NEXT I
> > END
> >
> > The above idea assumes that the list has over 100 items in it
> >
> > The basic problem here is that computers are supposed to be
> > repeatable. What
> > you want is random behaviour so you are unlikely to find it
> > in the standard
> > toolset.
> >
> >
> > Martin Phillips
> > Ladybridge Systems
> > 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB
> > +44-(0)1604-709200
> > ---
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailin

RE: [U2] True random select lists?

[Dave Walker]

I did not know about a SAMPLED clause. You learn something new every day
(hopefully).

Thanks,
--
Dave Walker
8..7 4(())  -:&:-
  -:&:-8.74 .74(())
 ((88.74  ..74  -:&:-
((88.74   * Peace

 

> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of
> [EMAIL PROTECTED]
> Sent: Tuesday, August 09, 2005 11:31 AM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] True random select lists?
> 
> 
> Note truly random but you could try
> 
> SELECT  SAMPLED x SAMPLE 100  where x is a number to 
> specify how often 
> to select a recod, you could change this number every time 
> you did the 
> select
> 
> h
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] True random select lists?

[Allen E. Elwood]

Wow, and here I just program dull business programs, day after day, year
after year, decade after decade.

Have Fun

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Dave Walker
Sent: Tuesday, August 09, 2005 10:51
To: 'u2-users@listserver.u2ug.org'
Subject: RE: [U2] True random select lists?


I use xmms for playing the music, but until now have used a mysql database
to generate the playlists.

What I'm actually trying to do is learn how to talk to OpenQM with qmclilib.
I've managed to create a python wrapper for the library, and have now built
the database using the same program I wrote to learn how to program python.
I've just stripped out the mysql bits and put in the OpenQM equivalent. (The
database structure has also changed, of course, to take advantage of
multivalues!)

I'll eventually put a pretty face on the frontend with PyQT, and possibly
give it multiple personalities with apache2 and mod_python.

But I have to learn to walk before I can run, and an mp3 application is the
easiest way I have to generate a fair sized database. I can populate it from
the mp3 tags themselves, and do so many fun things with it after it's built!

Thanks for the comments,
--
Dave Walker
8..7 4(())  -:&:-
  -:&:-8.74 .74(())
 ((88.74  ..74  -:&:-
((88.74   * Peace



> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Allen
> E. Elwood
> Sent: Tuesday, August 09, 2005 12:11 PM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] True random select lists?
>
>
> The I-desc is a nice idea, however you're going to get
> multiple hits on the
> same song, and don't we all hate that when we hear the same song?
>
> The basic idea is very similar to something that I did with
> the thought of
> the day.  I used to select the entire file put it into an
> array, and then
> base the random number based off of the time of the day with
> a modulo of a
> prime number close to the total number of records selected
> and use that to
> prime RND.  Or maybe visa versa.  It was a LONG time ago in a
> universe very
> very far away ;)
>
> This was similar to hashing in pick, and where I got the
> idea.  Using the
> time, gave as close to a really random number as possible.
> Since I was only
> selecting one record a day, I would post a 1 to that record
> so it would not
> be selected the next time.  When my select didn't return any
> records I would
> just clear all the 1's in the file and start over.  Worked great!
>
> But but but, why not just get the free winamp www.winamp.com
> and just click
> on random???
>
> Allen
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Dave Walker
> Sent: Tuesday, August 09, 2005 08:22
> To: 'u2-users@listserver.u2ug.org'
> Subject: RE: [U2] True random select lists?
>
>
> Yes, I would like a DIFFERENT 100 every time, otherwise the
> FIRST would have
> worked. The first thing I thought of was your basic routine,
> but I just
> wondered if I'd overlooked a SELECT option that I wasn't
> familiar with.
>
> I'm wondering which would be more efficient; the basic subroutine or
> Christophe's suggestion of an I descriptor?
>
> Thanks,
> --
> Dave Walker
> 8..7 4(())  -:&:-
>   -:&:-8.74 .74(())
>  ((88.74  ..74  -:&:-
> ((88.74   * Peace
>
>
>
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] Behalf Of
> > Martin Phillips
> > Sent: Tuesday, August 09, 2005 10:46 AM
> > To: u2-users@listserver.u2ug.org
> > Subject: Re: [U2] True random select lists?
> >
> >
> > Hi Dave,
> >
> > > I've built a database of all my mp3s. Now I want to
> > generate a random list
> > > of 100 songs. s there a way to do that with a SELECT
> > statement, or must I
> > > muck around in basic to do so.
> >
> > This depends what you mean by "random". If you are happy to
> > agree that the
> > hashing process is effectively random from an external point
> > of view, simply
> > use
> >SELECT filename FIRST 100
> >
> > However, you seem to want a different 100 records each time.
> > I cannot see
> > any way to do this aside from using a Basic program. Even
> > then, you will
> > have to start with a list of all the records and then extract
> > 100 items
> > randomly...
> >
> > OPEN 'filename' TO FVAR ELSE STOP
> > SELECT FVAR
> > READLIST LIST THEN
> >N = DCOUNT(LIST, @FM)
> >FOR I = 1 TO 100
> >   X = RND(N) + 1
> >   ID = LIST
> >   DEL LIST
> >   N -= 1
> >NEXT I
> > END
> >
> > The above idea assumes that the list has over 100 items in it
> >
> > The basic problem here is that computers are supposed to be
> > repeatable. What
> > you want is random behaviour so you are unlikely to find it
> > in the standard
> > toolset.
> >
> >
> > Martin Phillips
> > Ladybridge Systems
> > 17b Coldstream Lane, Hardingstone, Northampton NN4 6

RE: [U2] True random select lists?

[Norman Morgan]

Please contact me off-list.  I'm curious about the end use of your random
selection of music files.  A similar idea has been kicking around in my head
for years.

===
Norman Morgan <> [EMAIL PROTECTED] <> http://www.brake.com
===
The crimes we are about to depict have been specially
committed for this program.
===



> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Dave Walker
> Sent: Tuesday, August 09, 2005 12:51 PM
> To: 'u2-users@listserver.u2ug.org'
> Subject: RE: [U2] True random select lists?
>
>
> I use xmms for playing the music, but until now have used a mysql database
> to generate the playlists.
>
> What I'm actually trying to do is learn how to talk to OpenQM
> with qmclilib.
> I've managed to create a python wrapper for the library, and have
> now built
> the database using the same program I wrote to learn how to
> program python.
> I've just stripped out the mysql bits and put in the OpenQM
> equivalent. (The
> database structure has also changed, of course, to take advantage of
> multivalues!)
>
> I'll eventually put a pretty face on the frontend with PyQT, and possibly
> give it multiple personalities with apache2 and mod_python.
>
> But I have to learn to walk before I can run, and an mp3
> application is the
> easiest way I have to generate a fair sized database. I can
> populate it from
> the mp3 tags themselves, and do so many fun things with it after
> it's built!
>
> Thanks for the comments,
> --
> Dave Walker
> 8..7 4(())  -:&:-
>   -:&:-8.74 .74(())
>  ((88.74  ..74  -:&:-
> ((88.74   * Peace
>
>
>
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] Behalf Of Allen
> > E. Elwood
> > Sent: Tuesday, August 09, 2005 12:11 PM
> > To: u2-users@listserver.u2ug.org
> > Subject: RE: [U2] True random select lists?
> >
> >
> > The I-desc is a nice idea, however you're going to get
> > multiple hits on the
> > same song, and don't we all hate that when we hear the same song?
> >
> > The basic idea is very similar to something that I did with
> > the thought of
> > the day.  I used to select the entire file put it into an
> > array, and then
> > base the random number based off of the time of the day with
> > a modulo of a
> > prime number close to the total number of records selected
> > and use that to
> > prime RND.  Or maybe visa versa.  It was a LONG time ago in a
> > universe very
> > very far away ;)
> >
> > This was similar to hashing in pick, and where I got the
> > idea.  Using the
> > time, gave as close to a really random number as possible.
> > Since I was only
> > selecting one record a day, I would post a 1 to that record
> > so it would not
> > be selected the next time.  When my select didn't return any
> > records I would
> > just clear all the 1's in the file and start over.  Worked great!
> >
> > But but but, why not just get the free winamp www.winamp.com
> > and just click
> > on random???
> >
> > Allen
> >
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] Behalf Of Dave Walker
> > Sent: Tuesday, August 09, 2005 08:22
> > To: 'u2-users@listserver.u2ug.org'
> > Subject: RE: [U2] True random select lists?
> >
> >
> > Yes, I would like a DIFFERENT 100 every time, otherwise the
> > FIRST would have
> > worked. The first thing I thought of was your basic routine,
> > but I just
> > wondered if I'd overlooked a SELECT option that I wasn't
> > familiar with.
> >
> > I'm wondering which would be more efficient; the basic subroutine or
> > Christophe's suggestion of an I descriptor?
> >
> > Thanks,
> > --
> > Dave Walker
> > 8..7 4(())  -:&:-
> >   -:&:-8.74 .74(())
> >  ((88.74  ..74  -:&:-
> > ((88.74   * Peace
> >
> >
> >
> > > -Original Message-
> > > From: [EMAIL PROTECTED]
> > > [mailto:[EMAIL PROTECTED] Behalf Of
> > > Martin Phillips
> > > Sent: Tuesday, August 09, 2005 10:46 AM
> > > To: u2-users@listserver.u2ug.org
> > > Subject: Re: [U2] True random select lists?
> > >
> > >
> > > Hi Dave,
> > >
> > > > I've built a database of all my mp3s. Now I want to
> > > generate a random list
> > > > of 100 songs. s there a way to do that with a SELECT
> > > statement, or must I
> > > > muck around in basic to do so.
> > >
> > > This depends what you mean by "random". If you are happy to
> > > agree that the
> > > hashing process is effectively random from an external point
> > > of view, simply
> > > use
> > >SELECT filename FIRST 100
> > >
> > > However, you seem to want a different 100 records each time.
> > > I cannot see
> > > any way to do this aside from using a Basic program. Even
> > > then, you will
> > > have to start with a list of all the records and the

RE: [U2] True random select lists?

[Peter Gonzalez]

Wow,  imagine using my ipod with a MV database. 


At 11:27 AM 8/9/2005 -0700, you wrote:

Wow, and here I just program dull business programs, day after day, year
after year, decade after decade.

Have Fun

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Dave Walker
Sent: Tuesday, August 09, 2005 10:51
To: 'u2-users@listserver.u2ug.org'
Subject: RE: [U2] True random select lists?


I use xmms for playing the music, but until now have used a mysql database
to generate the playlists.

What I'm actually trying to do is learn how to talk to OpenQM with qmclilib.
I've managed to create a python wrapper for the library, and have now built
the database using the same program I wrote to learn how to program python.
I've just stripped out the mysql bits and put in the OpenQM equivalent. (The
database structure has also changed, of course, to take advantage of
multivalues!)

I'll eventually put a pretty face on the frontend with PyQT, and possibly
give it multiple personalities with apache2 and mod_python.

But I have to learn to walk before I can run, and an mp3 application is the
easiest way I have to generate a fair sized database. I can populate it from
the mp3 tags themselves, and do so many fun things with it after it's built!

Thanks for the comments,
--
Dave Walker
8..7 4(())  -:&:-
  -:&:-8.74 .74(())
 ((88.74  ..74  -:&:-
((88.74   * Peace



> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Allen
> E. Elwood
> Sent: Tuesday, August 09, 2005 12:11 PM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] True random select lists?
>
>
> The I-desc is a nice idea, however you're going to get
> multiple hits on the
> same song, and don't we all hate that when we hear the same song?
>
> The basic idea is very similar to something that I did with
> the thought of
> the day.  I used to select the entire file put it into an
> array, and then
> base the random number based off of the time of the day with
> a modulo of a
> prime number close to the total number of records selected
> and use that to
> prime RND.  Or maybe visa versa.  It was a LONG time ago in a
> universe very
> very far away ;)
>
> This was similar to hashing in pick, and where I got the
> idea.  Using the
> time, gave as close to a really random number as possible.
> Since I was only
> selecting one record a day, I would post a 1 to that record
> so it would not
> be selected the next time.  When my select didn't return any
> records I would
> just clear all the 1's in the file and start over.  Worked great!
>
> But but but, why not just get the free winamp www.winamp.com
> and just click
> on random???
>
> Allen
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Dave Walker
> Sent: Tuesday, August 09, 2005 08:22
> To: 'u2-users@listserver.u2ug.org'
> Subject: RE: [U2] True random select lists?
>
>
> Yes, I would like a DIFFERENT 100 every time, otherwise the
> FIRST would have
> worked. The first thing I thought of was your basic routine,
> but I just
> wondered if I'd overlooked a SELECT option that I wasn't
> familiar with.
>
> I'm wondering which would be more efficient; the basic subroutine or
> Christophe's suggestion of an I descriptor?
>
> Thanks,
> --
> Dave Walker
> 8..7 4(())  -:&:-
>   -:&:-8.74 .74(())
>  ((88.74  ..74  -:&:-
> ((88.74   * Peace
>
>
>
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] Behalf Of
> > Martin Phillips
> > Sent: Tuesday, August 09, 2005 10:46 AM
> > To: u2-users@listserver.u2ug.org
> > Subject: Re: [U2] True random select lists?
> >
> >
> > Hi Dave,
> >
> > > I've built a database of all my mp3s. Now I want to
> > generate a random list
> > > of 100 songs. s there a way to do that with a SELECT
> > statement, or must I
> > > muck around in basic to do so.
> >
> > This depends what you mean by "random". If you are happy to
> > agree that the
> > hashing process is effectively random from an external point
> > of view, simply
> > use
> >SELECT filename FIRST 100
> >
> > However, you seem to want a different 100 records each time.
> > I cannot see
> > any way to do this aside from using a Basic program. Even
> > then, you will
> > have to start with a list of all the records and then extract
> > 100 items
> > randomly...
> >
> > OPEN 'filename' TO FVAR ELSE STOP
> > SELECT FVAR
> > READLIST LIST THEN
> >N = DCOUNT(LIST, @FM)
> >FOR I = 1 TO 100
> >   X = RND(N) + 1
> >   ID = LIST
> >   DEL LIST
> >   N -= 1
> >NEXT I
> > END
> >
> > The above idea assumes that the list has over 100 items in it
> >
> > The basic problem here is that computers are supposed to be
> > repeatable. What
> > you want is random behaviour so you are unlikely to find it
> > in the standard
> > toolset.
> >
> >
> >

RE: [U2] True random select lists?

[Dave Walker]

The "dull business programs" is my day job. 

The fun stuff is at night. Just trying to keep my skillset current.

Thanks,
--
Dave Walker
8..7 4(())  -:&:-
  -:&:-8.74 .74(())
 ((88.74  ..74  -:&:-
((88.74   * Peace

 

> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Allen 
> E. Elwood
> Sent: Tuesday, August 09, 2005 2:28 PM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] True random select lists?
> 
> 
> Wow, and here I just program dull business programs, day 
> after day, year
> after year, decade after decade.
> 
> Have Fun
> 
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Dave Walker
> Sent: Tuesday, August 09, 2005 10:51
> To: 'u2-users@listserver.u2ug.org'
> Subject: RE: [U2] True random select lists?
> 
> 
> I use xmms for playing the music, but until now have used a 
> mysql database
> to generate the playlists.
> 
> What I'm actually trying to do is learn how to talk to OpenQM 
> with qmclilib.
> I've managed to create a python wrapper for the library, and 
> have now built
> the database using the same program I wrote to learn how to 
> program python.
> I've just stripped out the mysql bits and put in the OpenQM 
> equivalent. (The
> database structure has also changed, of course, to take advantage of
> multivalues!)
> 
> I'll eventually put a pretty face on the frontend with PyQT, 
> and possibly
> give it multiple personalities with apache2 and mod_python.
> 
> But I have to learn to walk before I can run, and an mp3 
> application is the
> easiest way I have to generate a fair sized database. I can 
> populate it from
> the mp3 tags themselves, and do so many fun things with it 
> after it's built!
> 
> Thanks for the comments,
> --
> Dave Walker
> 8..7 4(())  -:&:-
>   -:&:-8.74 .74(())
>  ((88.74  ..74  -:&:-
> ((88.74   * Peace
> 
> 
> 
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] Behalf Of Allen
> > E. Elwood
> > Sent: Tuesday, August 09, 2005 12:11 PM
> > To: u2-users@listserver.u2ug.org
> > Subject: RE: [U2] True random select lists?
> >
> >
> > The I-desc is a nice idea, however you're going to get
> > multiple hits on the
> > same song, and don't we all hate that when we hear the same song?
> >
> > The basic idea is very similar to something that I did with
> > the thought of
> > the day.  I used to select the entire file put it into an
> > array, and then
> > base the random number based off of the time of the day with
> > a modulo of a
> > prime number close to the total number of records selected
> > and use that to
> > prime RND.  Or maybe visa versa.  It was a LONG time ago in a
> > universe very
> > very far away ;)
> >
> > This was similar to hashing in pick, and where I got the
> > idea.  Using the
> > time, gave as close to a really random number as possible.
> > Since I was only
> > selecting one record a day, I would post a 1 to that record
> > so it would not
> > be selected the next time.  When my select didn't return any
> > records I would
> > just clear all the 1's in the file and start over.  Worked great!
> >
> > But but but, why not just get the free winamp www.winamp.com
> > and just click
> > on random???
> >
> > Allen
> >
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] Behalf Of Dave Walker
> > Sent: Tuesday, August 09, 2005 08:22
> > To: 'u2-users@listserver.u2ug.org'
> > Subject: RE: [U2] True random select lists?
> >
> >
> > Yes, I would like a DIFFERENT 100 every time, otherwise the
> > FIRST would have
> > worked. The first thing I thought of was your basic routine,
> > but I just
> > wondered if I'd overlooked a SELECT option that I wasn't
> > familiar with.
> >
> > I'm wondering which would be more efficient; the basic subroutine or
> > Christophe's suggestion of an I descriptor?
> >
> > Thanks,
> > --
> > Dave Walker
> > 8..7 4(())  -:&:-
> >   -:&:-8.74 .74(())
> >  ((88.74  ..74  -:&:-
> > ((88.74   * Peace
> >
> >
> >
> > > -Original Message-
> > > From: [EMAIL PROTECTED]
> > > [mailto:[EMAIL PROTECTED] Behalf Of
> > > Martin Phillips
> > > Sent: Tuesday, August 09, 2005 10:46 AM
> > > To: u2-users@listserver.u2ug.org
> > > Subject: Re: [U2] True random select lists?
> > >
> > >
> > > Hi Dave,
> > >
> > > > I've built a database of all my mp3s. Now I want to
> > > generate a random list
> > > > of 100 songs. s there a way to do that with a SELECT
> > > statement, or must I
> > > > muck around in basic to do so.
> > >
> > > This depends what you mean by "random". If you are happy to
> > > agree that the
> > > hashing process is effectively random from an external point
> > > of view, simply
> > > use
> > >SELECT filename FIRST 100
> > >
> > > However, you seem to want a different

RE: [U2] True random select lists?

[George Gallen]

know what you mean. I installed PE on a mini-PC running Fedora
at home for those little projects. It's a cool little computer
http://www.carcarealert.com/mini-pc.bmp

With it's small footprint, it sits on top of our regular PC, I
run it with no keyboard, mouse or display (telnet in from laptop).
and I've configured our firewall to switch ftp/http/telnet inbound
traffic to it, (and only specific IP's).

Eventually, I'll use it as backend from a .cgi off another webserver
using sockets and custom programming.

I've had the system now for about year, just started actually using
finding a few uses for it (rather finally found a few extra minutes
to find a few uses for it).


BTW, what are the characters on your sig?
8..7 4(())  -:&:-
  -:&:-8.74 .74(())
 ((88.74  ..74  -:&:-
((88.74   * Peace

I have yet to figure them out?

George



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Dave Walker
Sent: Tuesday, August 09, 2005 3:02 PM
To: 'u2-users@listserver.u2ug.org'
Subject: RE: [U2] True random select lists?


The "dull business programs" is my day job. 

The fun stuff is at night. Just trying to keep my skillset current.

Thanks,
--
Dave Walker
8..7 4(())  -:&:-
  -:&:-8.74 .74(())
 ((88.74  ..74  -:&:-
((88.74   * Peace
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Remote printing in UniVerse release 10.1.3

[Paul Hamrick]

I have defined a remote Windows TCP/IP printer; in Windows I can print a
test print job fine. In UniVerse I executed the SPOOL -LIST and see my
defined Windows printer. I execute SETPTR to defined printer and send a
print job from TCL and the job leaves UniVerse goes to the Windows
spooler where it exits clean as well, BUT DOES NOT PRINT at the
printer.the printer is a Panasonic DP-4530. 
 
So I can print in Windows, but from UniVerse application or even from
UniVerse TCL the job does not make it to the printer! Remember my
Windows test job prints fine. 
 
Can you lead me to some possible causes for the UniVerse job to not
reach the printer?
 
Paul Hamrick
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[OT] Sig (WAS RE: [U2] True random select lists?)

[Dave Walker]

Well, back before I had to use outlook as my email client, it was some
spiffy ascii art that looks like swirls of smoke and stars with 'Peace' at
the end. Outlook mangles it so that it's unrecognisable before it sends it,
though. 

--
Dave Walker
8..7 4(())  -:&:-
  -:&:-8.74 .74(())
 ((88.74  ..74  -:&:-
((88.74   * Peace
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Remote printing in UniVerse release 10.1.3

[results]

I suggest that you set up a generic Text-to-file 'printer' and route to
it. If it doesn't get to the file, you know the printer itself isn't the
problem. If the generic text file does generate, I'd look to see if so
step is adding control chars which are affecting the printer.

-- 

Charles Barouch 

[EMAIL PROTECTED] - Consulting 

[EMAIL PROTECTED] - ETL/Migration/Integration 

(718) 762-3884x1 



Paul Hamrick wrote: 

> Can you lead me to some possible causes for the UniVerse job to not


> reach the printer? 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Remote printing in UniVerse release 10.1.3 {Unclassified}

[HENDERSON MIKE, MR]

Paul,

Generally speaking, you will need to set up the "printer" that UniVerse
sees with a 'Generic / Text Only' driver.
This will probably mean you need to set up two (or more) Windows
printers, pointing to the same physical device.  One is the 'real'
printer definition that you will use to print from Windows, the other(s)
are logical printers that are described to Windows as Generic / Text
Only and are used by UniVerse as its printing devices.  For each such
logical printer, you can allocate a 'Separator page' containing PCL
commands that will force the printer into a particular font, paper
orientation, input bin etc.
You can do all this from the Printer's Windows 'Properties' page,
'Advanced' tab.

HTH


Mike

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Paul Hamrick
> Sent: Wednesday, 10 August 2005 07:55
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Remote printing in UniVerse release 10.1.3
> 
> I have defined a remote Windows TCP/IP printer; in Windows I 
> can print a test print job fine. In UniVerse I executed the 
> SPOOL -LIST and see my defined Windows printer. I execute 
> SETPTR to defined printer and send a print job from TCL and 
> the job leaves UniVerse goes to the Windows spooler where it 
> exits clean as well, BUT DOES NOT PRINT at the printer.the 
> printer is a Panasonic DP-4530. 
>  
> So I can print in Windows, but from UniVerse application or 
> even from UniVerse TCL the job does not make it to the 
> printer! Remember my Windows test job prints fine. 
>  
> Can you lead me to some possible causes for the UniVerse job 
> to not reach the printer?
>  
> Paul Hamrick
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> 
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
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Remote printing in UniVerse release 10.1.3

[Paul Hamrick]

Charles, thank you.

I created the generic text-to-file printer and the print job went to the
Windows spooler but never prompted for Output Name, for example
d:\temp\prh, as did the Windows test print job which generated the job
to file fine. So the job never made it out of the Windows spooler on
this test.

I will verify this on a different machine printing from UniVerse to a
Windows defined FILE to see if this is machine specific.

Paul H.


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Tuesday, August 09, 2005 4:26 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Remote printing in UniVerse release 10.1.3

I suggest that you set up a generic Text-to-file 'printer' and route to
it. If it doesn't get to the file, you know the printer itself isn't the
problem. If the generic text file does generate, I'd look to see if so
step is adding control chars which are affecting the printer.

-- 

Charles Barouch 

[EMAIL PROTECTED] - Consulting 

[EMAIL PROTECTED] - ETL/Migration/Integration 

(718) 762-3884x1 



Paul Hamrick wrote: 

> Can you lead me to some possible causes for the UniVerse job to not


> reach the printer? 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Remote printing in UniVerse release 10.1.3

[Dave Taylor]

Paul,

Have you installed your remote printer using an lpr port on your Universe
server?

You must install remote printers using an lpr port so that they appear on
your Universe server to be installed on your Universe server, not simply as
remote printers connected to another computer on the network.

You can look  up "lpr" in the Windows Help to see how to create an lpr port
and then install a printer on it.

Let me know if you want more detail.

hth,

Dave

Dave Taylor
President
Sysmark Information Systems, Inc.
49 Aspen Way
Rolling Hills Estates, CA 90274
800-SYSMARK (800-797-6275)
(O) 310-544-1974
(P) 800-339-1497
(F) 310-377-3550
Your Source for Integrated EDI Translation and DataSync Integration
www.sysmarkinfo.com

- Original Message - 
From: "Paul Hamrick" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, August 09, 2005 12:55 PM
Subject: [U2] Remote printing in UniVerse release 10.1.3


> I have defined a remote Windows TCP/IP printer; in Windows I can print a
> test print job fine. In UniVerse I executed the SPOOL -LIST and see my
> defined Windows printer. I execute SETPTR to defined printer and send a
> print job from TCL and the job leaves UniVerse goes to the Windows
> spooler where it exits clean as well, BUT DOES NOT PRINT at the
> printer.the printer is a Panasonic DP-4530.
>
> So I can print in Windows, but from UniVerse application or even from
> UniVerse TCL the job does not make it to the printer! Remember my
> Windows test job prints fine.
>
> Can you lead me to some possible causes for the UniVerse job to not
> reach the printer?
>
> Paul Hamrick
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Limiting MV's in a list statement

[Bob Woodward]

Hi folks.



I'm trying to do a listing of a file that has a number of attributes
that are MV'ed and are associated, at least logically, and I'm wanting
to only display specific values.  Here's the command and layout for a
single item:



LIST PM ITEM.ID STATUS.FLAG CUBES TOTE.ITEM UOM



PM file

  Item.ID, Status.Flag, cubes, Tote.Item, UnitOfMeasure



  123430.2403 YEA

  4 0. YSP

  4 1.2044  CS

  4 4.8934  MP



What I'm wanting to get is this:



PM file

  Item.ID, Status.Flag, cubes, Tote.Item, UnitOfMeasure



  12343 0.2403 YEA

  4 0. YSP



I hope the formatting came out right for that.  I used courier font for
the spacing.  Anyway, I'm wanting to select based on the TOTE.ITEM field
with the selected value lines staying together.  I think that means I
need to first sort by the ITEM.ID then BY.EXP TOTE.ITEM but then how do
I limit the display to just those value lines that have the "Y" in
TOTE.ITEM?



I'm sure I've done something similar to this long, long ago.  I'm hoping
to avoid writing a program because this is going to be a one or two use
listing but I'm getting to the point that that may be faster.



TIA for any and all help offered.



Bob W

Harbor Wholesale Grocery
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] SSL, Datatel and UI question

[Chladek, Dave]

Is anyone using the Datatel UI product with ssh/ssl enabled? If so,
could I ask you a few questions?





Thanks,



Dave Chladek

Systems Administrator

North Harris Montgomery Community College District

http://www.nhmccd.edu 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2][UV] Real-time credit card verification

[John Hester]

Anyone know of a UV-based real-time credit card verification application?

TIA,
John
--
John Hester
System & Network Administrator
Momentum Group Inc.
(949) 833-8886 x623
http://memosamples.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Limiting MV's in a list statement

[rbl000]

Bob,

Without going to the trouble of properly defining your associated dictionary 
items, since you say this for a one or two use listing, try something like this:

SORT PM BY.EXP Tote.Item = "Y" Status.Flag cubes Tote.Item UnitOfMeasure

At least it works in my UV Pick flavor accounts.  The '= "Y"' would be called 
an explosion-limiter, and works very much like a print-limiter that can be 
applied to an individual 'column' being reported.

Richard B Lewis
Sr Programmer/Analyst
Nu Skin Enterprises
[EMAIL PROTECTED]

 --- On Tue 08/09, Bob Woodward < [EMAIL PROTECTED] > wrote:
From: Bob Woodward [mailto: [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Date: Tue, 9 Aug 2005 16:08:48 -0700
Subject: [U2] Limiting MV's in a list statement

Hi folks.I'm trying to do a listing of a file that has a number 
of attributesthat are MV'ed and are associated, at least logically, and I'm 
wantingto only display specific values.  Here's the command and layout for 
asingle item:LIST PM ITEM.ID STATUS.FLAG CUBES TOTE.ITEM 
UOMPM file  Item.ID, Status.Flag, cubes, Tote.Item, 
UnitOfMeasure  123430.2403 Y
EA  4 0. YSP
  4 1.2044  CS  4   
  4.8934  MPWhat I'm wanting to get is 
this:PM file  Item.ID, Status.Flag, cubes, 
Tote.Item, UnitOfMeasure  12343 0.2403 
YEA  4 0. Y
SPI hope the formatting came out right fo!
r 
that.  I used courier font forthe spacing.  Anyway, I'm wanting to select 
based on the TOTE.ITEM fieldwith the selected value lines staying together. 
 I think that means Ineed to first sort by the ITEM.ID then BY.EXP 
TOTE.ITEM but then how doI limit the display to just those value lines that 
have the "Y" inTOTE.ITEM?I'm sure I've done something 
similar to this long, long ago.  I'm hopingto avoid writing a program 
because this is going to be a one or two uselisting but I'm getting to the 
point that that may be faster.TIA for any and all help 
offered.Bob WHarbor Wholesale 
Grocery---u2-users mailing 
listu2-users@listserver.u2ug.orgTo unsubscribe please visit 
http://listserver.u2ug.org/

___
No banners. No pop-ups. No kidding.
Make My Way  your home on the Web - http://www.myway.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2][UV] Real-time credit card verification

[Scott Ballinger]

Try Fred Tuttle at Totalink.

/Scott Ballinger
Pareto Corporation
Edmonds WA USA
206 713 6006

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of John Hester
Sent: Tuesday, August 09, 2005 5:36 PM
To: U2 Users Discussion List
Subject: [U2][UV] Real-time credit card verification


Anyone know of a UV-based real-time credit card verification
application?

TIA,
John
-- 
John Hester
System & Network Administrator
Momentum Group Inc.
(949) 833-8886 x623
http://memosamples.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Limiting MV's in a list statement

[Allen E. Elwood]

Hi Bob,

You'd want to use the 'WHEN' clause.  This is used on multivalued sets to
limit stuff.

LIST PM ITEM.ID STATUS.FLAG CUBES TOTE.ITEM UOM WHEN TOTE.ITEM EQ 'Y'

hth!!!

Allen

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Bob Woodward
Sent: Tuesday, August 09, 2005 16:09
To: U2-Users List
Subject: [U2] Limiting MV's in a list statement


Hi folks.



I'm trying to do a listing of a file that has a number of attributes
that are MV'ed and are associated, at least logically, and I'm wanting
to only display specific values.  Here's the command and layout for a
single item:



LIST PM ITEM.ID STATUS.FLAG CUBES TOTE.ITEM UOM



PM file

  Item.ID, Status.Flag, cubes, Tote.Item, UnitOfMeasure



  123430.2403 YEA

  4 0. YSP

  4 1.2044  CS

  4 4.8934  MP



What I'm wanting to get is this:



PM file

  Item.ID, Status.Flag, cubes, Tote.Item, UnitOfMeasure



  12343 0.2403 YEA

  4 0. YSP



I hope the formatting came out right for that.  I used courier font for
the spacing.  Anyway, I'm wanting to select based on the TOTE.ITEM field
with the selected value lines staying together.  I think that means I
need to first sort by the ITEM.ID then BY.EXP TOTE.ITEM but then how do
I limit the display to just those value lines that have the "Y" in
TOTE.ITEM?



I'm sure I've done something similar to this long, long ago.  I'm hoping
to avoid writing a program because this is going to be a one or two use
listing but I'm getting to the point that that may be faster.



TIA for any and all help offered.



Bob W

Harbor Wholesale Grocery
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2][UV] Real-time credit card verification

[Robin Stanley]

With UV and AIX, we have been using SDC/protobase for many years - very 
successfully.

www.protobase.com

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of John Hester
Sent: Tuesday, August 09, 2005 5:36 PM
To: U2 Users Discussion List
Subject: [U2][UV] Real-time credit card verification


Anyone know of a UV-based real-time credit card verification application?

TIA,
John
-- 
John Hester
System & Network Administrator
Momentum Group Inc.
(949) 833-8886 x623
http://memosamples.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Limiting MV's in a list statement

[Bob Woodward]

Thanks Richard.

That's exactly what I needed.  And by adding BREAK-ON @ID, it even gives
me the grouping I need by PM ID.

Bob W
Harbor Wholesale Grocery


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:owner-u2-
> [EMAIL PROTECTED] On Behalf Of rbl000
> Sent: Tuesday, August 09, 2005 5:36 PM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Limiting MV's in a list statement
> 
> Bob,
> 
> Without going to the trouble of properly defining your associated
> dictionary items, since you say this for a one or two use listing, try
> something like this:
> 
> SORT PM BY.EXP Tote.Item = "Y" Status.Flag cubes Tote.Item
UnitOfMeasure
> 
> At least it works in my UV Pick flavor accounts.  The '= "Y"' would be
> called an explosion-limiter, and works very much like a print-limiter
that
> can be applied to an individual 'column' being reported.
> 
> Richard B Lewis
> Sr Programmer/Analyst
> Nu Skin Enterprises
> [EMAIL PROTECTED]
> 
>  --- On Tue 08/09, Bob Woodward < [EMAIL PROTECTED] > wrote:
> From: Bob Woodward [mailto: [EMAIL PROTECTED]
> To: u2-users@listserver.u2ug.org
> Date: Tue, 9 Aug 2005 16:08:48 -0700
> Subject: [U2] Limiting MV's in a list statement
> 
> Hi folks.I'm trying to do a listing of a file that has
a
> number of attributesthat are MV'ed and are associated, at least
> logically, and I'm wantingto only display specific values.  Here's
the
> command and layout for asingle item:LIST PM
ITEM.ID
> STATUS.FLAG CUBES TOTE.ITEM UOMPM file
> Item.ID, Status.Flag, cubes, Tote.Item, UnitOfMeasure
> 123430.2403 YEA
4
> 0. YSP  4 1.2044
> CS  4 4.8934
> MPWhat I'm wanting to get is this:PM
> file  Item.ID, Status.Flag, cubes, Tote.Item,
> UnitOfMeasure  12343 0.2403 Y
> EA  4 0. Y
> SPI hope the formatting came out right fo!
> r
> that.  I used courier font forthe spacing.  Anyway, I'm wanting to
> select based on the TOTE.ITEM fieldwith the selected value lines
> staying together.  I think that means Ineed to first sort by the
> ITEM.ID then BY.EXP TOTE.ITEM but then how doI limit the display
to
> just those value lines that have the "Y"
> inTOTE.ITEM?I'm sure I've done something similar
to
> this long, long ago.  I'm hopingto avoid writing a program because
> this is going to be a one or two uselisting but I'm getting to the
> point that that may be faster.TIA for any and all help
> offered.Bob WHarbor Wholesale
Grocery---
> u2-users mailing listu2-users@listserver.u2ug.orgTo
> unsubscribe please visit http://listserver.u2ug.org/
> 
> ___
> No banners. No pop-ups. No kidding.
> Make My Way  your home on the Web - http://www.myway.com
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2][UV] Real-time credit card verification

[Dave Taylor]

John,

Try www.total-computing.com.

Rgds,

Dave

Dave Taylor
President
Sysmark Information Systems, Inc.
49 Aspen Way
Rolling Hills Estates, CA 90274
800-SYSMARK (800-797-6275)
(O) 310-544-1974
(P) 800-339-1497
(F) 310-377-3550
Your Source for Integrated EDI Translation and DataSync Integration
www.sysmarkinfo.com

- Original Message - 
From: "John Hester" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" 
Sent: Tuesday, August 09, 2005 5:36 PM
Subject: [U2][UV] Real-time credit card verification


> Anyone know of a UV-based real-time credit card verification application?
> 
> TIA,
> John
> -- 
> John Hester
> System & Network Administrator
> Momentum Group Inc.
> (949) 833-8886 x623
> http://memosamples.com
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2][UV] Real-time credit card verification

[Kevin Roderick]

Actually Fred is with Total Computing Solutions (www.total-computing.com/) and 
the product is called TotaLink
 
Fred's contact info is ...
801-796-7600
[EMAIL PROTECTED]
 
 

-Original Message- 
From: [EMAIL PROTECTED] on behalf of Scott Ballinger 
Sent: Tue 8/9/2005 9:00 PM 
To: u2-users@listserver.u2ug.org 
Cc: 
Subject: RE: [U2][UV] Real-time credit card verification



Try Fred Tuttle at Totalink.

/Scott Ballinger
Pareto Corporation
Edmonds WA USA
206 713 6006

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of John Hester
Sent: Tuesday, August 09, 2005 5:36 PM
To: U2 Users Discussion List
Subject: [U2][UV] Real-time credit card verification


Anyone know of a UV-based real-time credit card verification
application?

TIA,
John
--
John Hester
System & Network Administrator
Momentum Group Inc.
(949) 833-8886 x623
http://memosamples.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Limiting MV's in a list statement

[Stevenson, Charles]

I'm surprised there are no answers yet.
The WHEN keyword is what you're looking for.
And you need to make sure the dictionary is set up right.


If ITEM.ID, STATUS.FLAG, CUBES, TOTE.ITEM, UOM are all D- or I- items,
then for each of them set
  <6> = M
  <7> = BOB.ASSOC
The same for any other fields that are truly associated.

and add a phrase to the dictionary:
 DICT PM BOB.ASSOC
  <1> PH defines the BOB association
  <2> ITEM.ID STATUS.FLAG CUBES TOTE.ITEM UOM

Then:

   LIST PM WHEN TOTE.ITEM = "Y" ITEM.ID STATUS.FLAG CUBES TOTE.ITEM UOM

& you can do things like:

   >SELECT PM BY @ID BY.EXP STATUS.FLAG BY.EXP CUBES WHEN TOTE.ITEM =
"Y"
   >>SAVE.LIST BOB
   >EDIT.LIST BOB <---this can be interesting.  
  look at the multivalues 
  embedded in the select list!

In a program you can activate one of these mv-lists and then use a
sophisticated form of READNEXT:

   LOOP
  READNEXT PM.ID, VALUE.POSITION ELSE EXIT
  IF ID # LAST.ID THEN
 READ PM.REC FROM PM.FILE, PM.ID ELS ...
 LAST.ID = ID
  END
  STATUS.FLAG = PM.REC< statflag.attrib, VALUE.POSITION >
  CUBE= PM.REC< cube.attrib, VALUE.POSITION >
  etc.
   REPEAT

If you don't want to modify (i.e., fix) the dictionary, take a look at
the keywords ASSOC, ASSOC.WITH, &  MULTIVALUED.


If the original dictionaries are Pick-style A- or S- items,
then attribute 4 says which attribute is "C"ontrolling or "D"ependent
and what the other members of the association are:

Field. Type F2 F3.. F4...

PART.NUM   S75 Part Number  D;76;77;78
PART.DESC  S76 Part description D;75
SCH.DATE   S77 Sch-Date D;75
QTYS78 Quantity D;75



Is the horse still kicking?
I'll flog it more if you want.

cds



> From: Bob Woodward
> 
> I'm trying to do a listing of a file that has a number of 
> attributes that are MV'ed and are associated, at least 
> logically, and I'm wanting to only display specific values.  
> Here's the command and layout for a single item:
> 
> 
> 
> LIST PM ITEM.ID STATUS.FLAG CUBES TOTE.ITEM UOM
> 
> 
> 
> PM file
> 
>   Item.ID, Status.Flag, cubes, Tote.Item, UnitOfMeasure
> 
> 
>   123430.2403  YEA
>   4 0. YSP
>   4 1.2044  CS
>   4 4.8934  MP
> 
> What I'm wanting to get is this:
> 
> PM file
> 
>   Item.ID, Status.Flag, cubes, Tote.Item, UnitOfMeasure
> 
>   12343 0.2403 YEA
>   4 0. YSP
> 
> 
> I hope the formatting came out right for that.  I used 
> courier font for the spacing.  Anyway, I'm wanting to select 
> based on the TOTE.ITEM field with the selected value lines 
> staying together.  I think that means I need to first sort by 
> the ITEM.ID then BY.EXP TOTE.ITEM but then how do I limit the 
> display to just those value lines that have the "Y" in TOTE.ITEM?
> 
> 
> 
> I'm sure I've done something similar to this long, long ago.  
> I'm hoping to avoid writing a program because this is going 
> to be a one or two use listing but I'm getting to the point 
> that that may be faster.
> 
> 
> 
> TIA for any and all help offered.
> 
> 
> 
> Bob W
> 
> Harbor Wholesale Grocery
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] New UV Accout VOC

[FFT2001]

In a message dated 8/9/2005 8:04:38 AM Pacific Daylight Time, 
[EMAIL PROTECTED] writes:


>   ED VOC FILENAME  
> 
> 1: F
> 2: FILENAME
> 3: D_FILENAME
> 
> 3.  Thus, further commentary would be appreciated.
> 
> --Bill

Bill these sorts of "F" pointers where attribute 2 is some short thing like
MONKEY001 instead of something long like D:\mydir\myotherdir\mymonkey

are relative path names.  The files they point at, must be present in the 
local directory of the account.
What you've done is copy the File Pointers, but not the files themselves.
For each of these files, you need to do a CREATE-FILE MONKEY or whatever the 
file is named.
That will allow you to create these files in a test location with sizes other 
than what production has.
If you want exact duplication of ALL data, then you can simply ACCOUNT-SAVE 
PRODUCTION
and then ACCOUNT-RESTORE SANDBOX or something like that.
   I think you might even be able to just copy the whole directory, but I've 
never actually done it that way myself.  In general, for a test account you 
don't really need files with a modulo of a hundred thousand and its pointless 
to 
create them and then have to DELETE-FILE and CREATE-FILE fifty times ... in 
my opinion.
   Creating a sandbox account isn't real easy.  You should have saved the 
headaches and just hired me ;)
Will Johnson
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/