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:
Quote:
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:
Quote:
>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. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
