DSXchange: DataStage and IBM Websphere Data Integration Forum
  Home  •  Forum  •  Search  •  Favorites  •  Register  •  Log in
Usergroups  •  Contact  •  FAQ  •  Privacy Policy  •  Log in to check your private messages
get file date as column value
 View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Post new topic   Reply to topic    DSXchange Forum Index » IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)
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
View user's profile  Send private message  Send e-mail  
ray.wurlod

Premium Poster
Participant

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

Joined: 23 Oct 2002
Posts: 53946
Location: Sydney, Australia
Points: 292713
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
View user's profile  Send private message  Send e-mail  Visit poster's website
Rate this response: 0  1  2  3  4  5   
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
View user's profile  Send private message  Send e-mail  
Rate this response: 0  1  2  3  4  5   
Display posts from previous:       
Post new topic   Reply to topic    DSXchange Forum Index » IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)


 Jump to:   



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