Updating LSINFO Field in LogOnSource Column (DBC.LOGONOFF Table)
I would like to update LSINFO Field of LogOnSource Column, LSINFO is an environmental variable so i prepared the following script in BTEQ
.SET LSINFO="MY Custom Message"; .LOGON TDP/USERNAME,password; .set separator ';';
/* SQL Statements */
.LOGOFF; .QUIT ERRORCODE;
But i got an error that LSINFO is not valid environmental variable.
Please help me in this regard.