![]() ![]() ![]() Line 9: I want my results in: Query library, Query name, and file id order. Line 8: I only want the results for files. Line 7: The name of the output file the results are contained within. I think the column headings I have given them adequately describe their contents. Lines 1 – 6: I am only interested in some of the columns/files in the output file. Once the output file is generated I can get to the information I desire by using SQL. If you are going to be running this for a library that contains many Query Definitions you might want to submit this command to batch. I have also called the output file OUTFILE, any valid name for a file could be used. Line 4: I have said I want my results in the same library as the one I getting the data for, but it could be any library. Line 3: This is where I must enter *QRYDFN so that I will only get the results for what I want. Line 2: I want the results to be written to an output file, see line 4 for which file I want to use. ![]() Line 1: I only want the results for the all of Query Definitions in the library MYLIB. If I wanted to list all the files used by all of the Query definitions in the library MYLIB I would use the following: ![]() I use the Display Program Reference command, DSPPGMREF, to generate the output file. The first process is to create an output file that contains the data. To generate a list of the files they use is a two-step process. The Query/400 object is called a Query Definition, and is the following object type: *QRYDFN How can I discover the files used by all the Query/400 objects in a library? Integration - Integrating with Java ,Unix, Nutech-WMS, Sabrix, Vertex, Engineering CAD software such as AutoCAD, Revit & ProE, SQL server, MS office products like Outlook, Excel using products such as WebSphere MQ, LANSA Integrator.Įxperts in AS400 support tools like neutch WMS, TL Ashford – Barcode system, Sequel, Hawkeye Pathfinder, Vertex– Tax Solution, ACOM- Document Output, FaxStar– Faxing Solution, RJS Document Management.This is a question I am asked enough for me to want to write this so I can direct the askers here. ISeries Application Development - WebSphere(R) Development Studio, Visual Lansa Framework, Lansa Workflow Framework, Lansa Open for. ISeries Modernization: Modernizing legacy systems using Visual Lansa - Lansa Axes, Lansa Newlook, RAMP From Lansa, ANSA VRPG - ASNA Monarch, WebSphere Development Studio, Microsoft. ERP expertise:Infor - System21/JBA, MAPICS, BPCS, JD Edward, JDA, SAP etc. Over 400+ value addition projects in AS400 / iSeries arena, Over 200 projects in Infor System21, Profound knowledge and experience in AS400 / iSeries Application Development, Modernization, Integration, System Administration & Technical Support. "Focus on AS400/iSeries since inception" / ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |