How to identify a MySQL query problem

July 1, 2009 Rui Miguel Feio

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

Update Linklist dynamically

June 29, 2009 Rui Miguel Feio

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

Display PARMLIB concatenation

June 29, 2009 Rui Miguel Feio

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

Work with records older then x days

June 29, 2009 Rui Miguel Feio

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

1 40 41 42