In a previous Q&A, I asked about an end of file character met before physical end of file (when I tried to use commands like CPYFRMPCD or CPYFRMIMPF). I am not sure that I gave you all the details. It is the x'1A' and I found out it is an optional end of file. I read about some solutions found for this translation from ASCII to EBCDIC, but none of them uses this commands (CPY). Is there a way to avoid this character? Probably not the...
fastest method, but you could copy the stream data with CPY DTAFMT(*BINARY) to a document and then use the CPYFRMPCD command.
MORE INFORMATION ON THIS TOPIC
Search400.com's targeted search engine: Get relevant information on DB2/400.
The Best Web Links: tips, tutorials and more.
Check out this Search400.com Featured Topic: Database issues resolved
Dig deeper on DB2 UDB (universal databases)
Related Q&A from Kent Milligan
To monitor members stuck within a physical file on AS/400, you can periodically use the display file description (DSPFD) command to create an output ...continue reading
Create a host variable of the where in statement on the fly with dynamic SQL.continue reading
To solve the SQL error -321 on IBM i6.1, use the new values statement to overcome the error. If you are using an older release, declare a cursor ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.