Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Is there a way to NDM a particular number of records?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IBM Tools
View previous topic :: :: View next topic  
Author Message
venksiv

New User


Joined: 20 Jun 2015
Posts: 26
Location: INDIA

PostPosted: Thu Mar 10, 2016 7:52 pm    Post subject: Is there a way to NDM a particular number of records?
Reply with quote

Hi all,

I have a huge list of PS files which are required in the testing environments. I do not need the full file (might contain even millions of records). Is there a way to override the default FULL file transmission and transmit only a lesser, say 1000, records in the file during NDM proc execution?

Please share your expertise.

My attempt:
I thought a roundabout way but I'm sure is not suitable for this situation as this might involve execute multiple JCL - one thousand jobs for one thousand files unless I write a logic to combine EXEC steps to allowed limit in a single job:
Step 1: Construct the JCL IDCAMS step to REPRO the file with COUNT(N) as 1000
Step 2: Append a NDM step to transmit the REPRO output file
Step 3: Execute each job corresponding to a file
Back to top
View user's profile Send private message

venksiv

New User


Joined: 20 Jun 2015
Posts: 26
Location: INDIA

PostPosted: Fri Mar 11, 2016 12:39 pm    Post subject:
Reply with quote

I only need a reduced number of records to be sent to target region. Kindly advise if there is a way restrict NDM from transmitting full file but send only a lesser number of records - "intentionally truncate a file" in other words.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2365
Location: Hampshire, UK

PostPosted: Fri Mar 11, 2016 2:01 pm    Post subject:
Reply with quote

You could, possibly, pre-allocate your output datasets to a minimal size with no secondary extents and the NDMs will fail with space errors but you could live with that. Try with one dataset first. Otherwise, if it ain't in the manual it ain't possible.
Back to top
View user's profile Send private message
venksiv

New User


Joined: 20 Jun 2015
Posts: 26
Location: INDIA

PostPosted: Tue Mar 15, 2016 4:19 pm    Post subject:
Reply with quote

Thanks, Nic.

I spent a few extra hours and implemented the second idea and it's working fine so far.
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 -> IBM Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Problem while trying to manipulate re... amitc23 DFSORT/ICETOOL 3 Tue Jun 30, 2020 1:19 pm
No new posts Need to select all records belonging ... Q5P418 DB2 2 Mon Jun 22, 2020 11:34 pm
No new posts How to filter out certain records bas... manugeorge2004 JCL & VSAM 5 Wed Jun 17, 2020 10:05 pm
No new posts Need to delete inactive records from ... Sanchayita Sinha DB2 5 Fri May 29, 2020 10:47 pm
No new posts Need SQL for two latest records havin... Q5P418 DB2 10 Sun May 10, 2020 8:24 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us