Re: DB2 Control Center: Is that for DB2 on IBM i also?

Okay. Never mind. Just tried the export myself and it apparently uses CPYTOIMPF under the covers. Opening the exported file (even using PCASCII) in Excel shows the results as utter garbage.

Just stick to Run SQL Scripts... and export from there.

"Contrariwise, if it was so, it might be; and if it were so, it would be; but as it isn't, it ain't. That's logic."--Tweedledee
On 11/21/2013 8:50 AM, Robert Clay wrote:

Rob,

I'm using System i Navigator in IBM System i Access for Windows V6R1, SI42323. I see an option to export the table.

{your system}
--Databases
----{your database}
------Schemas
--------{your schema}
----------Tables
------------{your table} <--click to select

Right-click and select Data-->Export...

This opens a wizard that appears to do a SELECT *... under the covers. Granted, it does export by default to the IFS but you can always set up a share and navigate to it via /QNTC.

I don't know if this functionality has been deprecated in IBM i Access 7.1 because I don't have visibility to that product but it's worth a shot if that's what you're using.

Robert
"Contrariwise, if it was so, it might be; and if it were so, it would be; but as it isn't, it ain't. That's logic."--Tweedledee