Precisely Speaking
May 21, 2012, 07:00:41 PM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: So what's news with you?  Tell us about it in "Getting To Know You"!
 
   Home   Help Calendar Login Register  
Pages: [1]   Go Down
  Print  
Author Topic: How do you Copy a list of data items  (Read 517 times)
DonQuixote
Rock Star
*****
Posts: 108


To Dream the Impossible Dream...


« on: February 03, 2011, 05:06:04 PM »

I'm not sure if its PRC or Prelude or Unidata or what is causing the problem but I have a select list of CUSTOMER records that I need to copy to a work file. 
At real TCL I've tried:   
GET-LIST  listname
COPY CUSTOMER <cr>
TO:    (wrkfile  <cr>

nothing is copied.  Any ideas?
Logged
Tom Pellitieri
Rock Star
*****
Posts: 171


Tom Pellitieri - Toledo, Ohio


« Reply #1 on: February 04, 2011, 06:57:22 AM »

This may seem silly, but are you sure your list is right?  Try this:

GET-LIST listname
SELECT CUSTOMER  <-- Make certain your list has customer items
COPY CUSTOMER

Alternatively, try copying a specific customer, e.g.:

COPY CUSTOMER 001000COD

--Tom
Logged
DonQuixote
Rock Star
*****
Posts: 108


To Dream the Impossible Dream...


« Reply #2 on: February 04, 2011, 10:47:45 AM »

I can appreciate the skepticism since it just seems so simple.
Yes, I'm in real TCL.  I get the list and list the file; so the list is real and the items are in the file.
In the back of my little mind I remember Kevin saying that some (what seems) obvious commands are no longer 'real' and are wrapped in some creation of Prelude.  And the 'real' commands now have different names.  I don't know if this is one of them.
Logged
Tom Pellitieri
Rock Star
*****
Posts: 171


Tom Pellitieri - Toledo, Ohio


« Reply #3 on: February 04, 2011, 12:15:07 PM »

You can check your command by examining the VOC entry.  If you enter:

AE VOC COPY

you should see a two attribute item.  Attribute 1 = "V", Attribute 2 = "COPY".  If you have something else, you're not using the real COPY command.  It's possible that someone created a BASIC program called COPY and compiled it.  Prelude has set the compiler to automatically catalog all programs.  You might also check the xxPROCESS (e.g., DEVPROCESS) file for an entry called COPY - there should not be one.

Also, from the SB+ TCL prompt, most UniData commands use Pick style parameters when entered in upper case.  The lower case version lets you use UniData style parameters.  For example, I could use:

SELECT ORDER.HISTORY WITH INV.DATE = "02/03/11"
select ORDER.HISTORY SAVING UNIQUE CUST.NUM

to get a list of all of the customers who were invoiced on 2/3/11.
Logged
DonQuixote
Rock Star
*****
Posts: 108


To Dream the Impossible Dream...


« Reply #4 on: February 04, 2011, 05:18:11 PM »

Thank you. In my case COPY was a PRC created VOC entry, that I would guess should have worked as I expect but is not.  The original COPY command is now named OS.COPY.
Logged
Pages: [1]   Go Up
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.7 | SMF © 2006-2008, Simple Machines LLC Valid XHTML 1.0! Valid CSS!