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

    GHENDER190 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:
  • 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:
  • SYNON vs COBOL

    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:
  • 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:
  • Using API : unlink()

    Hello All, Is anyone aware of "authorities" issues related to this API? I am creating .PDF files in the IFS area of our iSeries box and some users are unable to recreate a .PDF if they did not create it. In an attempt to avoid this I would like to use this API to "unlink" or "delete" this IFS...

    Mrs9693nj0 pointsBadges:
  • Tab delimited file

    I have been asked to produce a file in an RPG program. The file is being used in some kind of interface and needs to be 'tab delimited' What is tab delimited? How do I create a tab-delimited file? Thanks

    Raddy590 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:
  • As400 files – a basic question from a newbie

    I know this is going to sound silly - a file has a format/formats. What is a 'member'?

    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:
  • CPYFRMIMPF issue

    Okay, here's the deal. I've got a tab delimited file that used to load perfectly fine into file using the CPYFRMIMPF command, using the following options; CPYFRMIMPF FROMSTMF('/Directory of file/file.txt') TOFILE(Library/file) MBROPT(*REPLACE) RCDDLM(*CRLF) STRDLM(*NONE) RMVBLANK(*NONE)...

    Deaddancer0 pointsBadges:
  • API to send email messages from RPGLE

    I need to send an email message to a couple of mail ids  with CC mail id also. Is there any API (which is not in java) which will enable me to send the mail ?

    Koolsani085 pointsBadges:
  • iSeries Content Manager API Error

    I am trying to archive PDF document in iseries Content Manager V5.1 using the APIs provided by IMB in the RPGLE program. The SimLibStoreNewObject is giving error when the ObjectSize parameter is passed with a value 490KB or above. If the ObjectSize parmater is passed as any value below 490KB , even...

    Byju5 pointsBadges:
  • RPGLE & Variable-length fields: How do I measure how much disk space is actually taken up by this type of field?

    I defined a variable-length field. Do the first 2 bytes of the field signify how much disk space is actually taken up by this type of field? For this field, even if the first 2 bytes have a larger length than the actual number of non-blank characters in the field - in either case, when I use...

    195219560 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:
  • How to retrieve the “created by user” attribute for IFS objects ?

    Hi, I'm writing a program in RPGLE to fetch certain attributes of IFS objects (directories, folders and libraries), attributes like date created, date last accessed, etc. I've found an IFS API (Qp0lGetAttr) which retrieves all of the attributes I need, except one - the user who created the object....

    ShantanuBiswas0 pointsBadges:
  • embedded sql update

    I have a prog that should update all KY cust master records with the new code AR. I run the program but nothing happens. The file remains unchanged. I am new to embedded sql so what am I doing wrong ?? D OLDWH           S              2    INZ('KY')    D...

    ToddN200011,245 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following