kingharrison

IF (NOT EXISTS(SELECT * FROM QSYS2.SYSTABLES WHERE TABLE_SCHEMA = 'BACKUP' AND TABLE_NAME='MYTABLE')) THEN
    CREATE TABLE BACKUP.MYTABLE 
    AS (SELECT * FROM MYLIB.MYTABLE)
    WITH DATA;
ELSE
    INSERT INTO BACKUP.MYTABLE 
        SELECT * FROM MYLIB.MYTABLE;
END IF;

kingharrison

<?php
namespace Tablecodes\Model;

use Zend\Db\ResultSet\ResultSet;
use Zend\Db\TableGateway\TableGateway;
use Zend\Db\Sql\Select;
use Zend\Paginator\Adapter\DbSelect;
use Zend\Paginator\Paginator;
use K3sbase\Model\TABLCOD;

kingharrison

	'service_manager' => array (
				'invokables' => array (
						'AuthorizationIbmi' => 'authorization.php',
						'ToolkitService' => '../API/ToolkitService.php''
				),
		),

kingharrison

<ifModule mod_expires.c>
  ExpiresActive On
  ExpiresDefault "access plus 1 seconds"
  ExpiresByType text/html "access plus 1 seconds"
  ExpiresByType image/gif "access plus 2592000 seconds"
  ExpiresByType image/jpeg "access plus 2592000 seconds"
  ExpiresByType image/png "access plus 2592000 seconds"
  ExpiresByType text/css "access plus 604800 seconds" 
  ExpiresByType text/javascript "access plus 216000 seconds"
  ExpiresByType application/x-javascript "access plus 216000 seconds"

kingharrison

	public function onBootstrap(MvcEvent $e) {
		$eventManager = $e->getApplication ()->getEventManager ();
		$sharedManager = $eventManager->getSharedManager ();
		$sm = $e->getApplication ()->getServiceManager ();
		// This checks to see if the user is logged in.
		$eventManager->attach ( MvcEvent::EVENT_DISPATCH, array (
				$this,
				'checkLogin' 
		), 100 );
	}

kingharrison

RewriteEngine off
 <Location />
 RewriteEngine On
 RewriteCond %{REQUEST_FILENAME} -s [OR]
 RewriteCond %{REQUEST_FILENAME} -l [OR]
 RewriteCond %{REQUEST_FILENAME} -d
 RewriteRule ^.*$ - [NC,L]
 RewriteRule ^.*$ /index.php [NC,L]
 </Location>

kingharrison

<?php
/*
 * This is the instasll script used to setup environmental variables when first installing K3S
 */


/*
 * This loads variables from the deployment script. All variables added as parameters are accessable as ZS_<PARAMETER_NAME>
 */
$appLocation = getenv ( "ZS_APPLICATION_BASE_DIR" );