• Data Conversion on IBM AS/400

    Hi, We're converting some old master files in to new format files. These master files have around 58 million records each. We wrote COBOL programs to convert the format and write to the new files. In order to speed up the process we are splitting the each master file into 20 parts(i.e., 20 files...

    DataConversion0 pointsBadges:
  • DB2 Automated Utilities – Vendor selection

    We use the IBM utilities suite and our own in-house utilities automation for DB2 v7. Our automated utilities is now draining us with heavy maintenance and since V7, there are still a few holes that could cause us some serious damage if not fixed in the near future. However, with V8, we would...

    Galvtx0 pointsBadges:
  • AS/400 macro: GOTO not working

    Hi, I'm trying to write a simple macro. Some stuff works, other things don't. For instance, a simple GOTO function, or exit. I copied from the help file because I thought I was doing something stupid wrong but nothing works. I have the following version: iSeries for windows version 5.8 Thank you

    BennyDS70 pointsBadges:
  • Read the same file twice in a loop

    I have a scenario like this. FileA has a keyfield MVDT(8A - it has a character field which has date in yyyymmdd). I have an RPG program which accepts start date as parameter. I do a SETLL with the start date and reading the file till eof. Inside the loop, am reading another file which has another...

    RamvishakRamesh2,505 pointsBadges:
  • Is there any system table in AS/400 to get the journal information

    I am looking for a system table where I can get the journalled information for all objects in a specific library AS/400. I am able to get the objects list from system table QSYS/QADBXREF and am getting the record counts from system table QSYS2/SYSTABLESTAT. I need to check whether the object is...

    basithap10 pointsBadges:
  • Users in QINTER2 Subsystem?

    Hi everyone! How can I allow some particular users to run in QINTER2 subsystem? For example, let us take user A & B. Whenever user A logging in AS/400 he must run in QINTER subsystem and user B should run in QINTER2. How can I do this? And is it possible to set different Sign on Screen for user...

    Sureyz2,375 pointsBadges:
  • 1N opening

    Should you open 1N with a singleton or two doubletons?

    SFKID10 pointsBadges:
  • Find the SBS allocated to the jobq when the sbs is inactive

    We had a situation where we have to find SBS allocated to the JOBQ when the system is restricted. What should we do?

    Dinnu360 pointsBadges:
  • System i Navigator

    Installed iSeries Access V7r1 with latest service pack on a new W7 64 bit system. I have current W7 64bit and 32 bit systems with same versions of iSeries Access that work. I am unable to access printer output or file shares. Received the following error - An unexpected error occurred. Check the...

    Christyt15 pointsBadges:
  • Move equivalent in Free format. %dec is not getting the expected result

    I have a character field (CharA) of 13A. I want to convert it to a packed decimal field (13,5) Value in charA is '0000000750000' and I want the value in Numeric field as 00000007.50000 I have used %Dec(CharA:13:5), but the value am getting is 00750000.00000. I am using Free format, I am able to...

    RamvishakRamesh2,505 pointsBadges:
  • More detials on Interactive job

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

    Dinnu360 pointsBadges:
  • Hanging file folder labels

    I can't get these to print on both sides. What should I do?

    marilynftb5 pointsBadges:
  • External data structure issue

    I have a file declared in my program and an external DS defined on that file FFDXXX IF E K Disk D FDXXXDS E DS ExtName(FDXXX) File FDXXX has 5 keyfields and am using a SETGT with partial key list. The data type of the keyfields used in correct (I guess otherwise it will not compile) SetGT (Wkxxx :...

    RamvishakRamesh2,505 pointsBadges:
  • xxVLLSP – Condition list: SYNON

    What is xxVLLSP – Condition list: SYNON?

    synon0101015 pointsBadges:
  • How to delete junk value records from a PF

    Hi, I have a file which has a date field of DECIMAL 8 and it has value +++++++++++ for some records. How can I delete these records via SQL or programatically.

    Ankitsikarwar10 pointsBadges:
  • Error connecting AS/400 from SAP DataServices

    Trying to connect via SAP DataServices/DataDirect to a AS/400. I get the error MCH1401 5210."System error Caused Failed Execution;Subsequent SQL may be successful.

    ep1860095 pointsBadges:
  • Using restore tape from other AS/400 system

    I am planning to do restore library by using the tape from other system. I am wondering that after the restore completed who is the owner object by default?

    MinhLe80 pointsBadges:
  • Advanced Job Scheduler

    Does anyone have a working example of scheduling a job dependant on a file existing on the IFS drive?

    Ianjda30 pointsBadges:
  • Average cost of an IBM COBOL compile.

    Does anyone keep track of the average cost of a COBOL compile in their site? I recall, back in the 90's, when people were calculating Y2K projections, the analysts were saying the average cost of a COBOL compile was somewhere around 8 to 10 US$. With the price of MIPS steadily decreasing over the...

    sfhtta05 pointsBadges:
  • LPAR IPL

    If we do an *FULL IPL on Logical partition will initiates/includes hardwares also?

    Explorer1910240 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