Hi,
I haveseven fields in source and i want to use only last five fields .
I saw a roperty coltoignore in datsatge help in which we can define numer of character to ignore while defining the schema .
As my file is comma separated file and do not have fixed width , i want to pad # if field length is less than to tal length of first two fields .
Source File
plmn,abc,Joe,LKO,JMathur,Physics,100
klmn,ab,Meera,LKO,MMathur,Chemistry,500
Col1 can have maximum value of 3 chars and col 2 can have maximum value of 3 chars ,So i defined partial schema as follow:
record {intact=details,final_delim=end,record_delim_string="\r\n"}
(
colstoignore: string {Width=8,PadChar='#',delim=','};
v1: string {delim=','};
v2: string {delim=',' };
Name: string {delim=','};
v3:string {delim=','};
Income: int32 {delim=none};
)
But this is not working . It si not padding the # for second row as it has total length of two fields a s 7 .
Please guide me on how can w e pad characters in partial schema for a column .
How to pad chars in partial schema file
Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett, rschirm, roy
Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”
Jump to
- Moderators' Choice
- ↳ Editor's BLOG Corner
- ↳ Ask the Experts! - Dads and Grads
- ↳ DSXchange Testimonials
- ↳ Cognos (IBM BI)
- FAQs
- ↳ FAQs
- ↳ FAQ Discussion
- DataStage
- ↳ General
- ↳ IBM<sup>®</sup> Infosphere DataStage Server Edition
- ↳ IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- ↳ Archive of DataStage Users@Oliver.com
- IBM<sup>®</sup>Infosphere Products<sup></sup>
- ↳ Business Glossary
- Suggestions
- ↳ Site/Forum
- ↳ Enhancement Wish List
- Consulting
- ↳ Talent
- ↳ Looking for Talent
- Support
- ↳ Parameter Manager
- ↳ Compile All Plus
- Usergroup Forums
- ↳ Usergroup Central Forum
- ↳ Heartland Usergroup Forum
- The Written Word
- ↳ Articles, White Papers and Tips and Tricks
- ↳ Product Documentation
- Third Party Applications
- ↳ Third Party Applications
- Product Derivatives
- ↳ Functions
- ↳ Routines
- ↳ Jobs
- ↳ Logs
- Tools
- ↳ Tools Forum
- Category
- ↳ Infosphere Master Data Management
- ↳ Data Quality Best Practices
- ↳ IBM QualityStage
- ↳ Information Analyzer (formerly ProfileStage)
- ↳ IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- ↳ IBM<sup>®</sup> DataStage TX
- ↳ BI
- ↳ Data Integration