Error in the response of a webservice
Error in the response of a webservice
I see the output in this way.....
nique_row_id><reason>Name,������������</reason><first_nm xsi:nil="
and the below error
java.io.IOException: Character reference "�" is an invalid XML character
the output has to be only Name....but I see all the other characters....which results to error...
Do I need to change anything?
nique_row_id><reason>Name,������������</reason><first_nm xsi:nil="
and the below error
java.io.IOException: Character reference "�" is an invalid XML character
the output has to be only Name....but I see all the other characters....which results to error...
Do I need to change anything?
Thanks,
Surya
Surya
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You have a data type CHAR in your data, which DataStage has padded with the default string pad character 0x00 because of how the environment variable APT_STRING_PADCHAR has been set.
Either change the data type to VARCHAR and trim it, or specify " " as the pad character for CHAR data type.
Either change the data type to VARCHAR and trim it, or specify " " as the pad character for CHAR data type.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
One additional note....I had a funny thing happen once with this variable where I had to set it to a single space.....with no quotes.....to get it to work.
Ernie
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
hex 40's are mainframe EBCDIC blanks... you probably want hex 20's (ASCII blanks). Or just use a single space in the display editor. Internally it should be a hex 20.
Ernie
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
see what happens if you use varchar on the final link instead...perhaps trimming it beforehand if necessary. You will have to redeploy the application.
Ernie
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>