• User ID and passwords are clear text or encripted ?

    1)I need to know if iSeries Access (Client Access) TN5250 is used to log on to AS/400, is id/pswd sent in clear text? 2)What about FTP? Other features of iSeries Access? I am interested in OS levels V5R2 and above for this information (Please provide if you have any related white papers)

    IVANRAO0 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:
  • Sending a break message to more than just one message queue

    I want to send a break message to more than just one message queue using the SNDBRKMSG command.  In online iSeries or AS400 user books they show the screen which displays  several enteries for the "To work station message queue" parameter, but when I display the command on a system i under V5R3...

    Rrbond07520 pointsBadges:
  • Incoming Remote Command on Windows XP

    I've been able to find lots of entries on the IBM site for Incoming Remote command and SE, ME, NT and 2000 but there is something different with XP that prevents it from working. Has anyone been able to make the incoming remote command work to an PC running XP?

    JDWWms0 pointsBadges:
  • Commit utilization in SQL stored procedures

    I need an explample of an SQL stored procedure running in an DB2 environment that uses commitment control. I don't want use RPG. I would like to call it from QSQLSRC via LXISCH (AS400 scheduler) and update over 100,000 records in 20,000 row increments. Any Suggestions? Thanks!

    Whitera0 pointsBadges:
  • 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:

    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:

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.