Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2004
    Posts
    27

    Unanswered: defncopy question

    Greetings,

    I am trying to work with defncopy. I am using the following UNIX command structure. defncopy -S -U -P out filename dbname objectnme. As a result, this only creates a file with the following text:

    /* ### DEFNCOPY: END OF DEFINITION */

    I do not see any schema within the file. Any help would be appreciated.

    Patrick Quinn
    Navigant Sybase Database Administrator

  2. #2
    Join Date
    Sep 2002
    Location
    Sydney, Australia
    Posts
    255
    Since you have a DEFNCOPY header in the output file, it would appear that defncopy ran, so check for typos in <dbname> and <objectname> and ensure the -U<user> has permission to access that <object> in that <dbname>.

    Sybase Central is a lot nicer to use.
    Derek Asirvadem
    Senior Sybase DBA/Information Architect derekATsoftwaregemsDOTcomDOTau
    Anything worth doing is worth doing Right The First Time
    Spend your money on standards-compliant development or spend 10 times more fixing it

  3. #3
    Join Date
    Dec 2004
    Posts
    25
    also ensuer that the object is a SP

  4. #4
    Join Date
    Sep 2002
    Location
    Sydney, Australia
    Posts
    255
    AFAIK, defncopy is the older util (retained for backward compatibility) and works for rules, triggers, views, defaults and stored procs but not for tables. ddlgen is the ANSI-compliant util that operates on all objects including tables of all types.
    Derek Asirvadem
    Senior Sybase DBA/Information Architect derekATsoftwaregemsDOTcomDOTau
    Anything worth doing is worth doing Right The First Time
    Spend your money on standards-compliant development or spend 10 times more fixing it

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •