Hello,
If I set the APT_STRING_PADCHAR=0x20 then it pads spaces to the character and varchar type columns as well. This is causing quite a bit of issue, because I want only the character columns to be padded with spaces. The varchar type columns are long and consume lot of space if padded with spaces.
How can I get around it other than setting the APT_STRING_PADCHAR =<empty> and padding spaces to the char type cols in the transformer? Is there a bug in the variable? Does anyone know if IBM has a patch?
APT_STRING_PADCHAR - Varchar datatype
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 87
- Joined: Mon Feb 18, 2008 3:58 pm
- Location: Sacramento, CA
We had this same problem when creating an XML Out message. The message was built into a large varchar field. It padded spaces to the end of the length of the varchar field. We reported it to IBM and they confirmed it was a bug and submitted it to be fixed in a future patch. This was about 4 months ago but I have not been notified that it has been fixed. They did supply a work-around: Remove the field length on the varchar field(s). It will then be unbounded and will not be padded with spaces. This worked fine for our needs.
-
- Premium Member
- Posts: 278
- Joined: Wed Oct 03, 2007 8:45 am
-
- Participant
- Posts: 89
- Joined: Sat Jul 24, 2010 11:33 pm
Can you please explain about this parameter
Hi,
Im new to this and I dnt know when to use this parameter, Can you please let me know how does it work.
Im new to this and I dnt know when to use this parameter, Can you please let me know how does it work.