• How to estimate work hours for a typical data profiling and cleansing effort? Any Estimate calculators in Excel can be shared?

    One of my known acquaintance asked a question to help him with an estimator to logically estimate person hours required for data profiling and cleansing. His company is assuming their data quality will be bad. Now that there is a necessity to check and cleanse data, how to arrive at the man hours...

    swamis5 pointsBadges:
  • Trigger Program on Data Queue

    Hello All, I have a requirement where Program needs to be triggered whenever data is pushed into Data Queue. Without having a batch job checking for Data or running with delay job. Your inputs would be appreciated. Thanks, Pradeep.

    deepu93214,805 pointsBadges:
  • Finding source physical files

    Can you help this iSeries user? He wants to know how he can find only source physical files in any library (Ex: QDDSSRC, QCLSRC, etc.). Thanks! Michelle Davidson Editor Search400.com

    MichelleDavidson495 pointsBadges:
  • Real-time posting with AS/400

    Is real-time posting possible with AS/400. If it is possible, what will be required to migrate from batch posting to real time posting. Any help? (Note: I have no knowledge with AS/400 but I have been asked to look at how this will work, as such any response should be as simple, and devoid of...

    Hakomond15 pointsBadges:
  • Macro for copying data from Excel to AS/400

    Hi,I'd like to create a macro (in AS/400 or Excel VBA, doesn't matter) that copies cell data from an XLS spreadsheet to AS/400. How would I do that?E.g. copying cell A1 in Sheet1 from c:\spreadsheet.xls to 10/035...Thanks in advance.

    Hanisadeq963575 pointsBadges:
  • AS/400 Barcode

    I am in search of information for barcoding onthe AS/400. We would prefer not to purchase new printers. Can printing barcodes be done without using a graphical interface software package?

    NMK5 pointsBadges:
  • Adding Field to a PF

    I have to add some new fileds to an existing PF without compiling the PF how can i do that? can i use this updated PF in my RPG ILE program without facing any error/exception?

    Chandra9355 pointsBadges:
  • Convert AS/400 file to Excel and PDF

    I would like to transfer a PF data into Excel but my add-ins not working. Can you provide me any other ways to do that?

    As400programm10 pointsBadges:
  • Software files were deleted from AS/400 system

    Dear docs, I am very new to AS/400 administration. In our environment we have AS/400 server V6R1 with OS/400 OS and IBM MQ software installed in it. Recently we found some of the software files were deleted from the system. We have check the job logs with dsplog and wrksplf command but did not find...

    harsha812710 pointsBadges:
  • Prerun time array in RPGLE

    using prerun time array in RPGLE program... i have a PF(PF1), declared a field like this-> HDDNO   5P  without key field.... my coding is Fpf1      it   f    6        disk                                    Darray1           s              6p 0 dim(9)...

    pdsathishkumar3,790 pointsBadges:
  • How to format a flat file using customised FMTSRC

    Hi, I have a falt file.i want to sort it using a customised format source file.Please tell me how to create a source file for formatting the flat-file.I want the sample of a DDS of sort.

    Supriyoas400250 pointsBadges:
  • Sorting thru FMTDTA QFMTSRC

    In my application FMTDAT is used for sorting. FMTDTA     INFILE((*abcdef) +                            (*abcdef) +                                (*avbgrf) +                                (*abcdef)...

    AnupamAs40055 pointsBadges:
  • Can I FTP an AS/400 file with different record lengths?

    Hi I have created an AS/400 file with record length of 100. I am writing to this file a header record which I want to be length 80 (I am writing spaces to the end of the record to pad it out to 80) a number of detail records of length 100 (there again I am padding it with spaces) and a trailer...

    Rachel9965 pointsBadges:
  • User is having trouble signing in to I Navigator.

    A user receive a message when trying to sign into I Navigator. You requested to change the current connection properties.

    bit19545 pointsBadges:
  • Open .MSG file on Mac OS X

    A co-worker just sent me a .MSG file (it's an attachment). I'm using a Mac OS X and I figure out how to open a file. I don't have any programs to open it. How can I open this?

    ITKE1,012,285 pointsBadges:
  • AS/400 printing problem

    We are having a problem when we print reports on our Asian LPARS. The same report comes out differently when printed from U.S. or Asian LPARS. On the U.S. side the report prints the way we want it to but on the Asian the same report prints with the fonts all being the same size. The report should...

    curtstewart5 pointsBadges:
  • Display File Field Value When Function Key Pressed

    I have a simple display file that shows a window with a single field for user to enter a value for a number. If the user enters a number and presses enter the program uses the value to send number to other programs. My problem however is if a user places a value in the field and presses F9 the...

    filuphaze475 pointsBadges:
  • Working on AS400 for 3 years, please help me with some sources to get job in abroads.

    Hi, I am working on AS400 development for 3 years in INDIA for MNC company. But i didn’t get a chance to travel to Onsite to work closely with clients. Some of my friends who had same experience in AS400 got jobs in US and UK and some other countries through some external sources. Now I don’t...

    ManishAS40015 pointsBadges:
  • ATTN key program – AS/400 – QSECOFR – Program that adopt authority

    Scenario: let's say I have a user that has authority to a PGM that adopts QSECOFR authority. If that user has limited capability set to *NO or *YES, what is the link with the ATTN Key PGM value? From an IT/Security audit perspective, how do the limit capability value and ATTN key PGM value (in the...

    aldc123100 pointsBadges:
  • CPYTOIMPF error code 3025

    I am new to AS/400 and I wanted to transfer a file from AS/400 to PC using CPYTOIPMF as per advised here. But I am receiving an error, "File system error occurred" (Error number 3025) What's wrong?

    Radycal45 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.

Thanks! We'll email you when relevant content is added and updated.

Following