Posted: Sun May 20, 2012 8:03 pm Post subject: CICS-DB2
I have a map which accept an input( in a field name [value]) from the user and its need to be passed to a table's query:
select salary into :ws-salary from employee
where exp = :ws-exp
now this query(at where clause) doesnt accept the data type of [value] (i.e my field name)because the employee.exp is of s9(2)v9(1) comp-3 data type. i tired changing the data type of my field [value] (using picout and picin) as s9(2) v9 comp-3 but still its showing me ASAR ABEND.
your map input/output field can not possibly be comp-3.
you must proof the data coming in from your map,
then you must populate a pic s9(2)v9 comp-3 Working-Storage field,
which will then be used as a host variable in the WHERE clause. _________________ Dick Brenholtz
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum