« Textpad - search for lines with spaces | Main | Degreeworks - Mod for Post bac students and legend »
September 18, 2012
TZREDUD Table update
I made some changes to the external table TZREDUD (this is used by the e-disburse process). I added the following access parameters to the table:
lrtrim missing field values are null
REJECT ROWS WITH ALL NULL FIELDS
We received a file from the bank that had a string of whitespace at the end of each record and the rows were being rejected. We also had records that were blank (filled in with whitespace). These two parameters will filter those records out of the table.
Posted by soukupm at September 18, 2012 4:34 PM
Comments
Post a comment
Thanks for signing in, . Now you can comment. (sign out)
(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)