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
 

 

How to load a file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
venkatatcts

New User


Joined: 16 Mar 2009
Posts: 55
Location: India

PostPosted: Sun Jul 18, 2010 1:41 am    Post subject: How to load a file
Reply with quote

Hi,

I need to insert a 5 rows in a table in a test region. For which I unloaded the table in production which has that 5 rows and then try to load that in test region which is getting abended S04E.

The Unload file is variable block file. I took the 5 records by using the cut command and put in a separate file which is also a VB and record lenght also the same but still i am facing the problem. But Finally i wrote a insert query to solve this issue.

Plesae let me know is this feasible.

Thanks in advance,
Venkatraman B
Back to top
View user's profile Send private message

CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Sun Jul 18, 2010 4:05 am    Post subject:
Reply with quote

IIRC, for every unload/export there is a reload/import utility function...
What did you use to 'unload' the table?
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: Sun Jul 18, 2010 5:40 am    Post subject:
Reply with quote

Hello,

Quote:
Plesae let me know is this feasible.
Yes, this is done almost everywhere.

Suggest you work with your dba to determine if you have not used the correct unload/reload processes. . .
Back to top
View user's profile Send private message
venkatatcts

New User


Joined: 16 Mar 2009
Posts: 55
Location: India

PostPosted: Sun Jul 18, 2010 11:16 pm    Post subject: Reply to: How to load a file
Reply with quote

Hi,

This is the utility i am using DSNTIAUL

Thanks,
Venkatraman B
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: Mon Jul 19, 2010 2:32 am    Post subject:
Reply with quote

Hello,
Hello,

There are a couple of ways to get help when you are stuck. The best way is typically to ask someone senior on the system you are using. Another is via our forum. In order for the forum to be effective, you must post ALL of the detail of the problem run(s).

You have provided almost nothing for someone to use to help you icon_sad.gif

Suggest you read the info available here:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/SEARCH?Book=dsnugj10&searchRequest=unload+load&SEARCH=Search&Type=FUZZY&SHELF=&DT=20040209165609&searchTopic=TOPIC&searchText=TEXT&searchIndex=INDEX&rank=RANK

and here:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/dsnugj10/APPENDIX1.4.1?ACTION=MATCHES&REQUEST=dsntiaul+load&TYPE=FUZZY&SHELF=&DT=20040209165609&CASE=&searchTopic=TOPIC&searchText=TEXT&searchIndex=INDEX&rank=RANK&ScrollTOP=FIRSTHIT#FIRSTHIT


What you have posted so far is "it didn't work" but have provided no actual info about the unload/load. . .
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm
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 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