View previous topic :: View next topic
|
Author |
Message |
lanand_hps
New User
Joined: 05 Dec 2007 Posts: 82 Location: chennai
|
|
|
|
Hi,
I have 2 requirements.
1) My first requirement is to write a value of symbolic parameter into a file.
// SET TIMESTMP='2008-07-25-08.16.11.655180'
i need to write a file with this timestamp value. How do we do it?
2) Can we use symbolic parameter in a control card with SQL statement?
I've a query like
DELETE FROM TABLE_A
WHERE TIMESTAMP = &TIMESTMP (from jcl)
I read few forums which explains that this is not possible.
Please post your suggestions. |
|
Back to top |
|
|
ofer71
Global Moderator
Joined: 27 Dec 2005 Posts: 2358 Location: Israel
|
|
|
|
1. You can move the symbolic using PARM to REXX/COBOL or any programming language as parameter, and SAY/DISPLAY/WRITE it.
2. No. You can not use symbolic parameters in input data.
O. |
|
Back to top |
|
|
lanand_hps
New User
Joined: 05 Dec 2007 Posts: 82 Location: chennai
|
|
|
|
Can we not write a file using sort getting values from JCL? Seems strange.
// SET TIMESTMP='2008-07-25-08.16.11.655180'
//STEP01 EXEC PGM=SORT
//SORTIN DD * (i want to use symbolic here to get the above value)
//SORTOUT DD SYSOUT=*
//SYSIN DD *
SORT FIELDS =COPY
/*
No way that we can do this? |
|
Back to top |
|
|
ofer71
Global Moderator
Joined: 27 Dec 2005 Posts: 2358 Location: Israel
|
|
|
|
Well, if you don't believe me, you are more then welcome to consult the fine manual (see bullet #5).
O. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Or even try it for yourself to see what z/OS has to say. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
check the usage of EZACFSM1 on how to carry on substitutions of parameters |
|
Back to top |
|
|
lanand_hps
New User
Joined: 05 Dec 2007 Posts: 82 Location: chennai
|
|
|
|
Thanks everyone..
I didnot mean to question the points.. just wanted to put my thought in a different way..
Thanks guys.. |
|
Back to top |
|
|
Suresh Shankarakrishnan
New User
Joined: 11 Jul 2008 Posts: 42 Location: USA
|
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
Back to top |
|
|
gcicchet
Senior Member
Joined: 28 Jul 2006 Posts: 1702 Location: Australia
|
|
|
|
Hi,
why not just build a file with the information required and then concatenate this file in whatever DDNAME this information is required in.
Gerry |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hi Gerry,
Quote: |
why not just build a file with the information required and then concatenate |
Because that could reduce resource consumption and the more resources a job uses, the more important/valuable that job must be
Or (as i've shamelessly mentioned in other topics) someone is related to the person who sells/leases the hardware.
d |
|
Back to top |
|
|
|