• Record lock on physical file

    When a logical file is open in update mode to read and update the record, while performing read operation on logical file, lock applies on which file(logical or physical)? I have a scenario where one logical holds a lock and when another logical tries to read it shows 'Record is already lock to...

    sivakesava255 pointsBadges:
  • Function keys.

    Hi, I am trying to use function keys in rpgle fixformat (f2=save etc.) but i don't know how to use and how write down the coding, if anyone knows this coding please tell me. Thanks.

    programerrpgle35 pointsBadges:
  • Trigger program to validate data and notify interactive program of errors before insert or update action

    I have an interactive program that writes (Inventory Management) transactions to a file. I do not have the source for this program. I need to ensure that field content which is not currently validated by the program can be validated and corrected BEFORE the transaction being INSERTed or UPDATEd is...

    AlanMcK5110 pointsBadges:
  • Operation not allowed in a job running multiple threads from SQL RPGLE

    Hi, I am running SQLRPGLE on V7R1. The program takes entries from file and emails. The program on high level does following steps..........: 1. Fetch Record from File, ............ 2. Convert Spool file to PDF and puts into IFS, into Root/Folder1, ......... 3. Copies PDF file from Root/Folder1 to...

    sim400305 pointsBadges:
  • Problems with Expat in RPGLE

    Posted on behalf of MelissaG: I have an RPGLE program that receives an XML character string generated using CGIDEV2, and it is supposed to parse this XML in order to print those values in a spool file. My problem is that the RPGLE program that parses the XML sends an error message like 'Parse error...

    Margaret Rouse1,625 pointsBadges:
  • Subfile positioning while adding records

    Hi, I am having problem in repositioning subfile when I add a record. Scenario is like my subfile is self extending and page size is 4 .Data is like a,b,d. Suppose i add e then it gets positioned to e and page up don't work . It shows end of file found. Now if i add c it again position file to c...

    munduuu420 pointsBadges:
  • List of objects

    Hi.. I got to create a pf which will have list of objects present in all the user libraries availabe. When i use DSPOBJD, the server gets struck. DSPOBJD works fine when a specified library is specified. But in order to get all the objects, is there anyother options?

    Archnav01270 pointsBadges:
  • OPNQRYF & CPYFRMQRYF error

    The log is: output file file1 created file1 added to library mmember of file1 is opened in library. data option was not allowed with open option error reading member file1 in file1 0 records copied to file2

    Archnav01270 pointsBadges:
  • Outfile printing

    In CL, I've created a outfile out of dspobjd cmd. To this file, i've filtered a column using opnqryf. I've copied the output (cpyqryf) to a new file. While doing this, i'm getting the error data option was not allowed with open option' The log shows :The first file is created-> added to library....

    Archnav01270 pointsBadges:
  • Converting amount in character field to numeric in rpgle

    Hi, How to convert the amount value in character field(Eg: ' 5,000- ') to numeric in rpgle. I used %DEC built in function, it shows decimal data error. Is there any bulit in function or opcode to convert ' 5,000- ' to numeric field in rpgle ?

    LakNar270 pointsBadges:
  • Read the data from PF between dates

    I want to read the all the record from the pf which are between some dates Eg: A PF has one year data let say 2011 year data, I want to read all the records from that pf which are from 01/03/2011 to 05/06/2011 dates. the PF fields are DATE,NAME,ADDRESS,P_no. Can anyone help me how to do this in...

    vzvzxvcx160 pointsBadges:
  • Processing scanned data that is delimited by ASCII code 029

    Data that is provided by a vendor is to be scanned and processed, however instead of a fixed format, this data is "group separator" (ASCII Code 029) delimited. In the 5250 session screen field that the scanner writes to, the data is being loaded but the group separators are being stripped out. So...

    BigKat7,935 pointsBadges:
  • need help on getting day of the week for given date

    I am using the below sql to get the day of week but i am getting :NumWeekDay as 0 I am using V5R3...can some help me on this to get the day of week. C/Exec SQL Set :NumWeekDay = DayOfWeek_ISO(:MyDate) C/End-Exec the above sql to get the day of week

    SOW110 pointsBadges:
  • File Issue (Declared in OUTPUT mode)

    Hi All, A file (say FIL1) has been declared in outmode in a program A which is running continuously without ending and also writes the record in the file FIL1. There is an other program B which checks the record availablity in the file FIL1. But the problem is the problem A writes the record in...

    frmdeva365 pointsBadges:
  • Need a RPGLE program

    Hi, I want a RPGLE program which generate the next date. the input date format is YYYYMMDD...for eg. if we give today\'s ship date it would generate the tomorrow\'s ship date...it should exclude the weekend dates...I need it very urgent. Please help... simply i can say if we give today's date as...

    SOW110 pointsBadges:
  • Update duplicate record in rpgle

    I have a file where in filed1, field2 and field3 are key fields. Now these key fields are not unique, I need to update field 4, 5 and 6 based on the selection by user via subfile. To say f1 f2 f3 f4 f5 f6 A0123 A0123A *FILE CLM/D07 D07 1 A0123 A0123A *FILE CLM/D08 D08 2 A0123 A0123A *FILE CLM/D05...

    nasrunisar55 pointsBadges:
  • How to find the If – Endif relationship

    Hi it is very hard to find which END is related to which IF statement. I know we can find it during compilation by using \"Source listing indentation \" but for this we have to check the spool file. i wanna know is there any way to find it in source. I mean i have seen thousands line of codes where...

    ITKBHARAT120 pointsBadges:
  • Identifier is ambiguous .

    Hi I have a simple program that moves value \'a\' into a variable AB. the length of AB is 1. during debug I eval the value of AB.Instead of showing the value of AB it gives me the following notification : \"\"\"\" Identifier is ambiguous \"\"\"\". But when i am changing the variable name from...

    ITKBHARAT120 pointsBadges:
  • Month names between 2 numeric Cymd format dates

    hi, Hi, I have 2 Numeric field which has cymd date format Date1     7s 0 Date2      7s 0 date1  = 1110128    ( which is 2011-01-28    : January) date2 = 1120101  (which is 2012-01-01   ;January) So what i need is , I need to write records in a file , what are all the  months...

    22917510 pointsBadges:
  • WEB SERVICES ON SYSTEM I USING WEBSPHARE SERVER

    Hi,

    BISHT321245 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