• negative sign in physical file copy process

    this is regarding copy file.I have a physical file P1 and physical file P2. Now in P1 i have a zoned decimal field and in P2 i have a packed decimal field. let us assume i have the negative data in P1. after performig the CPYF to copy the P1 to P2, i am getting some junk characters ( '}', 'M', 'S'...

    sivakesava280 pointsBadges:
  • Duplicate key on access path.

    I have a physical file PF1 with some key fields(K1,K2,K3). PF1 has say 5 logical files with different keys(K1,K2...K5) I am trying to update only a field of PF1(that field is not a key in PF1) using SQL(stored procedures) PF1 has unique keyword mentioned.But the update is not made on key fields....

    anuppdas105 pointsBadges:
  • DLYW / DLY-5

    Hi all, When i submit a job, it is straight away going to DLYW status, Some times to DLY-5 status. What could be the problem.. please answer me. Thanks.

    Sai4AS4001,420 pointsBadges:
  • SQL optimization in COBOL400

    I am using an SQL in Cobol 400 to delete around 100 million records out of 200 million records based on a date. What is the best way to delete this much data in one stretch? The file has key as date. My sql would look like Delete from FileA where Date < 'some date'

    anuppdas105 pointsBadges:
  • Historical info on AS/400

    I've looked everywhere and cannot find historical info on the AS/400 anywhere. Can you help me?

    Sean007marvin20 pointsBadges:
  • How to send multiple attachments with SNDDST?

    How do I send multiple attachments using SNDDST?

    handleme110 pointsBadges:
  • SNDDST language issue

    Our servers have different primary languages. My problem is if i use the SNDDST command, it's showing that the send distribution was completed successfully, but the recipient is not getting mail. Dspmsg showing ' Distribution to user identifier *UNKNOWN *ANYMAIL failed.''System value Qchrid is...

    kingstoniseries205 pointsBadges:
  • More detials on Interactive job

    I want to know complete cycle of interactive job in AS/400, please suggest some documentation

    Dinnu360 pointsBadges:
  • AS/400 access control for commands

    Some of the system commands are considered to be powerful like, {*USRPRF,*AUTHLR, CHGSYSLIBL, CHGSYSVAL, etc}. 1. Limiting capability does not restrict a user from executing a command. If so how can we restrict the user access to these commands? 2. Is there way to list all users with the access to...

    Anukku30 pointsBadges:
  • Question on Logical File

    When I compile logical file at very first time an object is created for that. When i compile that same logical file again it is showing Object SAMPLELF in BALAGAM1 type *FILE deleted. what was the reason behind it .. how can i solve this problem

    Gopidada55 pointsBadges:
  • DATAAREA

    I have a variable that contains the name of a data area How can I access the data area? Without using CL

    aldo40020 pointsBadges:
  • More than 50 files in RPG?

    How can i declare more than 50 files in RPG/400 program?

    csuoaananth75 pointsBadges:
  • webservice and iDB2 connections slow on startup

    We have a web service running on a SQL server sending data to our I-Series using a DB2 connection. The first time the service is run to submit an order, there is a long delay before it is submitted. On repeated orders it much quicker. Is there something we can do to speed up the initial connection?...

    ToddN200011,050 pointsBadges:
  • Alternative name of Physical file

    How to rename an alternative name(long name) in a physical file using sql or any other method.(Alternative name if present can be found using DSPFD) . No source is available for this physical file and only object is available.

    anuppdas105 pointsBadges:
  • TCP/IP Host Table Entries

    When i enter TCP/IP Host Table Entries could see list of all server and their IP's. my question is these are the systems connects to BRMS network or there any other relation so they appear here?

    Dinnu360 pointsBadges:
  • How to prevent MSG ID CPI3420?

    Hi, Im new to this blog so hi to everyone. This is my problem, I'm trying to generate performance reports, when I go to WRKSPLF and 5 to display them, in some of them I get the CPI3420 and I can't see the text I need. I found out the way to display the overwritten text by creating a physical file...

    D3N1SG20 pointsBadges:
  • 2nd Pair of SSH Keys

    I need to create second pair of SSH Keys for a User Profile ,Which has already working SSH Keys. If i normally do with SSH KEYGEN -T RSA ,i believe it will overwrite the existing environment and set new keys...Could You Please Advise me how to do this ?

    qmaster1,675 pointsBadges:
  • ASP source connect to System i (AS400)

    Hi.Now, I create ODBC of system i access software and config finishedBut, I can not get data form database on System i for showSouce code as below.(It connected to ODBC but can not get data for show)<%ConnectionString= "Driver={iSeries Access ODBC Driver}; System=10.230.1.32; UID=PCS;...

    kangbit0 pointsBadges:
  • Want retrieve job attributes for another job in CLLE

    Hi My aim is very simple. I am writing CLLE program wherein I want to retrieve attributes for a job (here job name is fix, but not the job itself) I want to check whether this particular job is submitted previously irrespecive of status (MSGW, DLWT etc). If its sumitted previously I don't need to...

    pankaj2r100 pointsBadges:
  • How to find the If – Endif relationship

    Hi it is very hard to find which END is related to which IF statement. I know we can find it during compilation by using \"Source listing indentation \" but for this we have to check the spool file. i wanna know is there any way to find it in source. I mean i have seen thousands line of codes where...

    ITKBHARAT120 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