>I'm on an SQR upgrade team from PeopleSoft 8.0 to 8.3. I've had some interesting results between the output from SQRW on NT and when I run the exact same report from PeopleSoft 8.3 on our Unix box. Fields in the database with trailing spaces seem to be automatically RTRIMed in comparison tests (ie EMPLID = '123456789')
Sorry, yahoo just did something weird...anyway, a command like "let $workphone = substr(rpad($phone,24,' '),1,24)" should give me a 24-character field padded with spaces but the result is being RTRIMed in my output file from PeopleSoft (on Unix). It looks perfect in the flat file generated by SQRW on my PC. The program uses the "string" command to concatenate a list of fields before writing the line (and the workphone field is in the middle of the string), could that be it? When I run the same file from SQRW 6.1.4 and PeopleSoft 8.0, I also get the RTRIMed value. I was also having problems in comparison tests within the SQR too (like 'if $BENEFIT_PLAN = '2XBAS' would fail because the database returned '2XBAS ' from the query)...I didn't have to RTRIM in PeopleSoft 8 before doing the compare and it would pass the test. The data looks exactly the same in the databases 8.0 and 8.3 (fieldvalue = '2XBAS ')
Weird, huh? Any help would be appreciated, thanks, -Bonnie
--- Begin Message ---
- Subject: Difference in processing between SQRW/NT and PsoftProcSched/Unix (trailing spaces in fields)
- From: Bonnie Torkko <bontaur@yahoo.com>
- Date: Thu, 9 May 2002 15:49:35 -0700 (PDT)
I'm on an SQR upgrade team from PeopleSoft 8.0 to 8.3. I've had some interesting results between the output from SQRW on NT and when I run the exact same report from PeopleSoft 8.3 on our Unix box. Fields in the database with trailing spaces seem to be automatically RTRIMed in comparison tests (ie EMPLID = '123456789')
Do You Yahoo!?
Yahoo! Shopping - Mother's Day is May 12th!--- End Message ---