Stop using UNICODE data type

30 pts.
Tags:
IBM iSeries
iseries v5r4
Unicode
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    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
    125,585 pointsBadges:
    report
  • BradBradley
    Thanks for your feedback Tom.
    30 pointsBadges:
    report
  • TomLiotta
    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
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following