DW don't get ending space characters from a stored procedure
Posted on 2004-04-05
I have a DW based on an stored procedure that have 20 space characters at the end of some rows I need to send in a file to a Bank (so its mandatory to send them).
Running in Sybase (RapidSQL) I see the 20 chars after execute my sp but in DW painter I retrieve same sp and the 20 space chars are not there !!!
What do I need to do to keep those space characters in my DW in order to save them in bank's file?
Thank you for any clue.