How to write a file getting input from a symbolic parameter?

lanand_hps

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.

ofer71 · Posted: Wed Jul 30, 2008 1:03 pm Post subject:

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.

lanand_hps · Posted: Wed Jul 30, 2008 1:10 pm Post subject:

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?

ofer71 · Posted: Wed Jul 30, 2008 1:16 pm Post subject:

Well, if you don't believe me, you are more then welcome to consult the fine manual (see bullet #5).

O.

expat · Posted: Wed Jul 30, 2008 1:21 pm Post subject:

Or even try it for yourself to see what z/OS has to say.

enrico-sorichetti

check the usage of EZACFSM1 on how to carry on substitutions of parameters

lanand_hps · Posted: Wed Jul 30, 2008 2:05 pm Post subject:

Thanks everyone..
I didnot mean to question the points.. just wanted to put my thought in a different way..

Thanks guys..

Suresh Shankarakrishnan · New User Joined: 11 Jul 2008 Posts: 22 Location: USA

See the links listed below from the DFSORT Forum:

http://ibmmainframes.com/viewtopic.php?t=32471

http://ibmmainframes.com/viewtopic.php?t=32443

Frank Yaeger · Posted: Thu Jul 31, 2008 12:53 am Post subject:

DFSORT can use System symbols like &YR4, but it cannot use SET symbols. For example, you could do this:

gcicchet · Senior Member Joined: 28 Jul 2006 Posts: 653

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

dick scherrer · Posted: Thu Jul 31, 2008 5:44 am Post subject:

Hi Gerry,