| General Table Maintenance (ttaad4100 ) |  |
| Use this session to manipulate table field data without using sessions (which is the usual way). This particular session is meant only for developers. Inappropriate usage is can result in data inconsistency! Enter the codes of the package, module, table and company for which you want to maintain the table data. Press [Y] in the choice field to access the table fields. If you press the spacebar, a pull-down menu with standard options appears at the top of your screen. The options are grouped in 7 menus. The use of these options may deviate from the standard use. For example, after you have selected "Global Delete" you can specify the range with a selection screen (From-To). You do not have to mark records. It is possible to call help information by table field. Press [?] to get table field help. Note You can use the Change Data Language command in the CONTROL pull-down menu to display the table data in a different Data Language. This is only possible if fields of the table are registered as multilanguage fields. For more information, refer to Multilanguage Application Data. APPLICATION pull-down menu The last group of options is "APPLICATION". This group contains options which are only used for table maintenance. There are 11 items. 0 Table Information A window appears with general table information. This information consists of: table code row/record length number of rows/records number of indices If indices > 1 you can change the index with option [K] current index duplicates (y/n) 1 Copy Rows You can copy records from another table. By using certain parameters in a file it is possible to copy parts of fields from another table to parts of fields of the current table. Each line of the parameter file has the following syntax: x y z [expression] or c x y expression The first line means: copy position x and length y to position z in the current table. It is also possible to enter an expression behind: x y z ^abc This means: copy position x and length y to position z, only if the string `abc' is in the positions x, x+1 and x+2. The second line means: Only if the expression is true for position x and length y, carry out any action. Skip the record if expression is false. Notes: On the first line the expression is not needed, in the second it is. x,y and z are values, the character c is the normal character "c". Expressions are only working for string fields. Maximum number of lines in parameter file : 50 2 Export Data You can export the current table to a sequential file (compressed dump). Specify a directory into which the dump must be stored. With Import Data you can import the table into another system. 3 Import Data You can import a table of another system (environment). Specify the directory in which the dump has been stored. 4 Count Rows This utility will give you the number of records of the table. You can specify the range of index fields in which you can select the records which will be counted. 5 Modify Rows With this option you can modify a range of records in the current table. 6 Remove Rows Remove Rows With this option you can remove a range of records from the current table. * Toggle User Mode/Programmers Mode Programmers mode gives you detailed information (information for the programmer) about the table. Related topics To use an overview session To maintain records in an overview session |