Skip to main content

PloadDelimitedSource does not log rejected data properly

  • August 22, 2013
  • 2 replies
  • 15 views

Shyam_Katti
It looks like PloadDelimitedSource is not as good with logging as COPY command is. We are running into scenarios where when we run the command: copy {table} with source PloadDelimitedSource(file='/home/dbadmin/bla.txt') delimiter E'\007' no escape direct; only the exception file is created, but there is no associated file which contains the actual rejected rows. when we run the command: copy {table} with source PloadDelimitedSource(file='/home/dbadmin/bla.txt') delimiter E'\007' rejected data '/home/dbadmin/copyerrors/' no escape direct; the file with the actual rejected rows is generated, but does not have the associated *-copy-from-exceptions file. Is it possible to enforce PloadDelimitedSource utility to work like COPY command and generate both the files ?

2 replies

Shyam_Katti
  • Author
  • New Participant
  • August 22, 2013
the first command should have just been: copy table with source PloadDelimitedSource(file='/home/dbadmin/bla.txt') delimiter '\\007' no escape direct; How can I edit my post?

David_Chen
Forum|alt.badge.img+1
  • Participating Frequently
  • January 21, 2015
It seems that COPY's REJECTED DATA and EXCEPTIONS clauses only work with "COPY LOCAL".

However, for most users, all COPY'ing occurs locally, and we need a way to get at REJECTED DAT Aand their corresponding EXCEPTIONS, even if other methods of loading data are being used, such as pload (PloadDelimitedSource)