• 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:
  • 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...

    PierreLG60 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:
  • 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:
  • 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:
  • Send a program completion message to a user

    A user call an update program - which will complete in a nanosecons as it reads 1 record and updates it. How Can I send a message to the user from the pgm giving completion data? Program could be CL or RPG3/4

    Raddy590 pointsBadges:
  • Source highlighting using NetManage Rumba

    Has anyone developed a keyboard macro, VB Script or WSCST object that will let you enter the hex values necessary to highlight source code in SEU while using Rumba? I found a few examples for CA/400, but not for Rumba. TIA...Chuck

    ChuckM0 pointsBadges:
  • clear physical file member question

    is it possible for me to only clear certain records of a physical while leaving certain records available? I have a file with thousands of records, but I only need the records starting with a certain date. How can I delete everything prior to the date that i need with out totally wiping out the...

    Blackc0 pointsBadges:
  • Data migration strategies

    Hi All I am embarking on a Data Migration project which involves migrating data from one I-Series database application to a different I-series database application. I guess as with all migrations the data does not excatly match in both appplications. I have identified that i need to populate Excel...

    Hazermark0 pointsBadges:
  • Administrative rights in an application

    Good day all, I am new in the application development world as a Business Analyst. Please pardon my ignorance, Kindly attend to my question. What type of access does an administrator/super administrator have on a system/application? i.e. what can be done and not done?

    BUSINESSANALYSIS5 pointsBadges:
  • SETLL and READE or CHAIN? Performance Issues

    HI, I have a batch RPG programs used to do some updataions and reporting, currently the job takes around 1 sec to process a record. We want to further reduce this time. Changing the run Priorty may make the job run a bit faster, are there any other parameters that can be used? also am looking at...

    Caprius0 pointsBadges:
  • Use SysReq to get WRKJOB

    I use to create a library - MYQSYS and load it with CRTDUPOBJ OBJ(WRKJOB) FROMLIB(QSYS) OBJTYPE(*CMD) TOLIB(MYQSYS) NEWOBJ(DSPJOB). I was then able to use the cmd CHGSYSLIBL LIB(MYQSYS)To put this library ahead of QSYS and when I used SYSREQ option 3 I got a WRKJOB instead of DSPJOB (and a cmd...

    StanZG0 pointsBadges:
  • scheduling a job

    I have a job that needs to run the 5th of each month. I've looked into JOBSCDE but I haven't see where I could schedule the job thru that. Do you know of an easy way to make that occur??

    Hmonat20 pointsBadges:
  • Override the file name during batch FTP

    We use ftp to send iseries files to our server. We use a script in a member in QTXTSRC. This script contains the library/file name to PUT. We would like change the file name in the CL to contain a date stamp and then use this file name to sent to the server. How can i override the file name on the...

    Johnd0155 pointsBadges:
  • How to make a batch job run faster (excpet for the run priorty), Code changes?

    HI, I have a batch RPG programs used to do some updataions and reporting, currently the job takes around 1 sec to process a record. We want to further reduce this time. Changing the run Priorty may make the job run a bit faster, are there any other parameters that can be used? also am looking at...

    Caprius0 pointsBadges:
  • Stored Procedures on AS/400

    Greetings, I understand SQL stored procedures on the AS/400 generate C source code which is compiled to create a C ILE program object. I could use the same SQL statements in an RPGLE with embedded SQL program and use that to create a RPG stored procedure. Which of the two is more efficient? Thanks...

    Ashnirody100 pointsBadges:
  • Displaying Chinese on 5250 screens

    Hello, I need to change some CL driven green-screen menus to display Chinese instead of English. We don't need to change the applications or data behind the menus ... just the menus themselves which are actually driven by message files with a display file and some CLP. Does anyone know of a...

    Oldgrayprogrammer0 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