• 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:
  • The most-watched IT questions this week: Nov. 24, 2009

    Here are the 10 most watched questions on ITKE: There’s some great discussion going on. Go answer a question now! 1. Cluster drives moving windows server 2003 r2 32 bit was asked by a reader and answered by Mrdenny. 2. Migrating to virtualized environment purely to retain support for legacy...

    Michael Morisy8,643 pointsBadges:
  • Activation Groups

    I am changing some CL programs and COBOL/400 programs to ILE and ran into problems with OPNQRYF. I think it is due to the fact that the default activation groups when compiling these 2 different types of programs are different, so the results of OPNQRYF are not available to COBOL program. Can I...

    Kjjlori0 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:
  • Monitoring program usage

    Looking for a way to monitor certain command (strsql, upddta, etc) I need to know the user that ran the command and time/date, the file they were accessing would be nice

    RPGCRAZY30 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:
  • AS400 stored Procedure,what is the maximum parameters

    I have created one stored procedure with 63 IN parameters and 1 OUT parameters.This stored procedure is calling one rpgle program.For testing I am creating one SQLRPGLE pgm,this SQLRPGLE pgm calls the stored procedure.But when I am debugging the stored procedure,it is not getting executed.Please...

    AmuthaTPT30 pointsBadges:
  • Hexadecimal

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

    Riccardi0 pointsBadges:
  • Converting date values in AS/400 database

    How do I convert a date value 20/09/1231 for 31st Dec 2009 in the database to be able to use a query of checking this date against current(date)?

    Bonbon7830 pointsBadges:
  • iSeries SQL UDF gets CPF426A

    I created a SQL UDF using the iNav wizard.  It created the service program for me yet when I try to use the function I get CPF426A "User-defined function &5 cannot be invoked." with a reason 2 (Either the service program is not found or the program entry point &6 does not exist.)  It says the...

    RJonesPartrick25 pointsBadges:
  • Can a nested query be run in AS/400?

    There are multiple lines (sequenced) of my records in a table with the same Key. Example of the table Student No.     Name         Grade      1001              Michelle       Fail 1001              Michelle       Fail...

    Bonbon7830 pointsBadges:
  • How to restrict required libraries and through error message when tried to access. in as/400

    Remove production libraries from system value QUSRLIBL.  Having these libraries in the library list when a user signs on it effect gives them authority to the libraries.  Ssecurity enhancements have to be implemented to users who do not have specific authority to these libraries and should...

    Santoshreddyb15 pointsBadges:
  • ovrdbf in rpg

    hi guys.. i am getting a file name as a variable from CL program. based on some condition i want to write in differnt members of the file.since the file name is stored in a variable i cant able to declare it in f spec. so i created a duplicate object for that file and i declare it in f spec. Now i...

    Santhaseelan10 pointsBadges:
  • V5R4M5 SLIP upgrade problem

    Our VAR suggested that we apply the V5R4M5 upgrade. Durring the SLIP install I received a request for the next CD. We only received the oneCD "I_BASE_01". This caused the IPL to show error B6000414. Anybody know if there is supposed to be a CD #2 or what else is causing this problem

    Arawn5 pointsBadges:
  • embedded sql performance over large files

    We have many applications using embedded sql statements. We are discovering that as the files grow larger the performance diminshes significantly. We have tried using dbmon to ensure indices are not being built on the fly. There are either indices or logicals for all keyed access sequences. Any...

    Bbilgen0 pointsBadges:
  • Retriveing massage from submited job in CLP

    I have CLP and a cobol program. CL program calls the cobol program in Batch mode by doing SBMJOB. The cobol program processing 1000 records from a database file. If it founds errorneous record in the time of processing, then it stops processing with a system generated error massage and control go...

    Mithunpaul15 pointsBadges:
  • Email message sent is printing 2 pages

    I have written a process where a salesrep remotely orders a special item that we don't normally carry and it signals the buyer to order it.  When the item is ordered the system emails the salesrep. I use SNDDST with *LMSG with a short note stating the item has been ordered with item, vendor,...

    filuphaze475 pointsBadges:
  • InfoPrint Server Mapping question

    We are evaluating Info Print server and trying to use the mapping program to send emails. We are receiving error message PQT3611 Stream File not found for user. Has anyone experienced this issue?

    CandyH0 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