• Improve performance for SQL query reading file having milions of recods (AS/400 – SQLRPGLE program)

    I am fetching only 14 records each time from a customer file(physical file)  having milions of records. This file has 46 fields. Fetch is done in the follwoing manner, but it takes longer time - SELECT * FROM  CUSTOMER A WHERE A.CLINM1 LIKE 'B%' AND (CLINM1 <> '' OR  CLIPR1 <> '')...

    AnjaliR65 pointsBadges:
  • User Profile Creation Date

    How can I get the User Profile Creation Date for all my user profiles in one report?   I would be nice if this was in the same report as my DSPUSRPRF report which has all the other parameters I need, but Audit want to see when they were created . . . Don't you just love 'em   Thanks in advance Guy

    Guy553435 pointsBadges:
  • Spooled Files sent via SNDDST

    Our system runs reports at night to an outq. Upon completion of reports a program goes through and converts the spooled files to PDF and emails using SNDDST and then deletes the spooled files. My problem is that last night for whatever reason the program finished successfully without errors and...

    filuphaze475 pointsBadges:
  • How to get the Job attributes of a relatively old spool file

    how can I retrieve JOB(NUMBER/NAME/USER) of a spool file generated by other user few days ago, I know the spool file name and I am able to view all that I need through the command WRKSPLF and pressing F11, but I need to automate the process.

    Bonx5 pointsBadges:
  • Printer files with width greater that 255

    I am trying to create a printer file with PAGESIZE as (66 375) but its giving me error that line greater that 255 .. Please suggest how to accomplish this as i have a requirement in which i need a report with width 375 ... Please suggest

    munduuu420 pointsBadges:
  • Want to make a utility to search string.

    [h3 class="groups"> Hi,[/h3] [h3 class="groups">I want to make a utility in AS400 to search a string (Such as file name/PGM name) in my current Library and in all Source physical files if found show PGM and all related files. Like I do trough find string Command. [/h3] It would be also help ful you...

    Builtin100 pointsBadges:
  • RPG Program can’t add in menus

    Dear All, I have created new RPG/400 program. I can't add this program in my menus. Please help me out.

    tahirliaqat1150 pointsBadges:
  • AS400 Virtual IP

    Im trying to implement virtual IP in my AS400 machine. Currently, I have 3 physical lines (eg. ETHLIN01,ETHLIN02,ETHLIN03) running under 1 card. Given my setup, Im having the following concerns. - While connected to Virtual IP, I deactivated one of the physical ports (ETHLIN03), and  the session...

    Jerico125 pointsBadges:
  • IP address for local server

    How do I find the IP address of a file server on my as400

    Lacag100 pointsBadges:
  • Using RPGLE Fixed Format keywords in Free Format

    Hi, How can we use the various keywords in rpgle free format such as sub file next change, key list, etc. It would be more appreciable if some link for reference document is given. Thanks, Vivek Sharma

    VivekSharma120 pointsBadges:
  • EZ-Rad performance tuning software

    Has anyone used the EZ-Rad performance tuning software from MB Software and Consulting? What's your experince with it and the company? Thanks.

    OldSysAdmin945 pointsBadges:
  • User cannot run a job that another use has access to do

    How do I give a user access to run a job?

    658820 pointsBadges:
  • Calling query/400 through CL

    Hi, Is it possible to call query/400 through a CL program? Please suggest some idea.. Thanks, Jayashree V.      

    VJayashree185 pointsBadges:
  • creating VL, PO, data selection for CL

    Hi, Is it possible to create VL, PO, data selection for a CL program?

    VJayashree185 pointsBadges:
  • Library is taking long time to save than before in BRMS

    Hi, Greetings for the day! I write this email in reference to a query related to BRMS. There is one library which is taking a long time than usual, however there is nothing in the log where i could find the reason for it. Control group is running as batch under SBS-QCTL. There is no change in...

    Aahana5 pointsBadges:
  • Execute SQL SELECT via RUNSQLSTM error

    Trying to execute SQL-statement "SELECT * FROM mylib/myfile" give errormsg SQL9010. Some say that SELECT is not supported with RUNSQLSTM, but IBM command parameter text indicates otherwise. Is SELECT supported and what am I doing wrong?

    DanTheDane2,555 pointsBadges:
  • Printer IP’s

    How do I get a list of all my printer IP addresses in one report without having to go into the set up of each individual printer. I have 3000 and that would be a nightmare.

    Guy553435 pointsBadges:
  • DB2 database on Iseries

    Ho can I get the size of a DB2 data base on a iSeries platform

    Tomotsk75 pointsBadges:
  • Cum and Group PTF’s

    I am trying to install all the Cum and Group Ptfs for V6R1M1, I am having an issues to install them. They are showing in not installed status after loading, I tried to APYPTF *perm with IPL, but it work for 5761999 not for others product. I ma getting the below message if i try to load and CUM and...

    Mani1017130 pointsBadges:
  • lattory number creation

    sir, i want create a lattory numbers with 6 digit . so, please send me code

    421380 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following