Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Outrec a varaible value in JCL

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
vampire

New User


Joined: 12 Oct 2009
Posts: 15
Location: Pune

PostPosted: Wed Oct 14, 2009 12:39 pm    Post subject: Outrec a varaible value in JCL
Reply with quote

Hi,

I am fetching key in JCL from a DB2 table and want to insert the same in the output file of JCL in a specific position.

How to insert a variable value in the output of a JCL??
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Wed Oct 14, 2009 12:44 pm    Post subject:
Reply with quote

Your request is not clear at all, please clarify exactly what it is that you wish to do
Back to top
View user's profile Send private message
vampire

New User


Joined: 12 Oct 2009
Posts: 15
Location: Pune

PostPosted: Wed Oct 14, 2009 12:49 pm    Post subject: Reply to: Outrec a varaible value in JCL
Reply with quote

I have a file,
Lets say

1 AAA BBB _ _ _ 9848 1282
1 ABC BBB _ _ _ 9878 1082
1 AAA BBB _ _ _ 9808 1782

Now i am fetching a key from a DB2 table and want to insert that key in the blank positions of the above file.i.e

1 AAA BBB "239" 9848 1282

I want same value to be populated for all records.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Oct 14, 2009 7:26 pm    Post subject:
Reply with quote

Hello and welcome to the forum,

Well, you will be using more than JCL. . . . I would dearly love to find and eliminate the idiot(s) who are telling people they must do something "with a JCL". All the JCL can do is execute one or more programs. . .

When you read the value from the db2 table, how are you doing this?
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8117
Location: East Dubuque, Illinois, USA

PostPosted: Wed Oct 14, 2009 7:32 pm    Post subject:
Reply with quote

Quote:
I would dearly love to find and eliminate the idiot(s) who are telling people they must do something "with a JCL"
I second this idea!!
Back to top
View user's profile Send private message
vampire

New User


Joined: 12 Oct 2009
Posts: 15
Location: Pune

PostPosted: Wed Oct 14, 2009 7:40 pm    Post subject: Reply to: Outrec a varaible value in JCL
Reply with quote

Hi d.sch.,

I just wnt to know whether there is any way of using OUTREC function with variable values.

If OUTREC is there to modify the output files of an JCL with any character, is there any option available to modify with variable data?

I am using SQL to fetch data from tabel
Back to top
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4649
Location: Raleigh, NC, USA

PostPosted: Wed Oct 14, 2009 8:04 pm    Post subject: Reply to: Outrec a varaible value in JCL
Reply with quote

Look into using the SYMNAMES DD.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Oct 14, 2009 8:48 pm    Post subject:
Reply with quote

Hello,

Quote:
I am using SQL to fetch data from tabel
Yup, but where is the SQL issued? In some program, spufi, etc?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts outrec field outside range Danielle.Filteau SYNCSORT 10 Sat Mar 04, 2017 2:37 am
No new posts SORT- outrec ram_vizag DFSORT/ICETOOL 10 Tue Sep 27, 2016 12:50 am
No new posts OUTREC FILELDS FAILS WITH ICE126A 2 ... balaji81_k DFSORT/ICETOOL 8 Sat Jul 02, 2016 1:22 am
No new posts OUTREC RDW NOT INCLUDED krsenthil85 SYNCSORT 10 Fri May 06, 2016 3:22 am
No new posts OUTREC on OUTFIL error rocky_balboa DFSORT/ICETOOL 4 Thu Aug 27, 2015 10:26 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us