View previous topic :: View next topic
|
Author |
Message |
Help-Me-Out
New User
Joined: 09 Dec 2006 Posts: 56 Location: Pune
|
|
|
|
Hi,
I need to unload the data from the table for the current date. I need the data by compairing some table fields e.g.
Code: |
SELECT A.ACCT, A.DATE_START
FROM BAL A
WHERE A.INDC_DATE_END = ' ' AND
A.ACCT IN (
SELECT C.NBR_CARDH_ACCT
FROM ACCT C
WHERE C.DATE_START = '&&DATE' AND
C.ACCT IN (
SELECT B.ACCT
FROM ACCT_ID B
WHERE B.INDC_ACTIVE = 'Y' |
As I mentined in above query in place of &&DATE, need to pass date coming from the input file.
In JCL we can pass the parameter, likewise can we pass the parameter to unload card? I am using FASTUNLOAD utility of platinum plus.
2. Also how can we mention parameter in sortcard if it is exceding more than 80 bytes? |
|
Back to top |
|
|
Help-Me-Out
New User
Joined: 09 Dec 2006 Posts: 56 Location: Pune
|
|
|
|
Thanks!!
I know how to pass parameter within jcl. In same way trying to pass to fastunload utility but not able to do so. Also tried searching the forum but fail to get the answer...
Can you provide hint/help in this case... |
|
Back to top |
|
|
Skolusu
Senior Member
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
|
|
|
|
Quote: |
I need to unload the data from the table for the current date. I need the data by compairing some table fields |
I am not sure as to why this question is in DFSORT forum but you can directly code "current date" parm in your sql itself like shown below
Code: |
SELECT A.ACCT
,A.DATE_START
FROM BAL A
WHERE A.INDC_DATE_END = ' '
AND A.ACCT IN (SELECT C.NBR_CARDH_ACCT
FROM ACCT C
WHERE C.DATE_START = CURRENT DATE
AND C.ACCT IN (SELECT B.ACCT
FROM ACCT_ID B
WHERE B.INDC_ACTIVE = 'Y') |
|
|
Back to top |
|
|
Ketan Varhade
Active User
Joined: 29 Jun 2009 Posts: 197 Location: Mumbai
|
|
|
|
I am not sure that but if u want to pass the date field from a file then u can use SYMNAME, I haven't used SYMNAME while unloading but may be possible that it will help you to achive the desired result |
|
Back to top |
|
|
|