Trying to create a SQL with multiple parameters to extract data from iSeries database. The SQL will work with 1 parameter but not 2. One parameter can be used and hard code the second select and it will work. No errors are received; it just does not produce any data.
It has something to do with Toad Data Point and the iSeries.
This SQL produces data:
SELECT * from plieclib.iepipmst where eqplnt = :plant and eqtag = 'FT-925'
This SQL does not produce data (fill in both parameters):
SELECT * from plieclib.iepipmst where eqplnt = :plant and eqtag = :tag
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center