phpdave

---------------------------
System i Navigator
---------------------------
An error occurred while attempting to initialize the list.
[SQL0440] Routine INDEX_PARTITION_STATISTICS in *N not found with specified parameters. Cause . . . . . :   A function or procedure with the specified name and compatible arguments was not found. Recovery  . . . :   Specify the correct number and type of parameters on the CALL statement or function invocation. Try the request again.
---------------------------
OK   
---------------------------

phpdave

Webdriver PHP API workthough

• Open a browser

  # start an instance of firefox with selenium-webdriver
  
  $browser_type = 'firefox'
  $host = 'http://localhost:4444/wd/hub'
  

$capabilities = array(\WebDriverCapabilityType::BROWSER_NAME => $browser_type);

phpdave

( SELECT SUM ( FIEL ) AS "SOMEE FIEL" , SUM ( FIELD1234567890 ) AS "SOMEE AliasT
hatisbroken" , SUM ( SOMEFIELD1234 ) AS "Some alias is here123" , AVERYLONGFIELD
NAME1 FROM MYLIB . SOMETABLE12345678901234 WHERE SOMEFIELD < SOMEPARAMETER12 GRO

phpdave

Dcl-ds PARM1_Ds Extname('FILE') Qualified End-ds;
                                                    
 Incoming parameter definition                      
Dcl-pr Entry Extpgm('RPGNAME');                  
  PARM1   Char(%Len(PARM1_Ds.FIELDOFPARM1));               
End-pr;                                             

* Incoming parameter definition       
 Dcl-pi Entry;                        
   PARM1   Char(%Len(PARM1_Ds.PARM1));

phpdave

Dcl-ds PARM1_Ds Extname('FILE') Qualified End-ds;
                                                    
 Incoming parameter definition                      
Dcl-pr Entry Extpgm('RPGNAME');                  
  PARM1   Char(%Len(PARM1_Ds.FIELDOFPARM1));               
End-pr;                                             

* Incoming parameter definition       
 Dcl-pi Entry;                        
   PARM1   Char(%Len(PARM1_Ds.PARM1));

phpdave

 // Declare the resultset 
D  rsTable1                S             SQLTYPE(RESULT_SET_LOCATOR)

  // Declare data structures for data from cursors
D  rows                DS            Qualified Dim(500)
D  KEY1                                3I 0
D  KEY2                                4I 0
D  TOTAL_FIELD3                        31I 2
D  TOTAL_FIELD4                        31I 2

phpdave

SELECT 
    a.KEY1,
    a.KEY2,
    SUM(COALESCE (TOTAL_FIELD3,0)) AS TOTAL_FIELD3,
    SUM(COALESCE (TOTAL_FIELD4,0)) AS TOTAL_FIELD4
FROM 
    TABLE1 a
LEFT JOIN 
    (SELECT 
        SUM(FIELD3) AS TOTAL_FIELD3,

phpdave

php -d error_reporting=E_ALL -d display_errors=on -d display_startup_errors=on -r "$foo = ini_get(\"error_reporting\"); var_dump($foo);$foo = ini_get(\"display_errors\"); var_dump($foo);$foo = ini_get(\"display_startup_errors\"); var_dump($foo);"

phpdave

<?php
require_once('vendor/autoload.php');
$_SERVER['APPLICATION_ENV']='development';
$_SERVER['APPLICATION_URL_PREFIX']='development.';
StartSeleniumServer();
RunTests();

function RunTests()
{
    $tries=100;

phpdave

DELIMITER //
BEGIN 
  CREATE TABLE QTEMP.TEST1 AS (SELECT * FROM MYLIB.MYTABLE)
  WITH DATA;
  CREATE TABLE QTEMP.TEST2 AS (SELECT * FROM MYLIB.MYTABLE)
  WITH DATA;
END //
DELIMITER ; 
SELECT * FROM QTEMP.TEST2; 
SELECT * FROM QTEMP.TEST3;