• Need an iSeries SQL that will reduce mutilple entries to one per type

    I need to produce an extract that is a combination of two files. File A has a policy number and a folder type. File B has the document number. File C will be the product of File A and File B. I can join the files on the policy number and folder type to get the document number, however, I need to...

    FCARPENTER200 pointsBadges:
  • calling java function running on websphere from as/400

    How to call a java program running on web sphere application server from System i? We are able to call a java program deployed on System i on IFS directory using RPG ILE.

    Uiiuo50 pointsBadges:
  • AS/400 report takes too long to print

    I have created a invoice on my as400 with a overlay. I send this to a printer and it takes very long to print. The file size is 28kb. Is there something i can do to make it print faster

    Trev25 pointsBadges:
  • AS/400 object location in library

    Hi, I am a very new user to AS/400. I am using a RUMBA client and part of my "ticket" is entered through a free notes section. I can query other items such as customer name, dates, numbers etc etc, but i do not know how to locate where the object is for the "free notes" section to query this for my...

    Markmark10 pointsBadges:
  • RSTLIB and Journaling

    I am doing a SAVLIB of our Production Data Libraries creating SaveFiles on our Production iSeries, then thru FTP, transferring the SaveFiles to our Development iSeries, then doing RSTLIBs. During the RSTLIBs I get a CPF7085 - Journal QSQJRN already exists and CPF3756 - JRN QSQJRN not restored. It...

    wpoulin2,480 pointsBadges:
  • Can I backup to disk with BRMS?

    Can I backup to disk with BRMS?

    Webdevyahoocom5 pointsBadges:
  • Converting to .txt

    Hello All, I'm trying to convert an AS400 database file to a .txt with pipe delimeter and I want to make the .txt file name a batch number. 0012345.txt Any help is greatly appreciated.

    Breinhart45 pointsBadges:
  • RUMBA macro to append data

    Hello, I am a new user to the RUMBA AS400 client. I am trying to make a macro that appends all the data that is copied. But i can not find an option for it. I have found copy all but i can not make the keystrokes to use the append data feature. If someone knows the answer i would greatly appreciate...

    Markmark10 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:
  • Data QUEUE – Remote location ….. for program device DDMDEVICE was not found

    When trying to use a remote DATA QUEUE the send and receive data queue commands failed giving : Service with protocol tcp not found. Cannot establish DDM connection with remote system. Operation on DDM data queue DTAQFIFO in TESTLIB failed. Remote location MYAS400 for program device DDMDEVICE was...

    SBCHenry30 pointsBadges:
  • Mapping to IFS from another domain

    Iseries and AD profiles are synch'd for mapping IFS Shares. We now have other users from another domain accessing the shares, If the get the windows Signo window what need to be inputted?

    Rickmcd1,605 pointsBadges:
  • Iseries fails to boot

    I have a v5r4 820 model that failed. Error code in display is 284C3203 which pointed to I/O problem for either system board or Disk controller. I replace both and the only way I can get past this error is by using the new disk card with the new RAID memory. The old RAID memory card seems to have...

    Spadasoe5,130 pointsBadges:
  • ILE Call(e) error handling

    I am calling a CMD from an ILE program (simulates WRKSPLF) that emails a spool file. In my program I use Call(e) and %error indicator is on when CMD is executed if an error occurs during execution however I cannot determine which error happens. I tried using psds sds msgid 40 46 msgdsc 91 170...

    filuphaze475 pointsBadges:
  • cretae file through onlines

    How to create a dataset using IMS online (Cobol)program.

    Pandavula5 pointsBadges:
  • Can the field exit key be programatically triggered?

    The user doesn't want to have to use the field exit key when entering numbers in a display file input field defined as 3 0. Can field exit be triggered programatically?

    LLoyd02445 pointsBadges:
  • List Spoolfiles

    how can i list Spoolfiles like wrksplf does ? I want to list them in a subfiles. bye jo

    Jogisarge30 pointsBadges:
  • Print Server & iSeries

    Currently our printers are identified by IP Address over our network. There is discussion about using a Print Server for our Windows Clients. Will this have an effect on how I configure printers within the iSeries environment. Thanks, Bill

    wpoulin2,480 pointsBadges:
  • Automating Client Access

    I would like to automate client access to pull down some data. Is there a way to do this? Can i use windows scheduler to do it if it is possible?

    Auditnewbie5 pointsBadges:
  • Converting a varchar to a numberic in SQL query

    How can we convert a varchar field to Numberic in a SQL Query in db2 400?

    AS400 - Ask the Expert485 pointsBadges:
  • Vary on failed for TCP/IP

    We have an iSeries 270 with seemed to have lost TCPIP communication. The TCPIP interface info comes up with status 'inactive' when started. I have tried recreating the line controller with information from IBM but still says 'TCPIP vary on failed.

    AP25 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