MySQL
MySQL

How to identify a MySQL query problem

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, […]

FAQ
MVS

Update Linklist dynamically

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 […]

Command keyboard key
MVS

Display PARMLIB concatenation

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 […]

MySQL
MySQL

Work with records older then x days

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 […]