• Retrieving the name of a file from object links

    We are receiving a Daily file containing Chassis information via FTP at a scheduled time in the early morning. I have written a process to automatically retrieve this file, CPYFRMIMPF to my Physical File, then process the data into our Chassis Master. Originally, I was told it would be a specific...

    Eric Witham690 pointsBadges:
  • Getting DB2 data into SQL 2008 database

    We have a web service for placing orders and sending them to our iSeries. Basically front ending the EDI package on the iSeries. If the data is sent over without errors on the SQL insert to the DB2 databases the job runs. If there are run time errors during order processing the errors are logged to...

    ToddN20008,560 pointsBadges:
  • Arrays in AS/400

    I declared an array which is of character data type and I want to overlay an element in the array which is of decimal type. Is it possible to overlay an element which is of decimal type (zoned) in to an array which is declared as character one? The code of the following issue is like this: ipd:arr1...

    JSDHFKJHA335 pointsBadges:
  • SQL insert error in php

    When my php executes the db2 insert, I get error 7008. Any ideas what I might try to get it working ? The PF is new with *all public authority and no trigger nor journal. I manually added 1 record via green-screen SQL with the same context as what is assembled in my php. Here's the actual code in...

    aceofdelts1,850 pointsBadges:
  • Disk percentage

    If current ASP is 65% used from 10TB and if 1TB is removed from the rack how much ASP percentage would get increased? I said it is 75%. Can anyone improve this answer?

    Explorer1910240 pointsBadges:
  • RPG – Roll your own level breaks

    Has anyone every heard of 'Roll your own Level Breaks' in RPG? Can you enlighten me on how it works? I have to mimic a program that does this already with a different set of data. Here is a basic overview of the application. A selection screen allows you to select a date range, region, territory,...

    NickHutcheson11,380 pointsBadges:
  • Recovering objects without object detail

    How to get the saved object details from the backup tape, when the library which contains the objects is saved without object level details.

    KapilR10 pointsBadges:
  • About EVALR Opcode

    Could anyone let me know what is an EVALR Opcode in AS/400? If possible, can anyone give me some sample code which is on EVALR Opcode?

    JSDHFKJHA335 pointsBadges:
  • File Status 90 during open

    Hi, I have a logical file, which I am trying to open in I-O mode, but I get File status 90 File is existing on the system, The code was working fine previously (on development machine), but today I installed all the objects on another machine (Testing machine), and I am getting this file status,...

    asakla240 pointsBadges:
  • 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:

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