Chan Rana
Legendary Poster
I am having an issue with the function B1300040 which i am using to process my flat file record(which is delimited by , or |) to retrieve fields(segments). From my research i ended up with finding that all String Parse functions designed by Oracle(in my TR) are having limitation that they return next non blank segments if your current segment is empty.
For e.g. if your record is
1000|String|||UOM
Function will run correctly for first two segments returning 1000 & String respectively for segment 0 & 1. For Segments 2 & 3 it will return UOM instead of blank.
I am followed up with Oracle and have got answer that there is no fix for this issue and function works as designed.
I am sure that there are many clients who process the flat file so want to know if they ever faced this issue and if they had to built a custom function for this or used TC to overcome this issue.
Any inputs are appreciated.
Chan
E1 8.12 TR 8.97.12 AS/400 DB2
For e.g. if your record is
1000|String|||UOM
Function will run correctly for first two segments returning 1000 & String respectively for segment 0 & 1. For Segments 2 & 3 it will return UOM instead of blank.
I am followed up with Oracle and have got answer that there is no fix for this issue and function works as designed.
I am sure that there are many clients who process the flat file so want to know if they ever faced this issue and if they had to built a custom function for this or used TC to overcome this issue.
Any inputs are appreciated.
Chan
E1 8.12 TR 8.97.12 AS/400 DB2