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. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~- 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. * * * * * * * *|
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
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. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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?
:
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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....
|
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
|
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...
| |