Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Migrating AS400 to HIVE; Data type mapping for JAVA

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
sindhu.jose

New User


Joined: 15 Jul 2009
Posts: 1
Location: kochi

PostPosted: Tue Nov 06, 2018 1:06 pm    Post subject: Migrating AS400 to HIVE; Data type mapping for JAVA
Reply with quote

Hello Team,

We are currently migrating data from AS400 to HIVE tables, using JAVA code. Can someone help me with the corresponding JAVA data types, for all the AS400 Datatypes as mentioned in https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_71/rzakb/ldata.htm .

Confusing ones are (UTF-8, UTF-16, UCS-2, Open (O), Only (J), Either (E), Graphic (G)).

Any help is appreciated !!!

Thanks,
Sindhu
Back to top
View user's profile Send private message

Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8479
Location: Dubuque, Iowa, USA

PostPosted: Tue Nov 06, 2018 7:46 pm    Post subject:
Reply with quote

Quote:
Confusing ones are (UTF-8, UTF-16, UCS-2, Open (O), Only (J), Either (E), Graphic (G)).
I'm not sure what is confusing you -- the site you referenced states
Quote:
The data types J (only), E (either), O (open), and G (graphic) support DDS database files that use DBCS. The G (graphic) data type also supports DDS database files that use UCS-2 or UTF-16. The A (character) data type also supports database files that use UTF-8.
and since UTF-8, UTF-16, UCS-2 are forms of Unicode (which Java uses natively), you shouldn't have much of a conversion issue with them. The conversion table in the site you referenced tells you how to convert each type you are confused about.

Your group may have to undergo significant and expensive conversion processing to get the data from AS400 formats to something HIVE will recognize and deal with. The costs and time for this conversion should have been considered in the initial project planning.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to force ISPF to allocate ISPF te... Michele Giannuli TSO/ISPF 9 Thu Sep 12, 2019 2:03 pm
No new posts Need to fetch data from database base... Satandale COBOL Programming 8 Sun Sep 08, 2019 12:01 am
No new posts How to append data from PARM in OUTFIL Poha Eater DFSORT/ICETOOL 17 Thu Aug 22, 2019 4:03 pm
No new posts Training on numeric fields data formats sergeyken SYNCSORT 12 Thu Aug 01, 2019 8:15 pm
No new posts Can I use Tableau/PowerBI kind data a... rohanthengal All Other Mainframe Topics 2 Wed Jul 24, 2019 4:43 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us