Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    Karachi,pakistan
    Posts
    17

    Unanswered: Importing Table data?

    ------>My table Schema is:
    CREATE adee4
    ( TRANS_ID INTEGER NOT NULL CHECK ("TRANS_ID" IS NOT NULL)
    , MOBILE_NO VARCHAR (25) , CARD_NO VARCHAR (25)
    , CARD_TYPE VARCHAR (15)
    , EXPIRY DATE NULL
    , AMOUNT INTEGER
    , DISCARDED VARCHAR (1) WITH DEFAULT 'N'
    , RESPONSE_SENT VARCHAR (1) WITH DEFAULT 'N'
    , TRANS_SUBMITTED VARCHAR (1) WITH DEFAULT 'N'
    , RESPONSE_RCVD VARCHAR (1) WITH DEFAULT 'N'
    , COMPLETED VARCHAR (1) WITH DEFAULT 'N'
    , ORDER_NO VARCHAR (25)
    , TRANS_LEVEL INTEGER WITH DEFAULT 0
    , MSG VARCHAR (10) ) ;

    ALTER TABLE CITI_SMS_TRANS
    ADD PRIMARY KEY (TRANS_ID);

    -----> ok! when I am trying to "import" data from file its giving me errors ,the data format in file is:

    154?923336100032?null?null?null?null?Y?N?N?N?N?nul l?0

    -----> I use "?" for column separation.
    ---->Look what Msg file says:

    SQL3109N The utility is beginning to load data from file "d:\gg.sql".

    SQL3129W The date, time, or timestamp field containing "null" in row "1" and
    column "5" was padded with blanks.

    SQL3119W The field value in row "1" and column "6" cannot be converted to an
    INTEGER value. A null was loaded.

    SQL3148W A row from the input file was not inserted into the table. SQLCODE
    "-180" was returned.

    SQL0180N The syntax of the string representation of a datetime value is
    incorrect. SQLSTATE=22007

    SQL3185W The previous error occurred while processing data from row "1" of
    the input file.

    SQL3110N The utility has completed processing. "1" rows were read from the
    input file.

    SQL3221W ...Begin COMMIT WORK. Input Record Count = "1".

    SQL3222W ...COMMIT of any database changes was successful.

    SQL3149N "1" rows were processed from the input file. "0" rows were
    successfully inserted into the table. "1" rows were rejected.

    ----> if date is not "null",then row is imports successfully.
    -----> plz help thanx.
    Last edited by ADee; 03-19-04 at 03:34.
    A.Dee

  2. #2
    Join Date
    Jan 2004
    Location
    Karachi,pakistan
    Posts
    17

    ok

    ---->ok! done! I just change the old data format to:
    154?923336100032?????Y?N?N?N?N?l?0
    ----> yup, no "null"
    A.Dee

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •