Pass Dynamic value to SYSIN card while executing SQLs



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

Re: Pass Dynamic value to SYSIN card while executing SQLs

Postby dick scherrer » Thu Feb 27, 2014 10:35 pm

Thanks Peter.

I mis-spoke earlier . . . Not sure where i came up with 1.13 . . . :?

d
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: Re: Pass Dynamic value to SYSIN card while executing SQLs

 

Re: Pass Dynamic value to SYSIN card while executing SQLs

Postby Peter_Mann » Thu Feb 27, 2014 11:30 pm

Your welcome, and NP, I myself was thinking there was some support for symbols in 1.13 also.
Peter
Peter_Mann
 
Posts: 139
Joined: Fri Jun 24, 2011 7:37 pm
Location: Lowell,AR
Has thanked: 14 times
Been thanked: 3 times

Re: Pass Dynamic value to SYSIN card while executing SQLs

Postby shankar_dh » Fri Feb 28, 2014 11:45 am

Thank you all for the discussion and letting us know the things.
So at last, we can not pass symbolic value to SYSIN data??
No other alternatives??
shankar_dh
 
Posts: 41
Joined: Fri Mar 22, 2013 1:00 pm
Has thanked: 1 time
Been thanked: 0 time

Re: Pass Dynamic value to SYSIN card while executing SQLs

Postby Blackthorn » Fri Feb 28, 2014 2:28 pm

Yes, the other alternative is what Nic suggested in the second post -

"Otherwise you need to have a program read a parameter defined by a symbolic and generate your query in a previous step."
Blackthorn
 
Posts: 98
Joined: Tue Feb 01, 2011 7:12 pm
Has thanked: 0 time
Been thanked: 2 times

Re: Pass Dynamic value to SYSIN card while executing SQLs

Postby NicC » Fri Feb 28, 2014 2:33 pm

Blackthorn wrote:Yes, the other alternative is what Nic suggested in the second post -

"Otherwise you need to have a program read a parameter defined by a symbolic and generate your query in a previous step."

A topic that has been discussed before in the forum probably most often in the Sort sections.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times

Previous

Return to JCL

 


  • Related topics
    Replies
    Views
    Last post