Active Directory, AS/400, Business Intelligence, Career Development, CIO, Database, DataCenter, Desktops, Development, Exchange 2003, Exchange 2007, Hardware, iSeries, IT Strategy, Linux, Lotus Domino, Lotus Notes, Management, Marketing Technology, Microsoft Access, Microsoft Excel, Microsoft Exchange, Microsoft Windows, Mobile, Networking, Oracle, OS, Outlook, Outlook 2003, Outlook 2007, Routers, RPG, RPGLE, SAP, Security, Servers, SQL, SQL Server, SQL Server 2005, Storage, Tech support, Virtualization, Visual Basic, VoIP, VPN, Windows 7, Windows Server, Windows Server 2003, Windows Server 2008, Windows XP VIEW ALL TAGS
I have a file which has 6 different account numbers. For each of this account number, I need to check in File1 which has account number, security and Quantity. I need to sum up the qty field for a combination of Acc num and security. Once I get the security, I need to search in another file say...
I am using SQLRPGLE program,need to handle record lock in sql statement ..plz suggest?