IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Information on import utility


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Dinesh Manivannan

New User


Joined: 17 Mar 2008
Posts: 17
Location: India

PostPosted: Thu Mar 08, 2012 8:32 pm
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: 1787
Location: Bloomington, IL

PostPosted: Thu Mar 08, 2012 8:43 pm
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: 17
Location: India

PostPosted: Thu Mar 08, 2012 9:11 pm
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
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
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: 1787
Location: Bloomington, IL

PostPosted: Thu Mar 08, 2012 9:42 pm
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: 17
Location: India

PostPosted: Fri Mar 09, 2012 11:31 am
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: 17
Location: India

PostPosted: Fri Mar 09, 2012 12:24 pm
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
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: 17
Location: India

PostPosted: Fri Mar 09, 2012 1:49 pm
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

Superior Member


Joined: 14 Mar 2007
Posts: 10888
Location: italy

PostPosted: Fri Mar 09, 2012 3:00 pm
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: 17
Location: India

PostPosted: Fri Mar 09, 2012 3:13 pm
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

Superior Member


Joined: 14 Mar 2007
Posts: 10888
Location: italy

PostPosted: Fri Mar 09, 2012 3:32 pm
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

Superior Member


Joined: 14 Mar 2007
Posts: 10888
Location: italy

PostPosted: Fri Mar 09, 2012 3:50 pm
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: 1787
Location: Bloomington, IL

PostPosted: Fri Mar 09, 2012 5:33 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Use Copy Utility DB2 7
No new posts VSAM LISTCAT INFORMATION JCL & VSAM 2
No new posts Capturing Job Execution Information All Other Mainframe Topics 3
No new posts REASON 00D70014 in load utility DB2 6
No new posts ISRSUPC search utility - using high l... TSO/ISPF 2
Search our Forums:

Back to Top