• System Save / Clean up / reorg?

    Because of the holidays, we're needing to do some maintenance on our AS400 in a much smaller window then we are used to, Normally, we can set aside close to a 24 hour window on a Sunday when we need to do any maintenance that requires taking our AS400 offline, but, this evening, we're limited to...

    MODMOD0 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:
  • Never Ending Program

    I have a program which updates several A/R balance files. This program needs to run continuously every so many seconds to update our customers' balances. How can I make this program a never ending program?

    GHENDER220 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:
  • Transfer a PF into Excel with column headings instead of fields

    Is it possible that when I transfer a file from a PF on the iSeries to Excel that I could get the column headings for each field instead of the fields names? Currently using rpgivtools commands cpytormtf/sndftpf to download to network drive. Suggestions?

    Hllwyrs0 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:
  • Model 170 – Problem creating PC5250 session

    Dear All, I know what the problem is and what the resolution is (see below) but how do I create a 5250 session now in order to sign on to the AS400 and change the system value QAUTOVRT. (There is no Twinax connection on the 170 so no dumb terminal available.) Can you help ? PC5250 Displays E8940...

    Rockgirl20 pointsBadges:
  • Printing from RPG based program straight to printer without going thru output queu

    Hi I need to change by inhouse RPG programs to print direct to the printer output queue without going through the spool files. Anybody knows how can this be done? Is there any CL programming required? Thanks

    N4t45h40 pointsBadges:
  • iSeries CPD3E3E message still present in V5R3

    I was looking for an answer on what to do to solve the appearance of message CPD3E3E in the QSYSOPR message queue. Where I have found some information, it gets me back to 2002 with the application of some SF66490 PTF included in cumulative packages for versions older than V5R3. Never saw anything...

    Xasanchez0 pointsBadges:
  • The comand DSPLNK

    The comand DSPLNK have for output (*Print) or (*display on screen.) How can I get the result to a file like there is in teh command DSPFLR OUTPUT(*OUTFILE). My files that I have to porcess is under the Root. Best Regards TBJ

    TBJSweden0 pointsBadges:
  • MONMSG and SNDRPY

    Dear, I'm trying to write a small program to run my backup job via BRMS... and I would like to check the different errors and reply automatically to few of them. Ok, I can monitor the error messages through MONMSG but how can I reply to them ? I know that I have to use SNDRPY but how can I have the...

    PierreLG70 pointsBadges:
  • FTP from Client site

    I am trying to receive data from a client site into an externally described file on my ISerie. Data will be received daily and the file name is date stamped, (for example:filea103106, filea110106)my problem is that since it needs to be copied into MYLIB/MYFILE, I cannot use the MGET filea* to copy...

    Hmonat20 pointsBadges:
  • Week number

    I can't see a system value for the week number. Is it held somewhere else on the i5 system or does anyone have a CL program they've written and willing to share to calculate it ? Thanks.

    Pmaddox140 pointsBadges:
  • Optical storage

    I am trying to copy database files from the iSeries to a DVD (optical storage) and would like the files on the DVD created in ASCII text format. Similar to a data transfer from the iSeries, you can specify the file type ASCII text. The database files are actually spooled files that were copied to...

    Rick1020060 pointsBadges:
  • Logical file to include only one of many matching records in secondaryu file

    I have a one to many relationship between 2 files. Although there are multiple matching records in the secondary file, the fields I am interested in are common. THerefore i only want one of the secondary records to join to the primary record - avaioding duplicate logical records. I know this could...

    JustinDouglas0 pointsBadges:
  • Running a job in SQL 2005 by calling a batch file from a As400 CL program

    Hi, I already asked this question before but did not get any reply. Anybody please help.. I am calling a job on AS400 which uses RUNRMTCMD to execute a batch file on sqlserver 2005 server. This batch file uses sqlcmd command to run a job on sqlserver. When I execute this batch file manually from...

    Gullu15 pointsBadges:
  • V5.2 SAVSECDTA Problem

    I am trying to run savsecdta from V5.2 box so I can move the user profiles and authorities to a new iSeries. I have done this a thousand times and never had a probelm, but this time after the command is issued it runs for hours and hours and never finishes. Cum level is 3252520. Any ideas?

    Helpdesktf0 pointsBadges:
  • Array Corruption

    I have written an RPGLE pgm in which I took an array with a size of 400 (20 fields with a length of 20) and did a MOVEA to put it inside a character field of 400. I then passed this field to another program and I did a MOVEA to populate the array in the 2nd program. When I call the 2nd program...

    GHENDER220 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