DSXchange

Try this : write your query in a sql file and execute as below.it will be easier: *Write query to a temporary sql file. cmd= "echo select * from dual > query.sql" Call DSExecute("UNIX",cmd,Output,Retval) *execute the sql file cmd="sqlplus -s DSGPS_BATCH/gpsd1@GPSD<query.sql...

In the server routine,do following : cmd= "sqlplus -s userid/passwd@server Your query" Call DSExecute("UNIX",cmd,Output,Returnval) *** If you find it difficult to implement in routine,you can use similar logic in a shell script. Hi Nikhil, The above code is not working. It is th...

Ugh, that's going to be an unwieldy solution, not to mention harder to code and maintain then you can possible imagine. You'd have to go "BCI" and leverage ODBC and then deal with the fact that the supplied ODBC drivers are not licensed for use outside of the GUI. Far better to stick with...

Hi All, I need to write a routine to accomplish the below task, 1. Get value from oracle table which is of single row table and store this value in stage variable. I had tried to implement the above scenario using below methods, 1. Read from oracle table and write into a sequential file, then use ex...