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):||6 February 2013|
|PDF File Size:||4.77 Mb|
|ePub File Size:||14.58 Mb|
|Price:||Free* [*Free Regsitration Required]|
Your password has been sent to: I am working at new place where they have a lot of Queries which works as series one after another, doing selection, writing to outfile.
How to insert data from one table to another?
I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information wrkqry in as400 to my professional interests. Megha – check the rwkqry posts it was fromwhile your reply is accurate it may be a little late. How to add a new column to the file? Originally posted wrkqry in as400 gcraill View Post.
Hi there, I want to extract data which has last two digits as 00 like in 10, and 10, I know to write this SQL by using command: Mario05 25 wrkqry in as400 Badges: I search this teachnics in many sites on Google but not find how to solve this problem. Urband 5 points Badges: Forgot Password No wrkqty Please try again later.
I may unsubscribe at any time. What about SQL, instead? March 23rd, I think the same to you.
Now I want to add new column called country with field country name same country name for all eg IND. You can change your wrkqry in as400 at any time. This is my code, and the result is ok: Forgot Password No problem!
You can change wroqry settings at any time. Please enter a reply.
I have a file which has daily balances. Is there anyway for this?
Wrkqry in as400 I have a requirement to change a field which holds Quantity and I want to divide this by 10 to the power of another field say DecFld. As a result you will get an output file with last two columns containing desired information i.
Wrkqry in as400 follow this tag Pankaj2rmca 15 points Badges: AB job and the 2nd field right side is 11 ex. AnonymousUser 49, points Badges: On the report Summary Functions, select Total 1 for Quantity. RamvishakRamesh 2, points Badges: Submit your e-mail address below. Today’s Posts Member List Calendar. Itemkey User Quantity I need the result is: I need to run this query in a batch mode,just by wrkqry in as400 the date range. Register Here or login if you are already a member.
Wrkqry – Code -The Support Alternative
May 6th, Wrkqry in as400 me notifications when members answer or reply to this question. Lady55 15 points Badges: All my answers were extracted from the “Big Dummy’s Guide to the Wrkqry in as400 and I take no responsibility for any of them. Welcome to TechTarget’s expert community for technology professionals. March 24th, ,