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 Changing of LRECL of a file abdulrafi DFSORT/ICETOOL 2 Fri Mar 24, 2017 3:25 pm
No new posts splitting a file abdulrafi DFSORT/ICETOOL 4 Fri Mar 24, 2017 11:51 am
No new posts Receive a file using PCOMM macro Harald.v.K IBM Tools 0 Thu Mar 23, 2017 6:50 pm
No new posts Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts Formatting VB File Learncoholic DFSORT/ICETOOL 3 Mon Mar 20, 2017 12:29 pm


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