[Download-List] DOWNLOAD the DICT

[Pat Minatra (DataTel)]

This works GREAT with no problems.  Had to be root to do the COPY FROM
DICT.DICT 'CONV','XCONV' and so on.  Then, did the download and it works
GREAT!

Thanks so much for all the help.

Have a GREAT CHRISTMAS one and all!

-------------------------
"Life is but a twinkle in the eye of eternity"
"The shortest distance between a problem and a solution is the distance
between your knees and the floor"
"sorrow looks back - worry looks around - faith looks up"
Regards,
Pat H. Minatra - N5GJR
(325) 670-5804 voice
(325) 670-1570 fax
Hardin*Simmons University  
www.hsutx.edu
PO BOX 16040
Abilene, TX  79698


-----Original Message-----
From: David L. Rotman [mailto:ROTMAND at cedarville.edu] 
Sent: Thursday, December 18, 2003 7:28 AM
To: download-list at cedarville.edu
Subject: RE: [Download-List] DOWNLOAD the DICT


Using CONV or FORMAT will cause problems, because these are
keywoards for DOWNLOAD.

One work around is to create alternate names in DICT.DICT:
COPY FROM DICT.DICT 'CONV','XCONV'
COPY FROM DICT.DICT 'FORMAT','XFORMAT'

Then,
SELECT DICT CUSTOMER
DOWNLOAD DICT CUSTOMER @ID LOC XCONV XFORMAT ...

You will likely need to be root to execute the COPY commands
on DICT.DICT.



Dave Rotman
Director of Computer Services
Cedarville University
251 N. Main Street
Cedarville, OH 45314
rotmand at cedarville.edu
voice 937-766-7905
fax 937-766-8819

>>> minatrae at hsutx.edu 12/18/2003 8:12:26 AM >>>
Well, one more thing on this.

This gets me the @ID and the LOC; however when I try to get ALL the
fields in the DICT it will not allow that.  Any way around this?

Example, when I do a LIST DICT to my video I get:
-----start snip
LIST DICT PERSON BY TYP BY @ID TYP LOC CONV NAME FORMAT SM ASSOC
07:11:25 Dec 18
 2003 1
@ID............ TYP LOC.......... CONV NAME........... FORMAT SM
ASSOC.....
-----end snip

Now, if I want to include the NAME or CONV or FORMAT, I can't seem to
get it to allow me to do that.  Any suggestions?

Thanks so much.

  "The shortest distance between a problem and a solution is the
distance between your knees and the floor"
"sorrow looks back - worry looks around - faith looks up"
Regards,
Pat H. Minatra - N5GJR
(325) 670-5804 voice
(325) 670-1570 fax
Hardin*Simmons University  
www.hsutx.edu 
PO BOX 16040
Abilene, TX  79698


-----Original Message-----
From: Pat Minatra (DataTel) 
Sent: Thursday, December 18, 2003 7:00 AM
To: download-list at cedarville.edu 
Subject: RE: [Download-List] DOWNLOAD the DICT


With one minor change this works for us.  The change is