I'm definitely not an expert, but ... COPY DTALPTRSET '4.2.6.4*KYOCERA','4.2.6.3*KYOCERA' '4.2.6.4*PCL5','4.2.6.3*PCL5' (D
Will copy 4.2.6.4*KYOCERA to 4.2.6.3*KYOCERA then delete 4.2.6.4*KYOCERA and then copy 4.2.6.4*PCL5 to 4.2.6.3*PCL5 and delete 4.2.6.4*PCL5 Or CNAME DTALPTRSET '4.2.6.4*KYOCERA','4.2.6.3*KYOCERA' '4.2.6.4*PCL5','4.2.6.3*PCL5' Will change the name of (rename) the record ID 4.2.6.4*KYOCERA to 4.2.6.3*KYOCERA and 4.2.6.4*PCL5 to 4.2.6.3*PCL5 You need to separate the original ID and the new ID with a comma if you are copying to the same file. Also, surround the Ids with quotes to force a literal name. If the ID is just letters or numbers, you usually do not need the quotes. But when using certain characters (and the asterisk is one of them), you need them or UniData balks. HTH Tim Bryant ERP Support Manager CardioDynamics Int'l Corp 800.778.4825, Ext. 1087 858.535.0202 Ext. 1087 fax: 800.856.3038 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Tuesday, March 06, 2007 6:24 PM To: U2 Mail List Subject: [U2] UniData ECL anomolies I've been tripping over this ever since converting D3 applications to UniData. 2 Demo (0)-> COPY DTALPTRSET 4.2.6.4*KYOCERA 4.2.6.4*PCL5 (D TO: 4.2.6.3*KYOCERA 4.2.6.3*PCL5 4.2.6.4 is not in file DTALPTRSET *KYOCERA is not in file DTALPTRSET 4.2.6.4 is not in file DTALPTRSET *PCL5 is not in file DTALPTRSET 0 records copied 2 Demo (0)-> COPY DTALPTRSET '4.2.6.4*KYOCERA''4.2.6.4*PCL5' (D In E:\DataTrust\DTA\BP\BP\_TCL.SHELL at line 1021 COPY DTALPTRSET '4.2.6.4*KYOCERA''4.2.6.4*PCL5' (D In E:\DataTrust\DTA\BP\BP\_TCL.SHELL at line 1021 ---------------------------------^ In E:\DataTrust\DTA\BP\BP\_TCL.SHELL at line 1021 syntax error 2 Demo (0)-> SELECT DTALPTRSET '4.2.6.4*KYOCERA''4.2.6.4*PCL5' 2 records selected to list 0. 2 Demo (0)>> COPY DTALPTRSET (D TO: 4.2.6.3*KYOCERA 4.2.6.3*PCL5 get id's from select list:4.2.6.4*KYOCERA(Y/N)?Y 2 records copied 2 Demo (0)-> Have I missed some kind of configuration here or does UniData do this on purpose? As always, thanks. Bill Haskett ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
