Error MLOAD pmSetSchema

Database

Error MLOAD pmSetSchema

Dear all,

I am a beginner in teradata. Right now I'm trying to execute command MLOAD via linux.

This is my command

BASE_DIR="/data2/new/";
LOG_DIR="${BASE_DIR}LOG/";
LOG_FILE="test.log";
DATA_INPUT="${BASE_DIR}/";
SCRIPT="${BASE_DIR}SCRIPT/";

DATABASE_NAME="ram1";
TEMP_DATABASE="ram1";
TABLE_NAME="USA_TEST";
IP_ADDRESS="100.65.76.101";
USERID="usa1";
PASWD="Usa1#123";
FILE_NAME_IN="/data2/new/test.txt";

RunSql()
#
{
(
mload <<-END-OF-TEXT >> ${LOG_DIR}${LOG_FILE};
.logmech ldap;
.LOGTABLE ${TEMP_DATABASE}.LOG_${TABLE_NAME};
.logon ${IP_ADDRESS}/${USERID},${PASWD};

drop table ${TEMP_DATABASE}.uv_${TABLE_NAME};
drop table ${TEMP_DATABASE}.wt_${TABLE_NAME};
drop table ${TEMP_DATABASE}.et_${TABLE_NAME};
RELEASE MLOAD ${DATABASE_NAME}.${TABLE_NAME};
.begin import mload
tables ${DATABASE_NAME}.${TABLE_NAME}
worktables ${TEMP_DATABASE}.wt_${TABLE_NAME}
errortables ${TEMP_DATABASE}.et_${TABLE_NAME} ${TEMP_DATABASE}.uv_${TABLE_NAME}
SESSIONS 1 1 ;

.layout LAYOUT_nyanya;
.FIELD msisdn * VARCHAR(50);
.FIELD prev_status * VARCHAR(50);
.FIELD num_prefix * VARCHAR(50);
.FIELD status * VARCHAR(50);

.dml label ${TABLE_NAME}_dml;

INSERT INTO ${DATABASE_NAME}.${TABLE_NAME}
(
msisdn =: msisdn,
prev_status =: prev_status,
num_prefix =: num_prefix,
status =: status
);

.import infile ${FILE_NAME_IN}
format VARtext '|'
layout LAYOUT_nyanya
apply ${TABLE_NAME}_dml;

.end mload;

.logoff;
.quit;
END-OF-TEXT
)
}

RunSql;

but when I run test.sh, it apperas error ==> mload: symbol lookup error: mload: undefined symbol: pmSetSchema

please help how to solve this problem

Thanks

2 REPLIES

Re: Error MLOAD pmSetSchema

please any suggestion?

Junior Supporter

Re: Error MLOAD pmSetSchema

Hi.

This is not a multiload error, but a Linux one.

Is your LD_LIBRARY_PATH variable set properly?

What is the result of echo $LD_LIBRARY_PATH?

What is the result of executing mload from the command line?

Cheers.

Carlos.