Creating an as400 QueryAs400 Query, QUERY/400 as it used to be called or IBM Query for Iseries, which is whats shown these days on the Installed Licensed Programs screen (GO LICPGM Option 10) is probably one of the most widely used tools on the as400. This tool has a very straightforward user interface, so is often used by both technical and non technical staff (with relevant training of course).
This pack will let you create low poly warrior characters for your game. Skeleton compatible with Mecanim and the whole Mixamo library so you can start making amazing animations in seconds. All prices are exclusive of tax.
Its a very easy to use tool for displaying, extracting and reporting on data. Query is a separate chargeable product, but I don’t think I have ever worked at a site that didn’t have it installed on all their systems, so you can be pretty sure almost every AS/400 will have the IBM provided query language QUERY/400.As an example, we will write a query over a typical database file that almost every business system has, the CUSTOMER master file. After extracting the data we will create a report.At the as400 command line type in WRKQRY and hit ENTER:-Work with QueriesType choices, press Enter.Option. 1=Create, 2=Change, 3=Copy, 4=Delete5=Display, 6=Print definition8=Run in batch, 9=RunQuery. Name, F4 for listLibrary. QGPL Name,.LIBL, F4 for list-We will create a query to view the data in the CUSTOMER master file. Type in 1 for the option to create a query and the press ENTER.-Define the QueryQuery.: Option.: CREATELibrary.: QGPL CCSID.: 65535Type options, press Enter.
Press F21 to select all.1=SelectOpt Query Definition Option1 Specify file selectionsDefine result fieldsSelect and sequence fieldsSelect recordsSelect sort fieldsSelect collating sequenceSpecify report column formattingSelect report summary functionsDefine report breaksSelect output type and output formSpecify processing options-Next 'Specify file selections'. This is already selected by default so just hit ENTER and you will see:-Specify File SelectionsType choices, press Enter. Press F9 to specify an additionalfile selection.File. Name, F4 for listLibrary. QGPL Name,.LIBL, F4 for listMember.FIRST Name,.FIRST, F4 for listFormat.FIRST Name,.FIRST, F4 for list-Enter CUSTOMER (or whatever your customer master file is called) as the file you want to query and YOURLIB (replace with your relevant database library) as the Library and press ENTER.
Pressing ENTER again will take you back to the Define the Query screen.The next option down, the Define result fields option, is described thus: “Select this option either to define one or more new fields tobe used as result fields or to see what result fields are already defined for the query. The new fields will hold the results of arithmetic, character, or date and time operations done on other fields in this query”. In this case we don’t need any result fields so we can ignore this option for now.We do need to select fields that we want to report on. Type 1 next to 'Select and Sequence Fields' and press ENTERYou should now see:-Type sequence number (0-9999) for the names of up to 500 fields toappear in the report, press Enter.Seq Field Text Len DecCUSTN Customer Number 10 0CUSTNA1 Cust.
Name & Address 1 50CUSTNA2 Cust. Name & Address 2 50CUSTNA3 Cust. Name & Address 3 50CUSTNA4 Cust.