Sometimes you happen to have a problem with one of your MySQL queries and you simply can’t seem to understand why. Well, one thing that helps is to use the mysql_error() function. This function returns the message of the MySQL error you’re getting. Example: $action = “INSERT INTO table (name, […]
Recently I had this case where a PHP session ($_SESSION) was not being passed from a web site to WordPress. Basically, WordPress was installed and configured to be part of a web site and there was the need to use Sessions to control the login/logout process of the site. Although […]
Some people dread the idea of having to update the Linklist dynamically but in fact it’s a very simple process: Update the PROGxx member that your system uses from PARMLIB: Add/remove libraries as required Change the LNKLSTnn reference to LNKLSTnn+1 Issue the following MVS commands: SETPROG LNKLST,UNALLOCATE P LLA SET […]
An LPAR can have more then one PARMLIB dataset defined to it’s concatenation. The PARMLIB concatenation is defined on the LOADxx member and we can use the MVS command “D PARMLIB”to list it. Example: “D PARMLIB” command returns: RESPONSE=LP1T IEE251I 08.54.47 PARMLIB DISPLAY 825 PARMLIB DATA SETS SPECIFIED AT IPL […]
For the sake of this example, let’s assume that: we want to work with records older then 60 days the table name is ‘table’ (how original!) the table field with dates is called date_field 🙂 DELETE FROM table WHERE date_field < DATE_SUB(CURDATE(),INTERVAL 60 DAY) This MySQL command deletes all table […]
Copyright © 2019 Rui Miguel Feio