Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: iSeriesRules
- Order by date
-
SQL need help on WHERE clause
Perhaps you need to be casting the strings as date fields... WHERE CAST( DIGITS(CC)|| DIGITS(YY)||'-'|| DIGITS(MM)||'-'|| DIGITS(DD) as date) + 2 days > CAST( DIGITS(CENT)|| SUBSTR(DIGITS(YYMMDD), 1, 2)||'-'|| SUBSTR(DIGITS(YYMMDD), 3, 2)||'-'|| SUBSTR(DIGITS(YYMMDD), 5, 2)) as...- iSeriesRules
- Post #5
- Forum: RPG (Report Program Generator)
-
How to change writer on a remote system AS400 ?
Verify SNA connectivity to the remote system with the APING command. If the systems are on different networks, (DSPNETA to see "Local Network ID"), you have to use the network name and the system name for both APING and RUNRMTCMD. If the remote system (BOB) has "Local Network ID" of APPN1, and...- iSeriesRules
- Post #9
- Forum: RPG (Report Program Generator)
