Hi
I use CFF (Complex Flat File) to populate a MS SQL DB with hundreds of CFF files. The issue I have is that the CFF use a Character native data type for string values and the trailing blanks are not trimmed automatically.
Options I have is to use the Datastage TRIM function or set ANSI_PADDING OFF on the MS SQL table. There are too many columns to implement the TRIM function. The ANSI_PADDING OFF setting is set to be discontinued for future SQL Server releases.
Any other option I can use?
thank you
Jaco
Complex Flat File trimming trailing blanks
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard.
Using a Transformer stage, select all the columns that need to be trimmed, right click, and choose Derivation Substitution from the menu. Type Trim($1) into the expression field. All done.
Using a Transformer stage, select all the columns that need to be trimmed, right click, and choose Derivation Substitution from the menu. Type Trim($1) into the expression field. All done.
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.