Changes

Jump to: navigation, search

Post Processing SQL Scripts

401 bytes added, 13:22, 13 November 2017
no edit summary
# Run the following in the command window: pgsql\bin\psql -U imsma -d staging -h localhost -L sql.log -f sqlscripts\filename.sql }}
[[Image:PostProc SAG error.png|500px|center]]<br/>
<div align="center">
'' SAG cannot find the script file ''
</div>
# The post processing SQL file must be stored in C:\IMSMAETLTool\sqlscripts
# The full name of the file must be specified e.g. Albania_stat.sql
# The SAG must be started via a shortcut. You find which values to use for the shortcut '''[[Windows 8 and Windows 10#Shortcuts |here]]'''.
Contact your [[Information Management Team | GICHD IM advisor]] for help in developing SQL statements according to specific requirements.
{{NavBox Business Intelligence}}
[[Category:VIE]]
6,632
edits

Navigation menu