×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Kyle,
I used IBM i Access Client Solutions to run this. In my setup I changed the JDBC configuration to turn on 'Translate 65535'.
Then I used this
values 'data1' concat X'05' concat 'data2';
I tend to prefer concat over || as the two vertical bars may get translated to something else on foreign character sets.
It "appears" as if there's no character between data1 and data2 to the naked eye but it's there
If I had stored this into a table I could have used the 5250 command DSPPFM to display the raw contents. Then I could have used the appropriate function key to display the data in hex.
Here, if I want to see the raw hex I can simply do this:
values hex('data1' concat X'05' concat 'data2');
This displayed this: 8481A381F1058481A381F2
84=d, 81=a, A3=t, F1=1, 05=tab, F2=2
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_74/db2/rbafzch2tok.htm
Now let's create a table like this.
create table rob.dm3 (
mycol char(30)
);
insert into rob.dm3 values('data1' concat X'05' concat 'data2');
Then I used iACS Transfer to bring that down to my PC.
Opened it up in Notepad and the tab was there.
Got out of Notepad. Opened up Excel and told it to look at *.* files. Found the file. Opened it and stepped through the Wizard and told it the file was tab delimited and it properly put data1 and data2 into separate columns.
QED
Rob Berendt
midrange.com
