Stop using UNICODE data type
I repeatedly need to upload spreadsheet content and create physical files on our V5R4 iSeries box. Each time I run the create-new-file wizard, it scans the source data and, if a character is encountered in a data row, it defaults the data type to UNICODE. I want it to default to CHARACTER. Is there a way to override this?
Software/Hardware used:
Software/Hardware used:
ASKED:
October 14, 2010 3:33 PM
UPDATED:
October 19, 2010 10:35 PM
Answer Wiki:
What's funny is, apparently when you initiate the upload wizard from an active 5250 emulator session, the scan returns alpha-numeric columns as "character". It's only when you run the wizard from the Excel add-in that the unicode defaults. Maybe the answer is to only run the upload wizard from the emulator session.
To see all answers submitted to the Answer Wiki: View Answer History.
That might be tricky since the spreadsheet data is almost certainly in Unicode. Why not use a Unicode setting if you’re actually creating new files? Perhaps some potentially minor configuration changes on your iSeries could make the data easier to use.
I don’t know of a way to change the default for the wizard. One might be found if necessary.
Tom
Thanks for your feedback Tom.
If working through the emulator session is satisfactory, then you could be fine.
But maybe you only need some basic data conversion after the upload. Once you have an example of a conversion, it might not look terrible. Are these mostly “upload” files or are you creating actual application files?
Tom