• CPYF in arrival sequence

    Anyone know a quick and dirty to copy data from a keyed physical file to another physical in arrival sequence in a CLP program? I can't find a native os/400 command that will do it.

    Dasturg0 pointsBadges:
  • Operating Console

    Hi I have operations console running on a laptop which is directly connected to my I-Series. All runs okay until the laptop powers down(for variety of reasons), when i power it on again it will not connect to the I-Series without doing an IPL of the I-Series. I get the message "Connecting Console"...

    Hazermark0 pointsBadges:
  • Deleted user profiles in AS/400

    Hi Is there any way we can know about deleted user profiles in AS/400? We have an audit process wherein the auditor have asked for a list of all the users deleted. Can any one suggest where can I get such a list? pgsdeb

    Pgsdeb20 pointsBadges:
  • My operating system was upgraded from V5R3 to V5R4

    my operating system was just upgraded from V5R3 to V5R4. All my cobol programs are compiled with *none commitment control and a target release of V5R3M0. However after upgrading the operating system while executing the programs -913 errors are being encountered. The same programs are getting...

    Priyaranjanltcp0 pointsBadges:
  • AS/400 – iSeries SQL Update of on table with values from another joined table

    I've use an SQL utility on the AS/400 call SEQUEL by ASC, that allows updating of values in one table from values in another joined table. The syntax is something like this: update set((a.fld1=b.fld1)(a.fld2=b.fld2)) from file1 a join file2 b on a.key1=b.key1 where a.key1='OnlyTheOneIWant'I no...

    Mark90990 pointsBadges:
  • Converting from System 36 to iSeries V5R4

    I've been landed with a project to convert a System 36 system to iSeries 520 with OS V5.4. I have never worked on a System 36 and do not know where to start. Have looked for some documentation in Red Books but could'nt find anything. Does anyone have something I can use - something like the...

    JohnDavid5 pointsBadges:
  • Access Oracle/Sybase/Informix from RPG

    Hi, I would like to access Oracle/Sybase/Informix directly from within an RPG program. This is something similar to ODBC but in reverse - my data source is external to the iSeries and my application and APIs, or called routines, internal in the iSeries. The access to the external database should:...

    JohnDavid5 pointsBadges:
  • AS400 File Transfer using RUMBA Office V 7.3.0

    We use RUMBA Office V 7.3.0 for AS/400 Display. We would like to restrict certain users from using the RUMBA AS/400 to PC File Transfer. Is there a way we can do this from the 400? The only reason that I ask is that we are a corporation and have more than 70 AS/400's. A user can use a sign on with...

    BaughOper0 pointsBadges:
  • What are the possible situations where DB2 server FORCES to close the applications connected to it?

    Possibile situations where DB server forces to close the applications connected to it? Some of the situations can be : DB2 restart, DB2 stop, DB2 suspend. What else situations in DB2 server forces to close the applications connected to it? Your help is greatly appreciated !

    Saimadhu455 pointsBadges:
  • using SQL statements…………..

    Hi All, I have a problem. I have a string variable STR which contains SQL statements...... Like insert into lib1/fil1 select * from lib2/fil2 variable STR is changable...means I update the values of library and files at run time...in the variable STR.. I want to execute the SQL statements contained...

    navinnegi45 pointsBadges:
  • SQL Errr

    Hi I am a novice to SQL and I was hoping someone can tell me where I'm going wrong. I have a small sql statement that keeps giving me an error message. Can any one help please. Thank you in advance. Dawn > UPDATE AMFLIBT.MOROUT SET OPSTC = 40 WHERE (select AMFLIBT.MOROUT.ORDNO,...

    Dawn81600 pointsBadges:
  • Authorization problem on DDM file in RPG program

    I have a RPG program that accesses three DDM files on another iSeries. The program compiles, but I receive error CPF9822-Not authorized to file XXXX in library XXXX. Cannot open DDM file. I have *SECOFR rights on both machines. Can someone help me?

    Freckles0 pointsBadges:
  • DB2 Stored Procedure V4R4 without ILE C/400

    We have an older iSeries running V4R4. We user Rumba/400 for AS400 access, and we've run into a problem using the Rumba ODBC driver for linked server access from our SQL server to our AS400 (The ODBC driver periodically fails when the linked server is used heavily). Because of this, we've been...

    MODMOD0 pointsBadges:
  • SAVACTWAIT time on SAVLIB, etc.

    Hi, Has anyone experimented with the SAVACTWAIT time on the SAVLIB command. The default on 120 second seems rather long. What I am looking for is a realistic value based on fact such as that if an object does not become available after 5 second the change that it will become available after 120...

    JohnDavid5 pointsBadges:
  • Impact Analysis – None Answered till now

    Hi all, I have a question and submitted long back. But till now i didn't get any reponse. Task: If there is any change in the length of a field or a new field added into the existing file, we need to do some Impact Analysis which is time consuming.So i thought of developing a utility for that....

    Kumari0 pointsBadges:
  • Data mapping errors when reading records with time fields…

    I'm trying to access records from a file that has eight fields defined with the time attibute. When I examine the data held in these fields they are mostly set to *LOVAL i.e. 00.00.00 in *ISO format which according to the RPGLE reference manual is an allowable value. However, when my program...

    JonathanG0 pointsBadges:
  • System Setting For Created Libraries

    Hi Everyone. An odd question, when we create new libraries on the 400 they are automatically flagged in the SETUPBCKUP screens for Daily/Weekly and Monthly backup. Where can I change this attribute for new libraries created on the system? Thanks, Rayden.

    RaydenR0 pointsBadges:
  • “map drive” IFS

    Hello, We have a ?LAN without any server Windows OS in it? , so everybody is a client (with fixed IP). The only ?server? we have, is our iSeries i5 (V5R3) with iSeries Access(CA) installed (also on the clients). We cannot ?map drive? the IFS f.e. root with \QS6555A8Aroot (or anything else on the...

    Hahajokes5 pointsBadges:
  • Superseded PTFs.

    If there are special instructions for a superseded PTF that is not loaded or applied on your system in an ordered PTF cover letter, do you need to order the superseded PTF and follow the instructions for it before loading the PTF that will supersede it? I hope my question makes sense.

    Bkr0963c0 pointsBadges:
  • iSeries accessibility to VB.NET, ASP 2.0/3.0 ,NET programmers in Visual Studio

    My shop does not have WebSphere but does have a sizeable VB.NET team using the MS Visual Studio. They need access to the iSeries files in DB2/UDB - real-time. We already thanks to me have a number of batch/DTS package type transfers. Do any of you know packages that can make the iSeries files...

    JohndeCoville0 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