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

    ToddN200017,865 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:
  • Date Keyfield in a Physical File

    Hi, Is it possible to have a Date as one of the Keyfield in a Physical File and access the same in a RPG/RPGLE Program using the KeyList?

    Cganeshh0 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:
  • Where is the source file of an ILE program?

    Hi,  I need to find out the name of the source file of a ILE program. I am getting a blank using DSPOBJD. I know it can be rtrieved using dsppgm but I need to run the process in a program and strore the output in a file.  Pls help... !! This is kinda urgent...  Thanks,  Ankita...

    Ankita135 pointsBadges:
  • rpgle programming

    when i call my rpg program the display screen is not exiting though i have added CF03 function in the DDS of the display file,or is something wrong with my program and here is the rpgle code to get the date for a particular id.. ******************************************************** FDSPF  CF...

    Peraj55 pointsBadges:
  • SQLCOD = -7008 when doing an insert into file using SQLRPGLE-2

    Hi, I'm trying to insert selective records from one file into the same file in another library. I have to do this for many file. Am building the query dynamically using SQLRPGLE. Am using a PREPARE statement and an EXECUTE statement to run the query. While the PREPARE statement ends fine, am...

    SasiKumar0 pointsBadges:
  • commitment control and activation grp in ILE

    I am new to AS/400, can you a link or resource that talks about commitment contrl and activation group briefly.

    Sugaar0 pointsBadges:
  • folders and documents

    Is there a way for a program to find out if a folder contains any documents (we will not know a document name). We need to know if the folder is empty or if it contains any documents.

    Qbjgqbjg40 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