Non-SQL Defined Tables
CA Culprit users have the ability to access information in tables or views of tables as well as create and populate tables. A table maintains information in rows and columns, where one row represents a single record occurrence and one column entry represents a field within the record. Internally, each table is defined as a logical record. The following report illustrates employee information stored in table format.
EMP-NAME STREET CITY STATE ZIP PHONE HERBERT CRANE 30 HERON AVE KINGSTON NJ 21341 2013341433 JANE FERNDALE 60 FOREST AVE NEWTON MA 02576 6178888112 GEORGE FONRAD 99 VERDE ST STOUGHTON MA 02456 6178882323 ROBIN GARDNER 68 75TH ST LOWELL MA 02945 6174521111 DOUGLAS KAHALLY 56 SPELLING AVE READING MA 02317 6173339056 TERENCE KLWELLEN 12 RAUNCH ST., APT1 DEDHAM MA 02034 6174456123 SANDY KRAAMER 56 NASTY WAY WESTWOOD MA 02090 6173290002 HERBERT LIPSICH 6 FORENOON ST WALDEN MA 02986 6175555555 NANCY TERNER 14 TYPE TERR READING MA 02317 6173333333
CA Culprit accesses information in a table one row at a time. Users can selectively retrieve rows of the table by coding a SELECT or BYPASS parameter.
Note: For more information about defining and storing tables, see the CA IDMS ASF User Guide.
|
Copyright © 2014 CA.
All rights reserved.
|
|