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
 

 

Information on import utility

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

New User


Joined: 17 Mar 2008
Posts: 16
Location: India

PostPosted: Thu Mar 08, 2012 8:32 pm    Post subject: Information on import utility
Reply with quote

Hi,

I need few information about Import utility. My requirement is need to update the rows from a file if the row already exits. I searched and found that we can use insert_update if import utility. But I could not find and sample with syntax.

It will be helpful if anyone provide syntax.

Input file for import will be PS which is got from another unload step.
Back to top
View user's profile Send private message

Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Thu Mar 08, 2012 8:43 pm    Post subject:
Reply with quote

There is no "import utility" in mainframe DB2. Take two steps back, find out what you mean to be talking about, and ask your question again, using the correct terminology.
Back to top
View user's profile Send private message
Dinesh Manivannan

New User


Joined: 17 Mar 2008
Posts: 16
Location: India

PostPosted: Thu Mar 08, 2012 9:11 pm    Post subject:
Reply with quote

Sorry. Its the import command not utility.

>>-IMPORT FROM--filename--OF--filetype-------------------------->

I don't to use this command with which utility(IKFET01...)
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


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

PostPosted: Thu Mar 08, 2012 9:20 pm    Post subject:
Reply with quote

are you taking about qmf?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


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

PostPosted: Thu Mar 08, 2012 9:27 pm    Post subject:
Reply with quote

Quote:
Input file for import will be PS which is got from another unload step.



what utility was used the generate the unload file?
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Thu Mar 08, 2012 9:42 pm    Post subject:
Reply with quote

Dinesh Manivannan wrote:
Sorry. Its the import command not utility.

>>-IMPORT FROM--filename--OF--filetype-------------------------->

I don't to use this command with which utility(IKFET01...)

I believe that this is a DB2 LUW command. Are you working on a mainframe or a toy computer like a Wintel box?
Back to top
View user's profile Send private message
Dinesh Manivannan

New User


Joined: 17 Mar 2008
Posts: 16
Location: India

PostPosted: Fri Mar 09, 2012 11:31 am    Post subject:
Reply with quote

I will use IKJEFT01 to unload the data from DB2 table and use this as input for IMPORT into another DB2 table.

I am working on mainframe.
Back to top
View user's profile Send private message
Dinesh Manivannan

New User


Joined: 17 Mar 2008
Posts: 16
Location: India

PostPosted: Fri Mar 09, 2012 12:24 pm    Post subject:
Reply with quote

Is this IMPORT is possible only by using DB2 control center. I need to do this a batch job.

I will be having two steps. First step will be unloading the data from a DB2 table. This unload file must be given as input for updating another table.

Is this possible to do in any other way
Back to top
View user's profile Send private message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Fri Mar 09, 2012 1:43 pm    Post subject:
Reply with quote

Are you updating the the table using program... If yes.. then you could also use Merge statement (Available on DB2 V9)
Back to top
View user's profile Send private message
Dinesh Manivannan

New User


Joined: 17 Mar 2008
Posts: 16
Location: India

PostPosted: Fri Mar 09, 2012 1:49 pm    Post subject:
Reply with quote

No. I need to do this with utility not using a program.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Fri Mar 09, 2012 3:00 pm    Post subject: Reply to: Information on import utility
Reply with quote

Quote:
It will be helpful if anyone provide syntax.


the best <entity> for providing this info is the manuals (*)

no reason for anybody to waste time to cut and paste manual pages
just because of Your unwillingness to look Yourself

(*) unfortunately as Akatsukami Sama hinted
the chances of finding this info on DB2 manuals for zOS are pretty slim
Back to top
View user's profile Send private message
Dinesh Manivannan

New User


Joined: 17 Mar 2008
Posts: 16
Location: India

PostPosted: Fri Mar 09, 2012 3:13 pm    Post subject:
Reply with quote

I tried myself searching the syntax for IMPORT in manuals. All I could find is the basic information about this. I am not sure whether we can use this along with any utility or possible only through DB2 control center.

I need the utility which will use the IMPORT command in it. I posted this as someone might have used this earlier and could help me.

My intention is not to waste others time.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Fri Mar 09, 2012 3:32 pm    Post subject: Reply to: Information on import utility
Reply with quote

Quote:
I need the utility which will use the IMPORT command in it.


does it occur to You that ...

since
You did not find it in the DB2 manuals
and since
googling for it only gave links related to db2 luw
luw as in Linux Unix Windows
not as Logical Unit of Work

most probably the <thing> in not for zOS DB2 ???
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Fri Mar 09, 2012 3:50 pm    Post subject: Reply to: Information on import utility
Reply with quote

Quote:
I will use IKJEFT01 to unload the data from DB2 table and use this as input for IMPORT into another DB2 table.


in IT, terminology is essential for effective communication .
IKJEFT01 is not a DB2 utility
it is the IBM TSO monitor program which simply sits there reading commands from the SYSTSIN ddname and executing them
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Fri Mar 09, 2012 5:33 pm    Post subject:
Reply with quote

Dinesh Manivannan wrote:
I tried myself searching the syntax for IMPORT in manuals. All I could find is the basic information about this. I am not sure whether we can use this along with any utility or possible only through DB2 control center.

I need the utility which will use the IMPORT command in it. I posted this as someone might have used this earlier and could help me.

My intention is not to waste others time.

I think that you are obsessing on IMPORT to a degree that may be preventing you from finding an acceptable solution. Both the IBM LOAD utility and BMC's Loadplus allow the update of rows based on the presence or absence of certain data in the input data set. I recommend that you review at least the IBM documentation (the BMC documentation is, TTBOMK, proprietary, although if your shop is licensed for the BMC product it should be available to you) to see how this can be done.
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 Obtaining file information pahiker COBOL Programming 25 Tue Sep 27, 2016 7:25 pm
No new posts Best IMS DB Unload Utility jjabez10 IMS DB/DC 12 Thu Sep 22, 2016 11:15 pm
No new posts Any docs / links for isub- cobol comp... SRICOBSAS COBOL Programming 4 Fri Aug 26, 2016 2:35 pm
No new posts Comparex utility to Syncsort conversion mistah kurtz SYNCSORT 11 Fri Jul 22, 2016 1:53 pm
No new posts DXT unload utility - DVRE0000 mistah kurtz DB2 1 Thu Jul 07, 2016 4:56 pm


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