Create an output file from GGSCI commands

1. Create a shell script: ggsci_out.sh. It should contain the following:

./ggsci < {parameter file} >{output file}

example:

$ vim ggsci_out.sh
./ggsci  >ggsci_out.list

2. The shell script access mode must be executible

$ chmod +x ggsci_out.sh

3. Create a parameter file that contains the desired ggsci command. Example for INFO TRANDATA command:

$ vim ggsci.prm
dblogin userid {userid}, password {password}
info trandata {schema}.{table}

Example for STATS command

$ vim ggsci.prm
stats *, total, hourly

4. From the Linux/UNIX command prompt, run the shell script:

$ ./ggsci_out.sh

The output will be written to ggsci_out.list.