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
 

 

Unlaod from VSAM to flat file using IDCAMS

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

New User


Joined: 22 May 2008
Posts: 27
Location: Bangaluru

PostPosted: Thu Sep 30, 2010 10:52 am    Post subject: Unlaod from VSAM to flat file using IDCAMS
Reply with quote

Hi,

I am getting an error as below when I Unlaod records from VSAM to flat file using IDCAMS.

REPRO INFILE(FILEI) OUTFILE(FILEO)
IDC3302I ACTION ERROR ON BDLT.CICE.XXXXXXX.DP4600
IDC3309I ** RECORD X'0000000000' NOT WRITTEN. LENGTH INVALID
IDC0005I NUMBER OF RECORDS PROCESSED WAS 27588410

IDC0001I FUNCTION COMPLETED, HIGHEST CONDITION CODE WAS 8
IDC0002I IDCAMS PROCESSING COMPLETE. MAXIMUM CONDITION CODE WAS 8


The VSAM has extended addresibility, with around 27 million records and the first record is a null record. Could anyone please help me on this....
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
Location: italy

PostPosted: Thu Sep 30, 2010 10:59 am    Post subject: Reply to: Unlaod from VSAM to flat file using IDCAMS
Reply with quote

Quote:
... and the first record is a null record ...

explain please!

did You look at the manual for the meaning of the messages and the actions to be taken?

seems that about 27 millions records were processed, did You look at the output dataset?

could be one of the occasions where the sort counting capability might be handy!
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: Thu Sep 30, 2010 7:11 pm    Post subject:
Reply with quote

Hello,

Or simply use the sort to copy the data. . .

Maybe this will provide a diagnostic that you don't need to look up.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


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

PostPosted: Thu Sep 30, 2010 7:38 pm    Post subject:
Reply with quote

1. TS has not bothered to respond - add him to the list of those who post and then think (or ignore their problem)

2. since it is a vsam to qsam repro (we think) the obvious place to start looking is the defined DCB for the qsam file. qsam record length apparently does not jive with the vsam file. but that is to be expected by silly posts like these. That would have required the TS to do a listcat on the vsam file and determine the record length range.

3. and typical of ignorant posters:
Quote:
...the first record is a null record.

as Enrico asked, what does that mean? there is no such thing as a null record in a vsam file.
Back to top
View user's profile Send private message
gileshpg

New User


Joined: 22 May 2008
Posts: 27
Location: Bangaluru

PostPosted: Fri Oct 01, 2010 10:25 am    Post subject:
Reply with quote

What i meant by null record is the low value record that we add to the VSAM after delete defining, so that other jobs can open the VSAM in I/O mode., else the jobs might not be able to open the VSAM as its empty.
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: Fri Oct 01, 2010 11:28 am    Post subject:
Reply with quote

I usually use a VB output from REPRO, makes life so much easier
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
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm
No new posts Write out NODUPS but just from one file Jay Villaverde DFSORT/ICETOOL 8 Fri Jul 14, 2017 12:44 am
No new posts How to add header with Date(YYMMDD) i... Rajan Moorthy DFSORT/ICETOOL 2 Thu Jul 06, 2017 11:44 pm
No new posts How to generate a new unique Input fi... for1ranjith CLIST & REXX 11 Sat Jul 01, 2017 12:09 pm
No new posts Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm


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