Query/400 provides many options for converting data, particularly dates, but lacks one important feature – converting character to numeric. However, there is a workaround even… Read More »Converting character to numeric with iSeries query

Many legacy systems stores dates in 6 digit numeric fields. This makes comparison difficult during a Query’s select statements. However, there is a way to handel these dates… Read More »Comparing numeric dates 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… Read More »Converting ddmmyy to ccyymmdd using iSeries Query

On the sending machine:   Create a temporary library & save file for the transfer CRTLIB TmpLib CRTSAVF TmpLib   Copy object to the temporary… Read More »Sending Objects Between iSeries Machines

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… Read More »Enabling a disabled profile ODBC