• Printer files in AS400

    Hi.. In our AS400 server many printer files are there. when we use WRKACTJOB to see the status, some printer files(QSPL)are always in RUN status and its taking too much CPU %. what will be the problem ?

    Sureyz2,655 pointsBadges:
  • How to create an EXCEL

    I queried on file and fetch nearly 10000 records.I want these recrods in the excel,however I dont want to copy and paste.It will take a lot of time. Is there any method or command in AS400 which can do this task,

    ankit2002770 pointsBadges:
  • scheduled job

    how to check the user that changed a scheduled job from held to release?? because we have a backup job in WRKJOBSCDE that is in held and being submitted daily manually. but what happen is that it run it self in QBATCH and we are also submitting the job again. so it create a duplicate backup on the...

    joverparas380 pointsBadges:
  • result of CHAIN with a bad key

    Rather than proving it out myself, it's so much easier to ask if anyone has run into this before. While researching a bug, I found a program that chains to a file using a 3-field key list. BUT - the 2nd and 3rd fields are "wrong" (defined as alpha in the key list but numeric in the file). Seems...

    aceofdelts2,250 pointsBadges:
  • Please help with SQL query

    I have a file which has 6 different account numbers. For each of this account number, I need to check in File1 which has account number, security and Quantity. I need to sum up the qty field for a combination of Acc num and security. Once I get the security, I need to search in another file say...

    RamvishakRamesh2,505 pointsBadges:
  • System i Navigator Run SQL Script block CL commands

    Hello. The run sql script in System i Navigator allows me to run CL commands. How can i block this? Thx in advance.

    MelGranja20 pointsBadges:
  • Message file within message subfile

    I have created a message file and now i want to link my message file to the DDS. Please suggest any way....

    sonaliray10 pointsBadges:
  • File read

    I have a file1 with a field account number. Accnum A B C I have another file2 with field Accnum, Security and Qty AccNum Security Qty A X 1 A X 3 A Y 2 A Y 3 Now I need to generate a summary file like this by summing up the quantity for those records with same account number and Qty A X 4 A Y 6 B X...

    RamvishakRamesh2,505 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:
  • How to capture decimal value of numeric fld

    I need a way to capture the decimal value of a numeric field (i.e. 5.78). Need a way to be able to break the decimal value away to do computations on it. How do I achieve this using RPG III coding techniques?

    Tom196035 pointsBadges:
  • Error Message Display

    We have written an RPG program that runs on a Hand Held RF Scanner running a 5250 emulation program. We defined the screen to display error messages on line 12 o fhte display. When we run the program on the scanner or a standard display screen, the error message always displays on line 24. Any idea...

    SteveLane662855 pointsBadges:
  • Disaster recovery exercise steps for AS400

    Hello..would like to know what are the steps for a disaster recovery exercise on as400?

    100282145 pointsBadges:
  • Authority to some objects in a library to which user already has access

    Hello A user is already having access to a specific library but he complained about not having authority to some PFs and queries existing in the same library? 1Not sure how the access is not there in first place? 2) to grant access now do we need to add *ALL authority for each individual object?...

    100282145 pointsBadges:
  • RPGLE day, month and year calculation

    I want to fixed the day by hardcode, retrieve the year from system and want the month 6 month before. can anyone help me...

    fariha12310 pointsBadges:

    I am making a CSV file from a PF which has a character field which holds a numeric decimal data. Eg 9,500.000000. But when it becomes a csv data, the value became 9.500.000000. (',' is converted to a period) I can see FLDDEL ',' and a RPLFLDDEL '.' as default. I dont want to convert the comma in...

    RamvishakRamesh2,505 pointsBadges:
  • Numeric string in Character field with commas

    I have a character field with value '9,405.000000'. I want to convert it to numeric. But the ',' is causing issue in %Dec. . How can I get the value 9405.000000 in a numeric field?

    RamvishakRamesh2,505 pointsBadges:
  • Printer Authorization iSeries

    What on the iSeries uses the Printer Authorization List and what criteria depicts what we are supposed to add into it?

    Dblbogy65 pointsBadges:
  • Grant Authority to directory in root directory

    Hi All, How do I grant authority for selected users to access a directory we have built in the root directory containing a transmittal file? I used WRKLNK, but there is no authority access like when you have a folder. Thanks!

    NYRANGER245 pointsBadges:
  • How to call/connect to an external webservice?

    Hi, I'm very new to web services and still learning the fundamentals. I got a wsdl from a vendor for which I generated the java client using the wizard in RAD. I choose the EJB Project as the client project type while running the wizard. The wizard generated all the different beans and also a...

    hrc20 pointsBadges:

    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:

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.