Loading Binary Data into DB2 using DataStage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 7
- Joined: Thu Sep 14, 2017 2:26 am
Loading Binary Data into DB2 using DataStage
Hello Experts,
We have a requirement where in there is a table in DB2 or a source file that has Binary data(16bit). This needs to be loaded into another DB2 table to a binary 16 bit column. We need to get this done using DataStage.
We tried using different data types to load. Still we could not.
Can someone let us know how to get this done ?
Regards
Ramesh R
We have a requirement where in there is a table in DB2 or a source file that has Binary data(16bit). This needs to be loaded into another DB2 table to a binary 16 bit column. We need to get this done using DataStage.
We tried using different data types to load. Still we could not.
Can someone let us know how to get this done ?
Regards
Ramesh R
-
- Participant
- Posts: 7
- Joined: Thu Sep 14, 2017 2:26 am
Ramesh's sample data prompts me to ask: where are you converting to or from EBCDIC and ASCII?
Review all your read/write attributes. I'm guessing this is a character set issue, not the format of the data stream.
See my signature line for using mainframe data FAQ link.
Review all your read/write attributes. I'm guessing this is a character set issue, not the format of the data stream.
See my signature line for using mainframe data FAQ link.
Franklin Evans
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
-
- Participant
- Posts: 7
- Joined: Thu Sep 14, 2017 2:26 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 7
- Joined: Thu Sep 14, 2017 2:26 am
Yes. You are correct. We to get 36 bit out of UUID. But the requirement from client is to make it 16bit Binary inside the Database and for the first time the Java code generates the UUID , converts it into 16bit binary data and loads intot the table. When we need to read the data or write to some other table or file, we are unable to do.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: