• Generating Excel spread sheets from Sequel on the iseries

    I produce an excel spread sheet from sequel on the as400 and e-mail it to a user. The user performs some data entry on the spread sheet. The spread sheet is then transfered to a AS400 Physical file and a program is called that updates a AS400 data base. The problem is when they enter 013, the...

    Johnd0155 pointsBadges:
  • Search for missing Semi-colon in Free format

    Is there a way in either SEU, Code400 or the LPEX editor to do a search by exclusion? I'm looking for an easy way to identify lines of code, in Free format, that are missing the semi-colon at the end.

    Jkucharik0 pointsBadges:
  • RPGLE Program help

    I have a scenario .. I have program   FColstatlf IF   E           k Disk                              FColstatkk O    E             Disk                             ...

    C.naveen09140 pointsBadges:
  • Physical / Logical file definitions

    Can a logical file have fields that differ in definition of type than the physical? I've got a physical file with fields defined as: FLD1 A 20 1 20 FLD2 S 8 0 21 28 FLD3 S 11 2 29 39 and the logical defined as: FLD1 A 20 1 20 FLD2 P 8 0 21 25 FLD3 P 11 2 26 31 Will the data process between the two...

    Houstonpgmr0 pointsBadges:
  • using QDBRTVFD to find SQL view create statement

    Hello all. Just wanted to know if anyone out there knows how to use QDBRTVFD to retrieve the SQL view create statement. For our update process, I am scanning the customer's libraries to find buisiness views. When I find them, I want to extract the SQL view create statement (like in DSPFD) and place...

    Jley6180 pointsBadges:
  • RPGLE Convert negative number into decimal

    Input field (CHGAMT) is defined as 17S 2 but has a negative value     (-14.00)  viewed as '0000000000000140}' I have to first move this value into a character field and get it into a decimal format again (17S 2) so I can use the value to compare to another field defined the same way. ...

    Pt0505145 pointsBadges:
  • Robot – Change object security of fle REPPF in RBTREPLIB library

    I am planning to read file REPPF from RBTREPLIB library from a program. The security of this object is setup as the following: User Object Authority *PUBLIC *EXCLUDE RBTUSER *ALL Because the way the security is setup, the program only will work for those users that complies with this security. Can...

    MayraPR5 pointsBadges:
  • numeric field check

    i have a file that has a numeric field that is being cleared early in a program if certain conditions are meet as the file is being made...i need to check later before that file is printed to see if those conditions have changed....the numeric field is the key....it's not having zeros put in...

    Cowboypgmr0 pointsBadges:
  • GDDM on V5R4

    Can I display graphics on the screen Or print the graphics using GDDM on V5R4?

    Creative180 pointsBadges:
  • Retrieving Job Info

    I have a CL submitted from the Job Scheduler. In this job I need to kill an active job before processing, then strat it up again when processing is complete. For the active job I know the User ID and the Job Name and this is it, in addition there will always be more than one job out there (1 active...

    RaydenR0 pointsBadges:
  • Hexadecimal

    Can someone please tell me the hex value of the [TAB] key Thanks

    Riccardi0 pointsBadges:
  • User Auditing/Journaling

    I'm new to security on the AS/400 (730). We need to have a record of what program a user calls through our ERP system or what objects are changed and who changed them. I've read some on journaling but not sure if that will work for what we need. Suggestions? Thanks Mark

    Hllwyrs0 pointsBadges:
  • Reading a File of unknown name, format, etc.

    I need advice on reading a data file in RPG where I will only know the file name, the file format, etc. at run time. I would like to use an API or something to read the file into a buffer; I could then use the QUSLFLD API to get field definitions and parse the fields as required. I am not...

    DaddyCOZ0 pointsBadges:
  • How can I split job by determine no. of records ?

    I have a problem. My transaction file is about 20,000 records. This file is used as input/update file. It uses a long time when we run job in day end. I want to use less time. How can I split job to 4 job and each job run only 5000 records? How can I determine as follows ? job 1 process data only...

    Cookiekitty110 pointsBadges:
  • RPGLE Program woes

    I had an AS/400, consolidated to a newer one w/other facilities. When my library was restored and I tried to process an old program, it does not pull any data. I have not programmed in several years and have never used RPGLE. Do not know how to use debugger, etc. so I'm wondering if the problem...

    Mhsuttg40 pointsBadges:
  • RPGLE Flat File

    how can i keyed a flat file in RPGLE

    Hemavijay85 pointsBadges:
  • deal with microsoft access data base file from RPG program or clp

    hello, I need to made clp or RPG program to open microsoft access data base file from my PC then read and update special table from this file thanks best regards laila elsharkawy

    Lsharq0 pointsBadges:
  • synchronize jobs

    Hi! How can I synchronize two or more RPGLE/CL programs that are executed via SBMJOB command, in order to avoid conflicts in using files and dataareas? If you could send me an example, it'll be greatly appreciated. Thanx in advance, Meli :)

    MelissaG20 pointsBadges:
  • Command Prompt Override for CL Commands

    Hi, I am managing a very large project that has morphed time and time again. Presently a new release of a third-party application that requires tight coupling with various aspects of the primary application was introduced. Instead of the Jr. Programmers going back time and time again to substitute...

    Doogen0 pointsBadges:
  • triggers

    i know you can attach a trigger to a physical file, but can you attach one to a print file or even a display file. thanks in advance

    Cowboypgmr0 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.