Hai All,
Iam using DBLOOKUP function to retrieve a field called sname where sno is 1001
from the oracle database..
map is executing while iam Hard coding "1001" instead of using "+SNO Column:Row:input+" in this way
=valid(dblookup("select sname from student1 where sno= ' "+"1001"+" ' ","-MDQ Database_QueryFile1.mdq -DBNAME updat -TE+"),FAIL("FAILED DURING SELECTING COUNTRY_NAME"))
Map execution failed using in this way
=valid(dblookup("select sname from student1 where sno= ' "+SNO Column:Row:input+" ' ","-MDQ Database_QueryFile1.mdq -DBNAME updat -TE+"),FAIL("FAILED DURING SELECTING sname"))
and the error it shows is
M120 ERROR:
Map: updat Output: SNAME Column:dbcard
SNO Column:Row:input is an invalid operand.
Kindly Help me
Iam using DBLOOKUP function to retrieve a field called sname where sno is 1001
from the oracle database..
map is executing while iam Hard coding "1001" instead of using "+SNO Column:Row:input+" in this way
=valid(dblookup("select sname from student1 where sno= ' "+"1001"+" ' ","-MDQ Database_QueryFile1.mdq -DBNAME updat -TE+"),FAIL("FAILED DURING SELECTING COUNTRY_NAME"))
Map execution failed using in this way
=valid(dblookup("select sname from student1 where sno= ' "+SNO Column:Row:input+" ' ","-MDQ Database_QueryFile1.mdq -DBNAME updat -TE+"),FAIL("FAILED DURING SELECTING sname"))
and the error it shows is
M120 ERROR:
Map: updat Output: SNAME Column:dbcard
SNO Column:Row:input is an invalid operand.
Kindly Help me