View previous topic :: View next topic
|
Author |
Message |
Dinesh Manivannan
New User
Joined: 17 Mar 2008 Posts: 17 Location: India
|
|
|
|
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 |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1787 Location: Bloomington, IL
|
|
|
|
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 |
|
|
Dinesh Manivannan
New User
Joined: 17 Mar 2008 Posts: 17 Location: India
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
are you taking about qmf? |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
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 |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1787 Location: Bloomington, IL
|
|
|
|
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 |
|
|
Dinesh Manivannan
New User
Joined: 17 Mar 2008 Posts: 17 Location: India
|
|
|
|
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 |
|
|
Dinesh Manivannan
New User
Joined: 17 Mar 2008 Posts: 17 Location: India
|
|
|
|
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 |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009 Posts: 565 Location: Bangalore
|
|
|
|
Are you updating the the table using program... If yes.. then you could also use Merge statement (Available on DB2 V9) |
|
Back to top |
|
|
Dinesh Manivannan
New User
Joined: 17 Mar 2008 Posts: 17 Location: India
|
|
|
|
No. I need to do this with utility not using a program. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10888 Location: italy
|
|
|
|
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 |
|
|
Dinesh Manivannan
New User
Joined: 17 Mar 2008 Posts: 17 Location: India
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10888 Location: italy
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10888 Location: italy
|
|
|
|
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 |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1787 Location: Bloomington, IL
|
|
|
|
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 |
|
|
|