Results 1 to 5 of 5

Thread: SQL1325N error

  1. #1
    Join Date
    Nov 2009
    Posts
    16

    Unanswered: SQL1325N error

    I am trying to load the data from a file to EIM table (Siebel Interface Table) in DB2 on unix server, But it is giving the below error while loading:

    SQL1325N The remote database environment does not support the command or one of the command options.


    Do I need to use staging(temp) table to load into EIM table or Do I need to set some parameters to invoke load command.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Where is the DB2 Database ? on unix server ? or is it DB2 for zOS?
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Nov 2009
    Posts
    16
    on unix server. Inside shell script I am connecting to DB2 and running the load client command..

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Well, SQL1325N talks specifically about DB2 zOS and iSeries.

    With the information you have given, I am not sure what it could be ... Do you have a copy of the command that is running ?

    Have you tried asking Siebel forums or Siebel support ?

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Nov 2009
    Posts
    16
    I am using the below command to load the data from delimited file to table

    load client from /home/input_file of del modified by identityignore coldel~ messages /home/STATUS_FILE insert into EIM_FN_ASSET1(CON_AA_NUM,AST_ASSET_NUM,IF_ROW_STAT ,IF_ROW_BATCH_NUM,ROW_ID) nonrecoverable

    Do we need to have any permissions to it?

    Please help me..

Posting Permissions

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