Tip A: What can I do with WOW entry? This application shows iSeries data with the following business functions: [TABLE]You can do anything as long as your data is in a relational format. WOW does all the hard work for you. This application was created in 15 minutes. Tip B: Ports
'); // -->
mso-font-pitch:variable; mso-font-signature:50331648 0 0 0 1 0;} @font-face {font-family:"Trebuchet MS"; panose-1:0 2 11 6 3 2 2 2 2 2; mso-font-charset:0; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:50331648 0 0 0 1 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Trebuchet MS";} pre {margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Courier New"; color:black;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> Signon Verification as-signon 8476
9476 I use a freeware utility called Scan Port, which can scan a URL and check what ports are open. [TABLE]To use it, download the utility and enter your system or Web site address into the System field, then enter a range of ports to scan. The Open radio button will show the ports open at that address specified. It works pretty slick. Tip C: SQL searches that aren't case-sensitive The key items here are the use of the "UPPER" SQL clause, which forces both the field's value and the user's entered value to uppercase. The "CAST" clause is required by SQL to indicate the value entered will be a character field. The "?" is for the prepared statement and will be set after the user enters a search value for city. You can try it out here: http://www.planetjavainc.com/wow63/runApp?lvid=1462&_pj_lib=wowsamp60 From the example, enter 'dallas' for the city, then click search. Next enter 'DALLAS' and not the behavior. Tip D: Optional SQL searches The key items here are the use of the "VALUE" SQL clause, which takes the first non-null value and uses it in the selection criteria. You can try it out here: http://www.planetjavainc.com/wow63/runApp?lvid=1463&_pj_lib=wowsamp60 From the example, enter nothing for the city, then click search. All records will be returned. Next enter 'DALLAS', and only customers in Dallas will be returned. For further details on using SQL Value, check out this previous tip: http://search400.techtarget.com/tip/1,289483,sid3_gci965490,00.html Summary ---------------------------
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| iSeries Security - Security Tools, Physical Security and System Security |
| About Us | Contact Us | For Advertisers | For Business Partners | Site Index | RSS |
|
|
|
|||||||