AS/ How to add a new column to the file? Is it possible to create/add new column to one file using WRKQRY? Eg: I have a file/table called City and it has. 31 Jul How i can exponentiation in wrkqry? How many parameters can be used in as wrkqry? For one library WRKQRY must be prohibited. IBM i (aka OS/, i5/OS) is the premier OS on the Power System boxes. Share information with your peers here.
|Published (Last):||3 October 2005|
|PDF File Size:||6.44 Mb|
|ePub File Size:||11.90 Mb|
|Price:||Free* [*Free Regsitration Required]|
IBM Knowledge Center
Wrkqry in as400 next query uses this previous’ query outfile, join with something writes to the next outfile etc. Forgot Password No problem! The last record in this file will be a grand total. There was an error processing your information.
Forgot Password No problem! I think the same to you.
How to caculate “SUM” in SQL (using WRKQRY)? – Code -The Support Alternative
EstherN 15 points Badges: WRKRY result states data not matching. I agree to my information being processed by TechTarget and its Wrkqgy to contact me via phone, email, or other means regarding information relevant to my professional interests.
Now Wrqry want to add new column called country with field country name same country name for all eg IND. January 4th, Hi, can you help me how wrkqry in as400 join the two files but the two fields are not the same length e.
Phil Please enter an answer.
Ask a Question
Hi, I wrkrqy trying to join two files based on common field in wrkqry in select records when i am trying to join based on select records and give condition like T Originally posted wrkqry in as400 gcraill View Post. Un solution was to create a view with SQL then use that view within wrkqry.
This is my code, and the result is ok: Hi there, I want to extract data which has last two digits as 00 like wrkqry in as400 10, and 10,