Solved

how to use defncopy?

Posted on 1997-09-02
1
1,921 Views
Last Modified: 2012-05-04
I am trying to use "defncopy to copy out | in the view, rules, default and triggers from one database to another.

for example
defncopy -Usa -P out /tmp/pb_cattbl.dcopy hf_prod pb_cattbl

What' wrong for the above statement?
0
Comment
Question by:edward97
1 Comment
 
LVL 2

Accepted Solution

by:
Srw earned 50 total points
ID: 1098019
Your syntax appears fine.
Without knowing what exactly the problem is, it's hard to help, but...

1. Maybe the /tmp directory doesn't exist or have enough space.
2. If you're running this on a workstation, you may need to include the -S option (server name).
3. I'm sure you checked this one, but perhaps the DB name or object name is misspelled.
4. The Sybooks help says that defncopy won't work with objects created with Report Workbench
5. I'm just guessing, but pb_cattbl looks like a powerbuilder utility object.  You may not need to copy it.  Just get PB to create a new one.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SyBase SQL Syntax 5 663
Sybase - CronJob schedule 2 604
See the Access level(Read, Write, etc.) in Sybase databases 5 669
SQL Syntax 10 78
Many businesses neglect disaster recovery and treat it as an after-thought. I can tell you first hand that data will be lost, hard drives die, servers will be hacked, and careless (or malicious) employees can ruin your data.
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question