Hi DS users,
I want to get max value from my last run sequential file for a field and i would like to assign the same to a variable in a parameter file so that when i run the job the nexttime, i will use that value in the source query where clause
eg) where batch_id > #batchid#
Assume i have loaded batchid 1,2,3 and nexttime when i run the job it should pick up 3 and i will extract records >3.
If any Datastage and Unix gurus are there let me know how to assign the same to a variable in a parameter file and use the same.
(The operating system is UNIX)
cheers,
gops
Assign value to a variable in a parameter file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Can you explain the following
1.) how is the date stored in your target file
2.) where did you include the mentioned command
3.) what error message did it return
4.) what do you mean by 'How to assign the output to a variable in a parameter file.'? Do you want to store the result as 'MaxDate = 20050513' in some parameter file? If yes, then what will this parameter file contain apart from this date?
1.) how is the date stored in your target file
2.) where did you include the mentioned command
3.) what error message did it return
4.) what do you mean by 'How to assign the output to a variable in a parameter file.'? Do you want to store the result as 'MaxDate = 20050513' in some parameter file? If yes, then what will this parameter file contain apart from this date?