This function was developed to provide a way of reading the files on a remote server if we did not have telnet access. The start directory is $LESDIR/src/cmdsrc.
These functions were developed to send files back and forth between a remote server if we did not have FTP access.
Sets variables available as @@<VAR_NAME> for the current tab.
Loads the table from a .csv file.
Saves the table to a .csv file.
Saves the table to a .csv file with each row in its own file.
Opens a dialog of tables to include/exclude from the backup, then writes them in CSV form to a ZIP file when you click “Start Backup”. You can also restore a backup made previously by optionally truncating the existing table and inserting the rows in the file.
Allows you to load the data in the .csv’s selected into the environment of the current tab. Filenames are expected to be the table name to load, have the table name after 2 underscores (i.e. USR-DDA__dda_mst.csv), or have the table name then a dash (i.e prtmst-30870.csv). Any errors will displayed in a popup box.
This works the same as MLoad, but removes the data instead.
Uses the tab’s text as though it were a .ctl file and processes each line of the file through it. This is useful for loading large CSVs as the entire file is not loaded, just line-by-line. The progress is shown in the status bar.
Used for easily generating a script to load/unload.
The .csv and .ctl file must reside on the server in db/data/load
Get Inserts/Updates was developed to facilitate the moving of data from one environment to another. Get Inserts uses the active table to create an insert statement for each row of the table. Get Updates creates a sl_change gen_maint command for each row. All functions place the result in the clipboard for easy pasting to another window.