• ALCOBJ on a Data area

    Hi , I have one program which starts a job , I do ALCOBJ on a dataarea so that if the job is already running and someone tries to start the job again i can show the error that job is running ALCOBJ OBJ((&LIBLDTAQ/&DTAAA *DTAARA *EXCL)) WAIT(0) MONMSG MSGID(CPF1002) EXEC(DO) SNDPGMMSG...

    asakla240 pointsBadges:
  • CLP Programming

    PGM DCLF FILE(AMITLIB/STUDPF) LOOP: RCVF RCDFMT(STUDRRC) MONMSG MSGID(CPF0864) EXEC(GOTO CMDLBL(END)) SNDUSRMSG MSG(&NAME) OPNQRYF FILE((AMITLIB/STUDPF)) QRYSLT(*ALL) GOTO CMDLBL(LOOP) END: ENDPGM it displays only the first data in the file. how to display all the records present in the file?

    jainamit380 pointsBadges:
  • List of users who are members of a group profile

    How do I create report that show a list of users who are members of an AS/400 group profile?

    harpsk95 pointsBadges:
  • PTF on AS/400 not getting installed and applied

    While applying PTF's SI38079 AND SI38080 for V7R1, it keeps coming back as not installed.

    harisudhan211,005 pointsBadges:
  • About library list in AS/400

    Hi, there is a source library for me where I created a module and I binded it to a program with the command 'CRTPGM'. Now I have created the object of that module in the object library. Now my question is how do I need to organize the library list when the things are as following. Input files are...

    JSDHFKJHA335 pointsBadges:
  • Add a new field in PF

    Is it possible to add a new field in an existing PF without deleting the records that are present in it?

    jainamit380 pointsBadges:
  • External domain Vs Internal web server

    Hi, One of my client like to integrate the external domain with internal web server. For example aaa.com [external domain] points towards internal web server aaa.local. Can someone guide me to achieve this in the minimal time frame? Thanks, Ajay

    ajay2050in5 pointsBadges:
  • User prompted for AS/400 log on when using Excel Add-in to upload data.

    I have users that are uploading data to the AS/400 (V6R1) using the Excel Add-in. One user gets a log on pop up window each time she initiates the data transfer. Others in her same group do not. Where would I go to turn this off? She is logged on an AS/400 session and it is still prompting for a...

    CChristo15 pointsBadges:
  • AS/400 / CF DESC

    Hello I am trying find a way to change the Customer Friendly Description in the SKU (SKN) DESC. 

    AFNAN1198910 pointsBadges:
  • Adding values to second member of PF

    Suppose I have a PF named 'Member' and I have added a new member 'Mbr1' to this pf. How can I add values to the second member(Mbr1)?

    jainamit380 pointsBadges:
  • Communication link failure. A time-out occurred trying to connect to the iSeries Setup

    I have a Linux ODBC that pushes data to the AS/400. When I am trying to connect my ODBC Linux connection, it fails and logs the following error message: [rduser@ebsdbprod ~]$ isql -v misysdb erp0101 [08S01][unixODBC][IBM][iSeries Access ODBC Driver]Communication link failure. comm rc=10060 -...

    EBSERP30 pointsBadges:
  • Lost my SQL log

    SQL statements from a session (first session) have been lost because I opened a second SQL session and saved this when exiting AFTER exiting my first session. So, when I STRSQL, I only see the statements from my second session, those from the first session are gone. Can I somehow retrieve the...

    usuala20 pointsBadges:
  • Copying records

    Hi, I need to copy file with records from one server to another server. For example, File1 from server1 has 1000records. I need to bring this to server2.

    22917510 pointsBadges:
  • Block Crystal Reports from iSeries access

    We have a user who wants to use Crystal Reports to access data on an MS SQL server. She also has access to view limited data on the iSeries using an iSeries application with built-in security. How can we prevent her from accessing data on the iSeries using Crystal Reports. Is there a service we can...

    WoodEngineer6,305 pointsBadges:
  • WRKQRY Call LOADITMCL

    When I run a WRKQRY for ITEMSQRY after I'm done query completes fine. I use Call LOADITMCL to load the WRKQRY but when I run call LOADITMCL application error. cee9901 unmonitored by LOADITMCL at statement 0000000600, instruction x’000. This does work in our production side but in test it doesn't....

    jcmunoz11825 pointsBadges:
  • About programming in AS/400

    I have a field in a file which is of alphanumeric type with a length of 15 and I'm going to store a string in that which is of 11 length and the string will be 'CAS00TST01A'. Now I want to extract the letter which is at 11th position i:e 'A' and i want to convert it to numeric. Could you please let...

    JSDHFKJHA335 pointsBadges:
  • AS/400…How to batch purchase order entry from an EDI transmission

    How can purchase orders received from an EDI transmission be 'bulk entered' from a CSV or Excel file into the AS/400?

    reggiecr10 pointsBadges:
  • Client Access

    I have a Ricoh sp3500n connected to a PC running Client Access for AS/400. Font is wrong. How do I change it. I've tried change printer models in the AS/400 device description.

    Jamie2210 pointsBadges:
  • Length of the entered value

    Hi group, How to get the length of the entered value using WRKQRY? I am querying a file, the name field is defined as 15 characters. I need to get all those records whose name is greater than 10 Characters. Could anyone please help me how to write a query? Regards, M

    mvrkrishna530 pointsBadges:
  • Write PF using RPGLE

    HI ... I tried to add a rec in my PF (sample1).. but my PGM run successfully .. but the rec haven't added in my PF .... I shared my PGM here sample1 uf a e k disk usropn open sample1 eval empname='Sathis' eval empno=13 eval addr='ramnad' write rec close sample1 eval *inlr=*on Please help me on this

    12we40 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