AS/400 administration, AS/400 backup, AS/400 command functions, AS/400 commands, AS/400 database, AS/400 DB2, AS/400 development, AS/400 error messages, AS/400 errors, AS/400 FTP, AS/400 jobs, AS/400 objects, AS/400 performance, AS/400 printing, AS/400 Query, AS/400 security, AS/400 Spool Files, AS/400 Subfiles, AS/400 user profiles, BRMS, CL, CL Program, CL programming, CL programs, CL/400, Client Access, CLLE, CLP, COBOL, DDS, i5, i5/OS, IFS, iSeries, iSeries RPG programming, iSeries V6R1, OS/400, Physical File, PTFs, RPG, RPG ILE, RPG/400, RPGILE, RPGLE, Spool files, SQLRPGLE, Subfile, V5R3, V5R4, V6R1 VIEW ALL TAGS
How to convert numbers saved as characters into digits. Is there any Query instruction to convert Characters into Digits? I'm trying to link 2 files, and one of the fields is character in one file and digits in the other, so I can't link them. For example: 00877874 is saved as character in...
Is it possible to view the SQL that is generated by a query created in Query for OS/400. I have the query defined as I want it and would now like to give the SQL script to my development team to use in automating reports by accessing the database directly.