View previous topic :: View next topic
|
Author |
Message |
karthik_sripal
New User
Joined: 28 Mar 2008 Posts: 69 Location: 125.16.180.5
|
|
|
|
My input file1 will be like
Code: |
SELECT * FROM
TABLE1
WHERE DATE > &TEMPDATE
|
and my input file2 will be like
and i want my output file to be like
Code: |
SELECT * FROM
TABLE1
WHERE DATE > 2009-04-01
|
and i want to do this via sort |
|
Back to top |
|
|
karthik_sripal
New User
Joined: 28 Mar 2008 Posts: 69 Location: 125.16.180.5
|
|
|
|
Ashish Ranjan wrote: |
Use below piece of code:
Code: |
SORT FIELDS=(st_pos_of_date,10,CH,A)
INCLUDE COND=(st_pos_of_date,10,CH,GT,C'2009-04-01') |
|
thanks ranjan for the quick reply .
Am using a similar approach currently!!
The thing is i dont want to edit my sort card evry time i wanna change my date. that is the reason why i kept the date in another file .
so in nutshell i want my date to be in seperate file and not sort card.
please correct me if am missing anything.
thnks again |
|
Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
There are several examples of how to build sort control statements in one step to be used in a second step.
The poorly titled Can this be done in DFSORT is one example. |
|
Back to top |
|
|
Skolusu
Senior Member
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
|
|
Back to top |
|
|
|