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.

Where is the DB2 Database ? on unix server ? or is it DB2 for zOS?

on unix server. Inside shell script I am connecting to DB2 and running the load client command..

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

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..