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
 

 

Copy TSQ in flat file in TSO batch.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS
View previous topic :: :: View next topic  
Author Message
milind suman
Warnings : 1

New User


Joined: 19 Aug 2009
Posts: 55
Location: Pune

PostPosted: Fri Dec 09, 2011 7:23 pm    Post subject: Copy TSQ in flat file in TSO batch.
Reply with quote

Hello ,


I want to copy the TSQ data in a flat file , How can i do this in batch in TSO region .

Thanks.
Back to top
View user's profile Send private message

Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7914
Location: Bellevue, IA

PostPosted: Fri Dec 09, 2011 7:33 pm    Post subject:
Reply with quote

When you say "TSQ", are you talking about a Temporary Storage Queue in a CICS region?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Fri Dec 09, 2011 7:37 pm    Post subject:
Reply with quote

strickly speaking,
i would say that batch and tso region are mutually exclusive.

in other words, you can not do something in a tso region via batch.
Back to top
View user's profile Send private message
milind suman
Warnings : 1

New User


Joined: 19 Aug 2009
Posts: 55
Location: Pune

PostPosted: Fri Dec 09, 2011 7:51 pm    Post subject:
Reply with quote

yes I mean Temporary storage Que in CICS , is there any way to copy the TSQ data in tso without doing anything in cics ?
Back to top
View user's profile Send private message
Garry Carroll

Active Member


Joined: 08 May 2006
Posts: 990
Location: Dublin, Ireland / Edinburgh, Scotland

PostPosted: Fri Dec 09, 2011 8:18 pm    Post subject:
Reply with quote

Since Temporary Storage is, by definition, temporary - why on earth would you want to do this? DFHTEMP is intended for internal use in the CICS environment and should not be interfered with in the manner suggested.

Garry.
Back to top
View user's profile Send private message
Bill O'Boyle

CICS Moderator


Joined: 14 Jan 2008
Posts: 2502
Location: Atlanta, Georgia, USA

PostPosted: Fri Dec 09, 2011 8:25 pm    Post subject: Reply to: Copy TSQ in flat file in TSO batch.
Reply with quote

Without a 3rd-Party product (and even that may not do the trick), there isn't an easy way to do this and at the very least (without a 3rd-Party product), would require an EXCI/ECI DPL interface to the target CICS region.

I'm thinking a REXX exec could be launched from ISPF screen 6 or native TSO and CALL an EXCI/DPL Client program, which would then link to the target region's Server program.

Or, this could also be accomplished directly from Batch, using a Client/DPL program linking to a Server program in the target region (same concept as outlined from ISPF/TSO).

But, these are just general ideas and would require significant tweaking and consideration.

HTH....

Mr. Bill
Back to top
View user's profile Send private message
Garry Carroll

Active Member


Joined: 08 May 2006
Posts: 990
Location: Dublin, Ireland / Edinburgh, Scotland

PostPosted: Fri Dec 09, 2011 8:43 pm    Post subject: Re: Reply to: Copy TSQ in flat file in TSO batch.
Reply with quote

Bill O'Boyle wrote:
Without a 3rd-Party product (and even that may not do the trick), there isn't an easy way to do this and at the very least (without a 3rd-Party product), would require an EXCI/ECI DPL interface to the target CICS region.

I'm thinking a REXX exec could be launched from ISPF screen 6 or native TSO and CALL an EXCI/DPL Client program, which would then link to the target region's Server program.

Or, this could also be accomplished directly from Batch, using a Client/DPL program linking to a Server program in the target region (same concept as outlined from ISPF/TSO).

But, these are just general ideas and would require significant tweaking and consideration.

HTH....

Mr. Bill


Yes, but the OP was looking for a way without any change in CICS

Quote:
yes I mean Temporary storage Que in CICS , is there any way to copy the TSQ data in tso without doing anything in cics ?


Garry.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7914
Location: Bellevue, IA

PostPosted: Fri Dec 09, 2011 8:54 pm    Post subject:
Reply with quote

Quote:
yes I mean Temporary storage Que in CICS , is there any way to copy the TSQ data in tso without doing anything in cics ?
Your question can be answered simply: NO!
Back to top
View user's profile Send private message
milind suman
Warnings : 1

New User


Joined: 19 Aug 2009
Posts: 55
Location: Pune

PostPosted: Fri Dec 09, 2011 9:14 pm    Post subject:
Reply with quote

Thanks everybody for the reply . saved a lot of time in wasting time to search for something like this.
ok , so going conventionally I need to define a a file in FCT and new program in relevant table to read a tsq in CICS program or there could be a better time saver option .
Back to top
View user's profile Send private message
Bill O'Boyle

CICS Moderator


Joined: 14 Jan 2008
Posts: 2502
Location: Atlanta, Georgia, USA

PostPosted: Fri Dec 09, 2011 9:23 pm    Post subject: Reply to: Copy TSQ in flat file in TSO batch.
Reply with quote

If you use the EXCI/DPL method, you could "stack" the TSQ records in the commarea, passed from the EXCI program and subsequently addressed by the Server program.

When the Server program returns control to the Client (EXCI) program, then you can "pop" all these records from the commarea and write them to a QSAM file, no FCT entry required.

Note: IBM's recommended maximum commarea-length for EXCI/DPL is 32500.

Mr. Bill
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Fri Dec 09, 2011 9:38 pm    Post subject:
Reply with quote

have not used it myself,
but there are "rexx panels" and rexx scripts available in cics.

would not be supprised if there is a easy way to script a "que drainer".
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Fri Dec 09, 2011 9:50 pm    Post subject:
Reply with quote

here are some links:

http://www.mainframezone.com/cics-websphere/rexx-for-cics/P1

http://nersp.nerdc.ufl.edu/~sfware/share107/s8335sfw.pdf

http://www-01.ibm.com/software/htp/cics/products/rexx/

http://publib.boulder.ibm.com/infocenter/cicsts/v2r3/index.jsp?topic=/com.ibm.cics.ts23.doc/dfha1/dfha1mi.htm


can't get a price on it though, and you know that it will cost.
but, before you start buying 3rd party software,
maybe interesting to create your own cics 'utilities' with rexx.
Back to top
View user's profile Send private message
Earl Haigh

Active User


Joined: 25 Jul 2006
Posts: 475

PostPosted: Thu Dec 29, 2011 2:37 am    Post subject:
Reply with quote

3rd part product BatchCICS-Connect (www.batchcics.com) provides ability to read and/or write TSQ's from batch.
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 -> CICS All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts syncsort: copy lines after the keyword shreya19 SYNCSORT 7 Fri Dec 02, 2016 9:47 am
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
No new posts How does a called pgm know if its cal... Graeme Westerman COBOL Programming 4 Tue Nov 29, 2016 9:25 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm


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