Hi,
We get daily file with change in date. Example:Today's file: FILE_NAME_20160225.txt.
I will be passing this as a parm in datastage job.
TodaysDate = Oconv(Date(), "DYMD[4,2,2]");
FileString1 = 'FILE_NAME_':TodaysDate:'.txt'
I am getting date in YYYY/MM/DD format instead of YYYYMMDD format.
The above code returns: FILE_NAME_2016/02/25.txt.
Please let me know how to get the right formatted date: FILE_NAME_20160225.txt.
Thanks!!
Adding date parameter to batch file
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 32
- Joined: Mon Apr 12, 2010 3:42 pm
- Location: Minneapolis
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
Oconv(Date(), "DYMD[4,2,2]" : @VM : "MCN")
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.
-
- Premium Member
- Posts: 32
- Joined: Mon Apr 12, 2010 3:42 pm
- Location: Minneapolis
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 32
- Joined: Mon Apr 12, 2010 3:42 pm
- Location: Minneapolis
- Contact: