• Impact analysis

    Hi, The user requested me to change the field length from 25 to 30 char. I want to do impact analysis on this. How do i proceed?? Thanks, Rama Krishna

    0 pointsBadges:
  • Calling RPG program without Parameters

    1) I have an RPG PGM 'A' which call's another RPG PGM 'B'. PGM 'B' accepts 3 parameters. But i need to call PGM 'B' without passing parameters. How to achieve this??? 2) I have an RPG PGM 'A' which call's another RPG PGM 'B'. PGM 'B' doesnot accept parameters. But i need to call PGM 'B' with...

    0 pointsBadges:
  • Copying Spoolfiles

    Hi, I would like to know, How to copy spoolfiles from one AS400 machine to another AS400 machine? Thanks in Advance Rama Krishna

    0 pointsBadges:
  • Optimizing/Indexing to find last transaction

    I'm hoping someone can help me out with this. I'm trying to write a query that will return the last transaction for each item in our warehouse. To do this, I'm using 2 files, first our location detail which has a list of all the locations in our warehouse. This file only has about 60,000 records,...

    MODMOD0 pointsBadges:
  • Problems eliminating HEX 41 character.

    I have a number of files on my DB2/400 database that have spaces with a Hex code of 41 instead of 40. This causes a problem when FTP'ing to a PC for integration with a barcode labeling application. Does anyone know how I can change this character to ANYTHING other than Space HEX 41 !! Potentially...

    Selectsoft65 pointsBadges:
  • AS400 disk initialize info

    Hi All, I am trying to find printable results or logs for a disk that has been initialized successfully by using SST or DST. The procedure normally completes with a single line of "COMLETED SUCCESSFULLY" I need more infomation like model, serial no, sectors or some proof that this particular disk...

    Jf79210 pointsBadges:
  • Count days between 2 dates

    I wish to, using query count the number of days between 2 dates, the dates are in YYYMMDD format but I presume I'll need to convert the dates to Julian first to allow the caculation. Can anyone help?

    Smiler660 pointsBadges:
  • Programming with arrays

    Answer Updated

    Daveblake0 pointsBadges:
  • problems with infsr(*PSSR) and callp

    I have a program in which I specify infsr(*PSSR) on a file. This program uses the callp command to call another program which in turn uses the callp to call another program. In this third program, if an error occurs on an IO command on a file that is different than the one upon which I specified...

    Joy195400 pointsBadges:
  • FTP from iSeries DB2 to iSeries AIX (Oracle)

    I'm taking a FILE and using CPYTOIMPF to either create the flat file pipe delimited to another DB2 File or directly to the IFS as *PCASCII. Using iSeriesNavigator, I have no problem looking at the IFS. No issue with iSeriesNavigator and looking at FILE either. Using FTP, <namefmt 1>, <mode...

    Dlanor20 pointsBadges:

    I am using QSPOLJBQ (open list of job queues) API to generate a list of all job queues on the system. Need help to use this API.. All I get is "Receiver value too small to hold result." (MCH1210). But the help is not enough to resolve. I tried changing the parameters in many ways. Still I end up...

    ManiRa0 pointsBadges:
  • AS400 intreface with other platforms

    Can anybody tell me how to interface As/400 with other platforms say windows or linux for example

    Cute98862892710 pointsBadges:
  • ADDSVRAUTE & DDM files

    I am writing an Order Entry application that requires use of file on a remote system, which I will access via DDM. The problem is that we have hundreds of order entry clerks and turn around is great. I do not want to open a can of worms by having to create and maintain remote system user id's and...

    Molly24150 pointsBadges:
  • Is it possible to reorganize a very big transaction in one night?

    I want to reorganize a very big transaction file in day end process and it cannot finish within 1 night. The problem is RGZPFM command lock that file ,so the day after , user cannot use that file because it is locked. Do you have any ideas to help me?

    Cookiekitty110 pointsBadges:
  • create computations on the fly

    We are primarily a COBOL shop. We have some COBOL ILE and some RPG. I have a need to replicate a function on the I-series that is currently done in Excel. This function allows them to create formulas on the fly to arrive at pricing information. I can work through issues with interactive maintenance...

    Roses060 pointsBadges:
  • Renaming a file in the IFS directory

    I am receiving a file daily in an IFS directory, I manually copy the file to a library using the CPYFRMSTMF command. I want to automate the process so that it will be done every day at a specific time. The challenge is that the file name in the IFS directory is different every day, for example it...

    Hmonat20 pointsBadges:
  • Using RPG constants in Static Embedded SQL

    I have tried to use an RPG IV constant (D-Spec with a "C" usage and value) in embedded, static SQL as a host variable and the compiler fails. I was told this was possible, but so far I do not know how to do this. Not surprisingly, IBM documentation is practically worthless in trying to find out the...

    Mscottx0 pointsBadges:
  • Blocking certain fields from being downloaded using Client Access

    Hi, By using WRKQRY, we can select the files and create output files. My problem is how do I block certain users from downloading certain sensitive fields like Price in the output file. Thanks..

    N4t45h40 pointsBadges:
  • Cataloging Stored Procedures

    Need to know if anyone has a package or process to do the actual storing of information around a Stored Procedure? My area is being tasked with becoming the Librian for all of our stored procedures whether created with true Sequel or RGP with imbedded SQL. I am looking for a way out side of say our...

    ATHMAU0 pointsBadges:

    Hi All, This query is related to performance. I am currently in the process of changing an application from COBOL to Synon. The application uses a lot of I/O involving files. Upon converting the application to Synon, I find that the performance has declined - COBOL takes 8 minutes whereas Synon is...

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