DSXchange

Hi, calling sql query from a routine using sqlplus. routine run never ending.

Code:
Statement = "SELECT count(*) FROM TableName;"
Command = "sqlplus -S ": pSrcDBUser : "/" : pSrcDBPwd : pConString : char(10) : "SELECT count(*) FROM TableName;" : char(10) : "Exit" : char(10)
Call DSExecute ('NT', Command, OsOutput, OsStatus)

Above command will look before calling dsexecute as:
sqlplus -S UserName/Pwd@ConString
SELECT count(*) FROM TableName;
Exit

when I ran this directly from command prompt it is working fine and resulting record count. But when i call through DSExecute it is never ending the execution. I tried below as well but no luck. Please help.

Command = "sqlplus -S ": pSrcDBUser : "/" : pSrcDBPwd : pConString : char(10) : "SELECT count(*) FROM TableName;" : char(10) : "Exit" : char(10) : "Exit" : char(10)


Thanks in advance

OsOutput will store the return value of query. You need to map this to another variable.
like
QueryResult = TRIM(FIELD,OsOutput,@FM,3))

YOu can pass this value to log

Call DSLogInfo("Result:":QueryResult, "JobStats")

I do have such result printing statements but routine never ending the execution of the statement "DSExecute(...)" which is calling SQLPLUS.

maks475 wrote:when I ran this directly from command prompt it is working fine

Did you do this using the same user that executes the job?

Provide your full routine. so that we can assess.