XRef Analysis
Where
procedure_name contains
">
AND
OR
file_name contains
">
AND
OR
line_number contains
">
AND
OR
reference_type contains
COMPILE
STRING
RUN
INCLUDE
CREATE
DELETE
SORT-ACCESS
ACCESS
REFERENCE
UPDATE
SEARCH
NEW-SHR-VARIABLE
GLOBAL-VARIABLE
SHR-FRAME
NEW-SHR-FRAME
SHR-WORKTABLE
NEW-SHR-WORKTABLE
FUNCTION
EXTERN
PROCEDURE
DLL-ENTRY
PUBLISH
SUBSCRIBE
UNSUBSCRIBE
CPINTERNAL
CPSTREAM
SORT-BY-EXP
AND
OR
object_identifier contains
">
Max Rows Returned:
Maximum of 6000 rows
Procedure Name
File Name
Line Number
Reference Type
Object Identifier
5000) $Limit = 6000; if ($Limit <= 0) $Limit = 100; if ($procedure_name . $file_name . $line_number . $reference_type . $object_identifier != "") { $NeedConjunction = FALSE; $SQL = "SELECT * FROM xref_raw"; if ($procedure_name . $file_name . $line_number . $reference_type . $object_identifier != "") $SQL .= " WHERE "; if ($procedure_name != "") { $Clause = " UPPER(procedure_name) LIKE UPPER('%$procedure_name%') "; $NeedConjunction = TRUE; $SQL .= $Clause; } if ($file_name != "") { $Clause = " UPPER(file_name) LIKE UPPER('%$file_name%') "; if ($NeedConjunction) $SQL .= $_POST["file_name_conjunction"] . $Clause; else $SQL .= $Clause; $NeedConjunction = TRUE; } if ($line_number != "") { $Clause = " UPPER(line_number) LIKE UPPER('%$line_number%') "; if ($NeedConjunction) $SQL .= $_POST["line_number_conjunction"] . $Clause; else $SQL .= $Clause; $NeedConjunction = TRUE; } if ($reference_type != "") { $Clause = " UPPER(reference_type) LIKE UPPER('%$reference_type%') "; if ($NeedConjunction) $SQL .= $_POST["reference_type_conjunction"] . $Clause; else $SQL .= $Clause; $NeedConjunction = TRUE; } if ($object_identifier != "") { $Clause = " UPPER(object_identifier) LIKE UPPER('%$object_identifier%') "; if ($NeedConjunction) $SQL .= $_POST["object_identifier_conjunction"] . $Clause; else $SQL .= $Clause; } $SQL .= " ORDER BY procedure_name LIMIT " . $Limit; print ("Issuing SQL: $SQL
\n"); $ResultSet = $db->query($SQL); $BGColor = "#FFFFFF"; while ($ResultSet->fetchInto($Row)) { $BGColor = $BGColor == "#FFFFFF" ? "#99CCFF" : "#FFFFFF"; ?>