Latest Posts

Converting ddmmyy to ccyymmdd using iSeries Query

The example below shows how to convert a six digit numeric date in DDMMYY format to an eight digit date using Query for i5/OS. Conversion takes place into CCYYMMDD and DDMMCCYY formats. Just replace example field mydate with your six digit numeric date. A date-window concept is used to interpret the year and the field window defines the […]

Sending Objects Between iSeries Machines

On the sending machine:   Create a temporary library & save file for the transfer CRTLIB TmpLib CRTSAVF TmpLib   Copy object to the temporary library CRTDUPOBJ OBJ(MyProg) FROMLIB(MyProgLib) OBJTYPE(*PGM) TOLIB(TmpLib)   Save the temporary library to save file SAVLIB LIB(TmpLib) DEV(*SAVF) SAVF(TmpLib)   Send the save file to the other machine SNDNETF FILE(TmpLib) TOUSRID((userName […]

Enabling a disabled profile ODBC

You can re-enable a user profile that has become disabled by using iSeries™ Navigator or by changing the user profile. You can also enable a disabled user profile by stopping and restarting iSeries NetServer™. There are three ways that you can enable a user profile that has been disabled. To use iSeries Navigator to enable […]