Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Location
    UK
    Posts
    1

    Unanswered: Export missing field info

    Hi,

    when doing an export to a file of del and using a select * from a table I am finding that all the records have exported but some of the fields have no data. The fields are defined as VARCHAR. I tried to export as filetype ixf and wsf but could not read these properly. Any ideas ?

  2. #2
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    File Types

    Hi,

    I am sorry to ask but do the fields contain data. If the fields contain varchar data then they are exported with the data in ' ' single quotes and if you feel that select * does not work then try selecting the columns explicitly, though I see no reason why it should not work. Export to a csv format and open the csv with excel. This would satisfy your doubt.

    Please note that the IXF file is native to DB2 and hence you will never be able to read the contents of the exported file.

    The WSF file is for work sheet format and relates to Lotus however the same can be opened in excel.

    Hope that gives you some clues.

    Nitin.

  3. #3
    Join Date
    Jul 2001
    Location
    Bangalore, India
    Posts
    28
    Hi,
    Also WSF format has limitation in terms of number of rows you can export, If I remember correctly, you can't export beyond 2048 rows in WSF format.
    Reg
    Ravi

Posting Permissions

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