DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Author Message
deesh
Participant



Joined: 08 Oct 2007
Posts: 179

Points: 1790

Post Posted: Mon Apr 10, 2017 9:49 pm Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi,

I have a scenario like source file include date like ABCD10112016.dat . I need to derive that file date value '10112016' for one of the target field.

Could you help how to reach, Moreover will get multiple files same day with different dates.

1job source files:

ABCD09112016.dat
ABCD10112016.dat
ABCD11112016.dat
ABCD12112016.dat
ABCD13112016.dat

2job source files:
EFGH09112016.dat
EFGH10112016.dat
EFGH11112016.dat
EFGH12112016.dat
EFGH13112016.dat
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 53980
Location: Sydney, Australia
Points: 292863

Post Posted: Tue Apr 11, 2017 5:13 am Reply with quote    Back to top    

Assuming that the file name is a job parameter, you can manipulate that. For example Code: Convert(Convert("0123456789", "", jpFileName), "", jpFile ...

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
deesh
Participant



Joined: 08 Oct 2007
Posts: 179

Points: 1790

Post Posted: Wed Apr 19, 2017 11:42 am Reply with quote    Back to top    

Achieved by the file name column property in sequential file stage
Rate this response:  
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours