473,325 Members | 2,860 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

Change value in IMPORT

Hi!

Is it possible to change a value of a column in IMPORT command.
Something like:

IMPORT FROM TABLE1.IXF OF IXF METHOD N (TAB_NAME, TAB_DATE) INSERT INTO
TMP_TABLE1(TAB_NAME, CURRENT DATE - 2 DAYS)

Best regards,
Kovi

--
____________________________
|http://kovica.blogspot.com|
-----------------------------~-~-~-~-~-~-~-~-~-~-
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
Jul 29 '08 #1
3 1493
AFAIK not with IMPORT. The only way I can think of is the use of a
INSERT Trigger on the target table

HTH
Joachim

On 29 Jul., 09:50, Gregor Kovač <gregor.ko...@mikropis.siwrote:
Hi!

Is it possible to change a value of a column in IMPORT command.
Something like:

IMPORT FROM TABLE1.IXF OF IXF METHOD N (TAB_NAME, TAB_DATE) INSERT INTO
TMP_TABLE1(TAB_NAME, CURRENT DATE - 2 DAYS)

Best regards,
* * * * Kovi

--
____________________________
|http://kovica.blogspot.com|
-----------------------------~-~-~-~-~-~-~-~-~-~-
| *In A World Without Fences Who Needs Gates? * |
| * * * * * * *Experience Linux. * * * * * * * *|
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
Jul 29 '08 #2
Yes, you are right, but the problem with the trigger is that I don't
have an elegant way to communicate the new value I want for a column in
a row.

Joachim Klassen pravi:
AFAIK not with IMPORT. The only way I can think of is the use of a
INSERT Trigger on the target table

HTH
Joachim

On 29 Jul., 09:50, Gregor Kovač <gregor.ko...@mikropis.siwrote:
>Hi!

Is it possible to change a value of a column in IMPORT command.
Something like:

IMPORT FROM TABLE1.IXF OF IXF METHOD N (TAB_NAME, TAB_DATE) INSERT INTO
TMP_TABLE1(TAB_NAME, CURRENT DATE - 2 DAYS)

Best regards,
Kovi

--
____________________________
|http://kovica.blogspot.com|
-----------------------------~-~-~-~-~-~-~-~-~-~-
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
--
____________________________
|http://kovica.blogspot.com|
-----------------------------~-~-~-~-~-~-~-~-~-~-
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
Jul 30 '08 #3
On Jul 30, 11:10 am, Gregor KovaÄŤ <gregor.ko...@mikropis.siwrote:
Yes, you are right, but the problem with the trigger is that I don't
have an elegant way to communicate the new value I want for a column in
a row.

Joachim Klassen pravi:
AFAIK not with IMPORT. The only way I can think of is the use of a
INSERT Trigger on the target table
HTH
Joachim
On 29 Jul., 09:50, Gregor Kovaè <gregor.ko...@mikropis.siwrote:
Hi!
Is it possible to change a value of a column in IMPORT command.
Something like:
IMPORT FROM TABLE1.IXF OF IXF METHOD N (TAB_NAME, TAB_DATE) INSERT INTO
TMP_TABLE1(TAB_NAME, CURRENT DATE - 2 DAYS)
Best regards,
Kovi
--
____________________________
|http://kovica.blogspot.com|
-----------------------------~-~-~-~-~-~-~-~-~-~-
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-

--
____________________________
|http://kovica.blogspot.com|
-----------------------------~-~-~-~-~-~-~-~-~-~-
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
Can't to just make it have default value for that column and while
loading just ignore that column

Regards,
Sridhar.S
Aug 6 '08 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: minjie | last post by:
Hello, I have to implement the following requirement: from an application, a user can export some info retrieved from DB2, and later import the info into another DB2 on another machine. The user...
4
by: Shapper | last post by:
Hello, I have this image in my HTML code: <img src="images/en-US/myImage.jpg" /> I want to change the URL using the value of a Session variable. <img src="images/ Session("culture") Value...
4
by: Bob | last post by:
Hi all, I've got a table that I've imported and it has junk at the top of the table, so after import I run a delete query to remove the junk lines then I'm left with the field names I want for...
9
by: KDawg44 | last post by:
Hi, I am brand new to Python. In learning anything, I find it useful to actually try to write a useful program to try to tackle an actual problem. I have a syslog server and I would like to...
45
by: Zytan | last post by:
This returns the following error: "Cannot modify the return value of 'System.Collections.Generic.List<MyStruct>.this' because it is not a variable" and I have no idea why! Do lists return copies...
1
by: dhaneshrs | last post by:
I have a small code that shows inactive and active users from the ms access DB. <%@ Page Language="VB" MasterPageFile="~/MasterPageAdmin.master" Title="Welcome" %> <%@ Import...
4
by: CDMAPoster | last post by:
In: http://groups.google.com/group/comp.databases.ms-access/msg/f06bd4c45037ef29 Lyle wrote: :Terry Kreft wrote: : :>Suck it and See? :
2
by: manishamca | last post by:
In dropdown i am retriving value from the backend. For eg: in the dropdown list the value selected are employee id..then i want to disply the emp name,job etc in the textbox. If i select a...
6
by: gavy7210 | last post by:
hello i am using struts 1.2,Eclipse Platform Version: 3.4.2,mySql 5.0.1,jdk 1.5.. i have a login form(jsp) in which a user logs in,in case he doesnt enter his username and/or password an error...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shćllîpôpď 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.