[Info-Ingres] Need Some Help

[Puneet Bagoria]

Hi,
I am using copy command to dump data to a flat text file , something like
shown below


copy table test  (title=varchar(0)'|',author=varchar(0)'|',
owner=varchar(0)'|',subject_expert=varchar(0)'|',start_date=char(0)'|',
expiration_date=char(0)'|',problem=long varchar(0)'|',resolution=long
varchar(0)'|',summary=varchar(0)'|',notes=long
varchar(0)'|',hits=char(0)'~')into
'd:Input.txt'

the output that is retrieved is something like this

*15Escrow Accounts*|*12admin, admin*|*12admin, admin*|*12admin,
admin*|37272.621|0.000|80
What is an Escrow Account and how does it protect both the seller
Some records(highlighted in bold ) have got integers , which actaully are
not present in the database record .

Like my actaull records is Escrow Accounts but in text file its shown as
15Escrow Accounts

Can any one tell me what is the problem and solution to this.

Thanks,
Puneet
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.kettleriverconsulting.com/mailman/private/info-ingres/attachments/20070314/5e8bb8ab/attachment.html