Sending commands using oledb command object

The OLEDB drivers from IBM for AS/400 allows me to use the Command Object to send more or less any command to the AS/400. I can also through the Command Object execute any user written program on the AS/400 and get the result back.

For example to execute a prgram that multiply two numbers and return the result, the code looks something like this

cmd.CommandText = "{{CALL MULTIPLY(?<?<?)}}; cmd.CommandType = CommandType.Text;

cmd.Parameters.Add("P1", OleDbType.Decimal);
.
.

etc

cmd.Prepare();
cmd.Parameters[0] = 3;
cmd.Parameters[1] = 5;
cmd.ExecuteQuery();

The result will be returned in the third parameter.

Anybody knows if it is possible to do the same thing with any other OLEDB providers and Host systems, e.g. Orcale on Unix?

Thanks,
Ken Received on Fri Mar 08 2002 - 15:48:32 CET