• redord retrieval in SQLRPG

    Hi, can anybody tell me how to retrieve a record randomly using cursors...(say 8th record) using SQLRPG(Embedded sql)

    ten20081,150 pointsBadges:
  • How do I create a subfile which has fields in the SFL Record Format with different attributes?

    I need to design a subfile which takes the field name and attribute as the *entry parameter and then based on that field a specific file will be read and the detailed record will be shown in the subfile screen. The issue is each time the field name & attributr may differ, so accordingly how do i...

    PRIYAS40 pointsBadges:
  • CPF0006 during SBMJOB (COOL 2E generated code)

    I have used SBMJOB in the COOL 2E SYNON code (Generating COBOL source). During runtime, the fucntion crashes with CPF0006 message when trying to submit the program through Y2CMEXC. Is it the error caused by the Y2BLSJR command through which the parameters for the SBMJOB is set? Parameter 1 MOVE...

    Gokulvirtual15 pointsBadges:
  • Unable to over ride a PF member

    Hi, I made a cl program and in it I over ride a pf member, clrpfm then call my rpgle program. I can't write on my member but instead it writes on the primary member and reads it. seems the member that is used is the the primary member and not the member that I over rides.

    Ayterrobias5 pointsBadges:
  • AS/400 Change Transport Log

    We have a request to obtain the change transport log to show which objects were transported by which users on what date. How would we get that information? Thanks

    Porcini5 pointsBadges:
  • AS400 Cobol screen write hanging up

    I am an RPG programmer, but have a client with a cobol issue. When the program does a write to a screen it never returns to the read statement. No error is issued and we have to cancel the job. Any ideas or suggestions?

    400Man5 pointsBadges:
  • SOC4 with reason code 11

    how can identify which line in cobol cause the index error if the program has multiple array table.

    A9720005 pointsBadges:
  • PROGRAMMER DELETED SOURCE FILES

    Recently I asked an AS400 RPG programmer who has worked here over 9 years to delete PF's in their test library. This person also deleted their test source files (QRPGSRC, QCLSRC, ECT) Does anyone have thoughts on this? I really appreciate this.

    0 pointsBadges:
  • Date Handling

    How do you add a numeric field to a system date and have it calculate a new date with the variable numeric number added to the date - ex. 2009-02-07>>> 2009-02-10. (in this example, the numeric value would have a "3" loaded into it)

    Gallack10 pointsBadges:
  • AS/400 Query – How to combine 2 fields but delete the null space?

    fields a: School , in the fileld a there are 3 null space after school, field b: I choose , now I want to combine filed a and field b by using "||" as a new field, how to delete the null space

    Milahuang995 pointsBadges:
  • Cl program that reads a datafile for ftp

    i need an example of cl program that reads a file containing ftp commands and executes the commands in their arrival sequence. thanks.

    Lacag100 pointsBadges:
  • AS/400 STRTCP Authority Required

    What is the minimum amount of user authority that can be granted to run the STRTCP command without handing over *ALLOBJ authority?

    Bdigilio10 pointsBadges:
  • Partition Creation Error

    When trying to create a partition on a logical drive I receive the following error message: 'The Operation was cancelled due to an Internal error' and the partition failed to create. I have tried deleting the array and recreating the logical drive but it failed to resolve the issue. I have run...

    Gmil15 pointsBadges:
  • Java400

    How to implement simple java program(to display Helloworld Program) in Synon or AS/400?Please let me know? Thanks in advance...

    Kalaivanirajan5 pointsBadges:
  • joblog as400 printing

    I'm running a job that could write many joblogs. What I want: if there are any kind of errors (even those answered with an Ignore) the joblog will print, else there is no joblog printed. I can get prints on a hard cancel of a clp but not if answered with an ignore.

    Brenger170 pointsBadges:
  • Embedded SQL over multiple physical file members

    Hi, I'm writing a program to process all the members in a physical file. I've done this using embedded SQL because the selection criteria is quite complex. The physical file belongs to an application which I can't change, so I will always have to deal with multiple members. I also don't have the...

    Gilly40023,730 pointsBadges:
  • User profile storage in AS/400.

    Hello, How to calculate profile storage? Is there any chart is available for this? I really gets confused when I was dealing with profile storage. Thanks in advanceā€¦ Regards, Nitin

    Nit40030 pointsBadges:
  • License error CWBLM001 revisited

    Hello all, I am still having an issue with an Internal LIcense error (reference prior question and answer below). What we have found is, the issue does not exist in V5r3. It is when we upgrade to V5r4 that the issue surfaces. We have to go to V5r4 for the 128 bit encrytpion option. All Service...

    Clickster30 pointsBadges:
  • Attention Light on Tape Drive I5 Model 520

    We have an I5 Model 520, with a 5755 tape drive attached. We upgraded from V5R3 to V5R4 about a month ago and shortly after, the attention light on the tape came on (blinks). We thought maybe an IPL would clear this up or by cleaning the tape drive several times, but no luck. We can't seem to find...

    I5NEPA0 pointsBadges:
  • AS400 DDS Specifications and Arrays

    We are working toward converting our system from a S/36 to an AS400 S36/E. On the way we are attempting to create DDS specifications for our files and externally define the files to the RPG code. We are prototyping a program to read the RPG II programs and build the DDS specifications from the...

    Kirk4890635 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