• iSeries SQL function in a SQL procedure – error: Function Name “in *LIBL type *N not found.”

    A while back, Seeker1 posted this question.  Unfortuantely, he didn't provide enough information for Tom to help.  Well - I have the same problem so hopefully, this will be enough. This Select statement generates the error: SELECT UNUNIT, ITRVEHLOC(UNUNIT  , 'CITY ')  FROM Units Here are the...

    Craig Hatmaker1,775 pointsBadges:
  • How to convert a “Numeric-String” with ‘-‘ sign and decimal places into pure “Numeric”?

    Dear AS/400 Lovers! I need to convert a string containing Numeric-value with two-decimal places into a "Numeric". Alternatively the string may contain a minus-sign('-') in the beginning of the numeric-string(e.g. '-4321007.86'). The result should be pure numeric i.e. -4321007.86 The string's total...

    svankipu620 pointsBadges:
  • How to make password characters invisible in AS400?

    I am designing a login screen in AS400 box. How do I make the characters invisible while entering the password? Need Help!!

    vssagar70 pointsBadges:
  • SELECTION OF UNIQUE RECORDS FROM FILE USING SQLRPGILE CODE

    I HAVE TO DO THE BELOW STEPS USING SQLRPG,PLZ HELP TO HANDLE THE UNIQUE RECORDS : 1. Delete records from Production LFPRIPMH/D file and those policy numbers are available in LFPS402S (unique policy number) 2. Insert into Production LFPRIPMH/D files from Before migration image (LFPRIPMH/D), where...

    AS400RAHUL5 pointsBadges:
  • Using the command RCVMSG

    There are numerous reports which automatically print throughout the day. Often there may be a message waiting on the printer and because no one was expecting any reports, no one discovers the problem until hours later. (By this time there may be quite a few reports waiting to print) I was...

    GHENDER200 pointsBadges:
  • RPGILE

    Hi All       In activation group suppose 2 program is reading same file the 1[sup]st[/sup] record reading by 1st program how second program will read second record how will do in RPGILE by activation group?  

    Yogeshrajmane10 pointsBadges:
  • BUILTIN FUNCTION..

    HOW CAN WE CHECK THE EXISTANCE OF ANY RECORD IN ANY PF WITHOUT READING THE FILE IN RPGILE . . IS THERE ANY BUILT IN FUNCTION  THANKS/

    Ambrish 82310 pointsBadges:
  • RPG iv with no file definitions…

    hello, I wonder if it is possible to write an rpgile program without defining any of the files it is suposed to use. The idea is to obtain that sort of information by other means, say a servlet. Can anyone give me some pointers on were to get some info about this? thanks Raven

    RavenClaw5 pointsBadges:
  • ILE RPGLE

    I HAVE EXTERNALY DISCRIBE PRINTER FILE. I WANT TO WRITE 30 RECORDS IN ONE PAGE. I USED OFLIND KEY WORLD BUT PAGE BREAK NOT WORK. TWO HEADINGS ARE WRITE IN ONE PAGE PLEASE GIVE ANY ANSWER   BEST REGARDS, NADEE.

    NADEE12320 pointsBadges:
  • Multi Views of a subfile

    I need to write a program that shows more than one way to display a subfile. Both views are of the same file but sorted differently and show different fields of the same file when the user presses a function key. Can I do this in one program or do I have to make 2 seperate programs and toggle...

    filuphaze475 pointsBadges:
  • AS400 RPGLE Lock wait on multythreaded jobs

    I have 40 threads of the same program that I am submitting. The jobs go into and out off lckw status to fast to see the reason but this slows the process down How do I find the problem.

    2h1o5 pointsBadges:
  • indicator position

    hi , i m working on rpgile, i want to know that what is the difference b/w different indicator position, like some times we put it on HI, LO, EQ. WAT IS DIFFERENCE

    Ambrish 82310 pointsBadges:
  • trim string values in rpg/400

    how to trim string values in rpg/400 or RPGILE OR CLP

    Bu60 pointsBadges:
  • RPQSQL / SQLRPG

    Any body please help Wanted to know the advantage and disadvantage using RPGSQL / SQLRPG I've heard that this is the new one its not only RPG but become one with SQL. Thanks in advance

    TG50 pointsBadges:
  • How to define two dimensional arrays in RPGILE

    I need to create an array that contains a code (2,0) and hrs worked (5,2) for that code. something like 01 2.3 4.3 5.6 7.0 8.0 02 5.0 6.0 7.0 7.0 6.5 I will then take this array and load a subfile to display on a screen. Thanks, John

    JAC260 pointsBadges:
  • Adding Field to a PF

    I have to add some new fileds to an existing PF without compiling the PF how can i do that? can i use this updated PF in my RPG ILE program without facing any error/exception?

    Chandra9355 pointsBadges:
  • Default error/exception handler

    If we have any error/exception in the RPG ILE subprocedure and we have default error/exception handler routine *PSSR in that module. will control go to the *PSSR?

    Chandra9355 pointsBadges:
  • RPG-XML

    Can anyone please help this poor guy... that's me...I need to know how to code on RPG/ILE to transfer XML code to the customer..Do I use flat files? Please help me..

    devan390 pointsBadges:
  • CGI Program Problem – Data Decimal Error

    We have a set of programs that were written a couple years ago. We recently recompiled one and we started getting the error RNQ0907 decimal-data error. There were no changes to the actual code in the program or modules that are bound to it. We restored the object from tape and it works fine, but...

    Willhud69205 pointsBadges:
  • Trigger errors

    Why is my trigger program failing? It's a CL program and it appears it is not even getting to the early part of the program where I have a halt to check job attributes. I created a physical file on our iSeries and added a trigger using the following command. ADDPFTRG FILE(EXTRANET/WCTLH)...

    ToddN200015,605 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