• Access to AS/400 folders

    What access does a person get when they get access to AS/400 folders?

    kevinbrown5 pointsBadges:
  • Import and Export data from AS/400 using ODBC

    I imported data from AS/400 database file into an Excel sheet, using ODBC. I selected Microsoft query in order to retrieve data. How can I export data into AS/400 database file?

    Geek51175 pointsBadges:
  • *INU3 and *INU4 SWS

    I am working on an some old programs that make use of *INU3 and * INU4 indicators. From the CL program it appears they are getting set on by ''00100000' and '00010000'. Would I be correct?

    UARTJ115 pointsBadges:
  • AS/400 selective update with SQL

    Hi All, I am trying to create an SQL statement that will update many records based on a file containing fewer records. I can easily update ALL records in the primary file but I really only want to update those that need to be updated. In the item master file the cost has been changed for some...

    Ckelly0115 pointsBadges:
  • QPADEV0006 message spamming on history log

    In "DSPLOG", I keep getting the following message spammed. Any help would be greatly appreciated: Description for device QPADEV0006 changed. Session to device QPADEV0006 ended normally. Description for device QPADEV0006 changed. Session to device QPADEV0006 ended normally. Description for device...

    kf4wto15 pointsBadges:
  • Users connected to a particular printer device in AS/400

    How can we find out who are the users connected to a particular printer device in AS/400 if we know the printer device name.

    dineshiseries555 pointsBadges:
  • How do we reproduce the error CPF5032 – member already locked to job.

    As part of my task, I need to recreate the issue that throws error CPF5032 - "member already locked to job. I need to fix a program but before doing that I need to recreate this error and I am unable to do so. What specific setup is required to recreate this issue?

    sanras12335 pointsBadges:
  • SSH File Transfer Protocol – OpenSSH – AS/400 to TumbleWeed

    Hello Everyone, I need a quick clarification from all. Could you please someone reply back, based on the response will take the decision. My organization is using a Third party Application called Tumbleweed which is file server to transfer the files from AS/400 to Target Systems and receiving files...

    Nagareddi80 pointsBadges:
  • Client Access adding decimal and blank space after numeric fields

    How can I remove the decimal point and blank spaces during the file transfer process. These are defined as zoned numeric fields. The file is a typical iSeries physical file with both Character and zoned numeric fields. The blank spaces and decimal point do not show when you display the file on the...

    Sharonhynes45 pointsBadges:
  • AS/400: Update the record that caused the trigger to be called

    I need to update the record that caused the trigger to be called. When the status is updated to a certain value, I want to be able to perform some calculations on other files and then update the original status. This is not working due to record locking.

    lisawml15 pointsBadges:
  • iSeries SFTP

    How do you setup for secured FTP? Can the process be automated like normal FTP?

    Mitchb145 pointsBadges:
  • Convert AS/400 date format

    Can the AS/400 date be re-formatted?

    BillJohnson7624025 pointsBadges:
  • Query/400 not displaying column descriptions for DDL defined table

    We recently updated a file and converted it from DDS to DDL during the process. During testing no one mentioned the column descriptions were no longer displayed when using Query/400. Is there a way to make Query/400 display column descriptions for DDL defined tables?

    DancingInTheMoonlight145 pointsBadges:
  • How to convert a Date given in Char format to numeric format in RPG of AS/400.

    How do I convert a Date given in Char format to numeric format in RPG of AS/400?

    C.naveen09140 pointsBadges:
  • Overlapping screen in OS/400

    I have overlapping display screens in OS/400. What should I do?

    deputy825 pointsBadges:
  • Reason behind the *INLR = *OFF process

    Hi, it may be dump question for you, but can anyone please clearly explain me, what is happening when I do *inlr = *off. I have tried with the sample example code as below: HDFTACTGRP(*NO) Option(*NODEBUGIO) FEmployee1 iF E k Disk DNum1 S 2S 0 inz(4) DNum2 S 2S 0 inz(4) DRes S 4S 0 /Free Setll...

    srivijay1320 pointsBadges:
  • Why would I want to create a printer file on AS/400?

    What benefit do I get from using a printer file on the AS/400?

    mikemyrick5 pointsBadges:
  • How to add one Module to the existing Service Program

    Hi, I want to add or append one new module called 'C' to the already existing service program (SRVPGM) For Example: I have one service program called SRVPGM consists of 2 Modules are A, B. Now I want to add one new Module called 'C' to SRVPGM. How can I do this? when we do UPDSRVPGM does the...

    hndajad70 pointsBadges:
  • DFU (UPDDTA) and changing Keys

    DFU (UPDDTA) and changing keys - We support a number of users of the same software. then we try to change a key field in a file with DFU it doesn't always allow us to do so. Sometimes the user does not have access to the key field, sometimes they do. Each user is the owner of the file and has...

    Bamba6125 pointsBadges:
  • AS/400: %Equal and %found

    Which are those opcode can be used with this two built in function in different different scenario? Which one should be used with whom? Please explain me, I am quite confused here.

    hndajad70 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