Change value in IMPORT

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • =?ISO-8859-2?Q?Gregor_Kova=E8?=
    #1

    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. |
    -~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
    Tags: None
    • Joachim Klassen
      #2
      Re: Change value in IMPORT

      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...@m ikropis.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.                |
      -~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-

        Comment

        • =?ISO-8859-2?Q?Gregor_Kova=E8?=
          #3
          Re: Change value in IMPORT

          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...@m ikropis.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. |
          -~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-

            Comment

            • situ
              #4
              Re: Change value in IMPORT

              On Jul 30, 11:10 am, Gregor Kovač <gregor.ko...@m ikropis.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...@m ikropis.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

                Comment

                Previous template Next
                Working...