• SQL table in RPG

    I need to read an SQL table (file) in RPG and select certain records. I'm pretty green in SQL. Anyone have a sample they could share? I'm better at RPG than ILE but I'll take what I can get. Thanks!

    Brenger170 pointsBadges:
  • Find user-related list of AS/400 libraries

    how to find out one user id related list of libraries in as400 system,not all libraries in system,only one user id related libraries

    madhuchowdary350 pointsBadges:
  • Saving Spool Files, and Restoring Spool Files in AS/400 iSeries

    Hello Does anyone know if there is a utility program out there, that would serve in saving spool files on one AS/400, and then restoring these spool files to a different AS/400. Not sure what methods are available, but I am thinking of using CPYSPLF to database file, and then from here, saving to...

    Piano520 pointsBadges:
  • AS/400 – CL/RPG

    It's a general question, which data type supports for both numeric/decimal and character in CL/RPG? Please suggest.

    chowas400620 pointsBadges:
  • Finding hidden file in AS/400 library

    How to find hidden file in AS/400 library?

    YantiDiva15 pointsBadges:
  • AS400 libraries

    How to get the libraries list that are created by a single user in AS400?

    TNKR130 pointsBadges:
  • Getting SRC error code c1001020

    I'm getting src error code c1001020 model 520 v5r3m0 not power on. What should I do?

    Dado25 pointsBadges:
  • AS/400-SQL/400 query

    Write an SQL query to the 6th highest salary of employee? I know how to write query for 6th highest salary of employee but it's too lengthy. Can any one simplify this query please. 2nd highest salary: select max(esal) from emp where esal <(select max(esal) from emp) 3rd highest salary: select...

    chowas400620 pointsBadges:
  • I am unable to connect to a share on our AS/400 I have tried mapping it through iNavigator and windows

    I am unable to connect to a share on our backup DR AS/400 I have tried mapping it through iNavigator and windows with no success. Originally we thought it was a network problem. I have a batch program that runs and connects all of my ifs mapping on our production machine and this prompts us for our...

    angelahortega5 pointsBadges:
  • Chat Server for the enterprise

    Can any one tell me about the best chat server for enterprise for internal messaing, file sending & video comferencing is added advantage.

    Jags nitco0 pointsBadges:
  • Configure SFTP on iSeries

    I believe someone has a document how to configure SFTP on the iSeries. Is is possible for someone to email me this document.

    Cavan1235 pointsBadges:
  • Running a data transfer from a CL program

    Is it possible to run a data transfer from a CL program? I can create a DTF file but how would you code a CL program to run it?

    Banjo20 pointsBadges:
  • Printer files in RPG ILE

    How can we create and use printer files in RPG ILE. I'm new to AS/400 and I want to know about printer files and reports as my company asked me to.

    Rpgile25 pointsBadges:
  • How to get system % ASP thru SNMP

    How to get % ASP in AS/400 thru SNMP? Is there OID for ASP used. Thank you.

    MakubeX40 pointsBadges:
  • File Member Select & Encryption in AS/400

    Two questions here. I have been querying a lot of data out of our database, however I have ran into two issues I'm unsure how to solve. 1.) I'm able to find the referenced table, however this relies on a file. RUNQRY QRY(*LIBL/*N) QRYFILE((SCDATA/SCATRNTL username)) I would like to replicate this...

    kparker25 pointsBadges:
  • where can I obtain 122 key IBM 3487 keyboards?

    Does anyone know of a supplier which can supply the 122 IBM 3487 keyboards, preferably new?

    Freddy9995 pointsBadges:
  • *MGTCOL objects

    Can I change a *MGTCOL object into a PF so that later I want to send the data to a text file?

    ten20081,150 pointsBadges:
  • OS/400 Sensitive Commands

    1) How can a user be given the capability to execute the following OS/400 sensitive commands? ADDAUTLE - Add Authorization List Entry CHGDTA - Change Database File (using DFU) CHGUSRPRF - Change User Profile CRTAUTL - Create Authorization List CRTUSRPRF - Create User Profile EDTAUTL - Edit...

    Rex110 pointsBadges:
  • Report size (spooled file size)

    How do I determine a report size from a spool file in CL(using a CL command)? Thanks!

    pwopen12245 pointsBadges:
  • Make history of stream files in AS/400

    Hi, I want to make a history of a Directory in AS400. (Command WRKLNK) for example like this: /EMAIL/WORK Directory WORK consists of stream files (type STMF) organized like this: WRK.001 WRK.002 WRK.003 Etc. On a monthly base I want to move all the stream files older than 1 month to...

    Jerry520 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following