Comments on: Copy DDS defined file to .txt filehttp://itknowledgeexchange.techtarget.com/itanswers/copy-dds-defined-file-to-txt-file/
Sun, 02 Aug 2015 08:47:57 +0000hourly1By: gachttp://itknowledgeexchange.techtarget.com/itanswers/copy-dds-defined-file-to-txt-file/#comment-52549
Mon, 31 Mar 2008 15:40:56 +0000#comment-52549It might be also that you have non displayable charaters in those text fields, try displaying their contents in hexadecimal format to see if in the places where a blank is displayed there is other code than X:40, maybe the problem is in the source.
]]>By: oldtonewhttp://itknowledgeexchange.techtarget.com/itanswers/copy-dds-defined-file-to-txt-file/#comment-52531
Fri, 28 Mar 2008 20:18:18 +0000#comment-52531Thank you for the response. There is nothing in the job log of any kind about the CPYTOIMP, error or otherwise. I tried using QRY400 and got the same results. I tried importing into Excel even though I knew it wouldn’t all fit and I tried importing into Access 2003. All attempts returned the same results. I think I will give them the DDS version of the file and let them worry about it.
]]>By: anchorshttp://itknowledgeexchange.techtarget.com/itanswers/copy-dds-defined-file-to-txt-file/#comment-52529
Fri, 28 Mar 2008 18:12:08 +0000#comment-52529Hi:

I’ve found you need to use different commands depending on the ccsid and/or file type (internal or extrenally defined). Try the cpytostmf (copy to stream file). This solved my most recent issue.

]]>By: it-danhttp://itknowledgeexchange.techtarget.com/itanswers/copy-dds-defined-file-to-txt-file/#comment-52528
Fri, 28 Mar 2008 16:25:15 +0000#comment-52528You can use Data Transfer from the iSeries (part of IBM client access). before you start the transfer click on file, properties and under the conversion tab make sure you check the “Convert CCSID 65535″ box.

1) Try using iSeries Access to download the file to text.
2) Try using the Client Access Data Transfer Add In to MS Excel
3) You could convert the data to text before sending it to the IFS:
Create a file with a unique field with the size of the record you are trying to convert and then concatenate character fields with casted-to-text-non-character fields into this new file and then try your original solution or one of the suggestions we give you here.