DB Query only picking up the first selected field

David Paras

• September 15, 2015 18:36

This query is only picking up the first selected field. I proved this by mapping the entire variable to a dummy target and only ever got the first variable. I tried this in the database and I got both variables. I also tried a JOIN instead of the where clause and I also tried renaming the selected fields as in "select test.Name as ENAME", and it still only returned the first field.

DBQuery {select test2.PERS_NBR, test.NAME from EMP.Details test2, EMP.Employee test where test2.PERS_NBR = test.NAME from EMP.Details test2 , $var_ELIG_DBConnInfo , false}

0

• 

  David Paras

  • September 15, 2015 18:37

  One quick thing to try would be to set the third argument as true instead of false.

  - https://confluence.adeptia.com/display/AS/Using+DB+Function

  0

Post is closed for comments.