Midrange News for the IBM i Community


Posted by: Chris Proctor
Programmer Analyst
Columbia Sports Company
Portland, OR
STRDBMON file - How is the 3010 rcd linked to 1000 record?
has no ratings.
Published: 25 Mar 2016
Revised: 25 Mar 2016 - 396 days ago
Last viewed on: 24 Apr 2017 (756 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

STRDBMON file - How is the 3010 rcd linked to 1000 record? Published by: Chris Proctor on 25 Mar 2016 view comments

Good morning. For SQL statements where a ? is a placeholder for the variable (the 1000 record) there is an associated 3010 record that has the values in the QQ1000 field. Does anyone know how these records are linked? I've tried different combinations and can't quite seem to nail it down.

It must be linked somehow, because when I view the file in iNav the SQL statement and it's variables are displayed on the same line.

Thank you for any assistance.

Return to midrangenews.com home page.
Sort Ascend | Descend

COMMENTS