• Dynamic SQL in RPGLE

    I am building a dynamic SQL in RPGLE with a wildcards. It does not work like a native SQL statement. A search for "FRANK" will search on 6 characters (retrieve all the FRANK and the FRANKL, but not the FRANKLIN). A search on "FRANKL" will retrieve the FRANKL and the FRANKLIN. Any help would be...

    davidgrant10 pointsBadges:
  • AS/400: How to perform IPL?

    What are the basic steps to perform IPL in AS/400?

    Karthik20845 pointsBadges:
  • Logical file DDS change

    Hello all, if I change a logical dds and recompile it only with the physical. Do I need to recompile the program, because I check the program has the same file level identifier as that of newly compiled logical.

    koolsid78625 pointsBadges:
  • Logical file source

    If we have object of logical file, how can I find the source wrt object?

    koolsid78625 pointsBadges:
  • AS/400: How to remove and validate default password and limit capability parameter

    How do I remove / change and validate default password, limit capability parameter?

    yaminirosy5 pointsBadges:
  • Is it possible to get a PDF from AS400 spool file?

    Is this possible? Is it really possible to get a PDF from spool file? Nothing seems to work. :-( I was trying to convert PDF in iSeries Navigator. I put a spool file, right click, convert to pdf, asks me whether I want a new printer, I say yes, starts a printer then a writer but then everything...

    Avrelivs80 pointsBadges:
  • CPYFRMIMPF command successfully copies to PF but resulted to special characters on PF

    I have created new directory in AS/400 named MMVRADIR with subfolder MMVRAFLR. I have a CL program using CPYFRMIMPF command to restore the content of a txt file inside "MMVRADIR/MMVRAFLR/APDM082716.TXT" to AS/400 physical file SMREB33F. The CPYFRMIMPF was able to copy the contents but when I runqry...

    KAILOFOXS5 pointsBadges:
  • OPENQRYF: Unmonitored message CPF9899 occurred at statement

    Hi All I had made the changes in the program and debug the same but while debugging it gives me the following message at open query file line as: Unmonitored message CPF9899 occurred at statement. OPNQRYF FILE((F60SLB05)) QRYSLT('YTAN8 *EQ ' *CAT + &EMP *CAT ' *AND YTATIM *GT &STARTDATE +...

    Anshul14095 pointsBadges:
  • Modify QINACTITV to a limited number of users

    Sir, how do you configure a limited number of users where the objective is that the session of these users will not automatically sign-off. Because the way i understand it, this is done using WRKSYSVAL SYSVAL(QINACTITV) but this approach will affect all users and this is not what i intend to do. i...

    danmd5systemad370 pointsBadges:
  • Use of CCSID in AS/400?

    What is the use of CCSID in AS/400 Physical File? How it is important? What are the considered/configured to be noted when we develop web application in AS/400 with native DB2 database?

    Sureyz2,735 pointsBadges:
  • AS/400 display program message

    I am seeing this message from a lot of my users when they try and access the routing application within the AS/400. It has 4 options to answer the message but none seem to do anything. The exact wording is" Job 408069/ED/QPADEV0160 started pm 7/25/16 at 08:46:10 in subsystem QINTER Message queue Ed...

    whaline5 pointsBadges:
  • RPGLE validation

    How can I do a validation like first 3 words character and next 5 must be number in RPGLE?

    Vishalsuryavanshi15 pointsBadges:
  • Converting Float to packed

    I am trying to convert a Float8 to a 17 6 Packed and I am loosing 1/100000th of the value of the decimal portion. The packed result is 1/100000th less than the Float value. How do I stop this from happening? I am calculating taxes.

    Kcgto4550 pointsBadges:
  • iSeries sending emails to a group

    We would like to emails sent from the iSeries to a group when a job that runs at midnight unattended has an error message. How do we set this up?

    bwb1011115 pointsBadges:
  • How DB2 converts the FLOAT value to IEEE floating-point format?

    I had created a SQL table as below: CREATE TABLE MYLIB/Mytable (FLD1 FLOAT (9) NOT NULL WITH DEFAULT) When I ran DSPFFD, I had seen that FLOAT(9) gets converted to 3F 2. So, I want to understand how does it happen? Which algorithm is being used?

    manojibmi5 pointsBadges:
  • How to get nth highest salary using SQL/400 query

    Hi, How can I get nth highest salary from a PF named EMP having two columns EMPID and ESAL need to retrieve nth highest salary using SQL/400 query. Here N may be first, second,third any no.  Thanks!

    6r1,850 pointsBadges:
  • AS/400: How to check the list of source libraries inside a library?

    In AS/400, how do I check the list of source libraries inside a library?

    Ruchik15 pointsBadges:
  • Passing parms to Query400

    Has anyone ever come across a method of passing a parm into a query run - such as a date?

    Abbey120 pointsBadges:
  • If an account has \’Initial Program\’ =*NONE and \’Initial Menu\’=*SIGNOFF, the parameter \’Limited Capabilities\’ is not relevant. The account cannot be us

    If an account has 'Initial Program' =*NONE and 'Initial Menu'=*SIGNOFF, the parameter 'Limited Capabilities' is not relevant. The account cannot be used on the command line. Is this true? What about if user is restricted to only one program? Could you elaborate on Initial menu and initial program,...

    aldc12310 pointsBadges:
  • Code for BI Publisher template

    In BI publisher, report should be populate in long name, for that I need code to insert in template RTF.

    zyngapoker5 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