• Merging columns from 2 different files

    I want to merg data from 2 different files.  1 column in both files has same type of data but the headers (Library and Libraries) are different and the fieldnames (ODLBNM & MLLIB).  Is there a way to merge both columns into 1 column?

    brl20 pointsBadges:
  • Array size

    Hi, I have used array to store ItemNUmbers, D Arry S 15A DIM(9999) But I am getting error as Array index is out of range... I knew that file has more item numbers. I need nearly 70000000 So please tell me the maximum size of array.... Ans : DIM( ?????? )

    22917515 pointsBadges:
  • Authority on a JOBQ

    How can I check that a particular user is authorized to a JOBQ or not?

    asakla240 pointsBadges:
  • Authority on a user profile

    I have a screen where I have a field to input a User ID, I need to validate that the user who is entering the user profile (of some other user) is authorized to the user profile or not.

    asakla240 pointsBadges:
  • Dynamic array

    I want to declare the number of elements of an array dynamically in RPGLE. How to do it? Please reply.

    Sai4AS4001,420 pointsBadges:
  • RPGILE To RPG IV conversion

    How RPG/400 code can be converted to RPG IV code with a single command?

    Sai4AS4001,420 pointsBadges:
  • DBCS

    What is DBCS(Double byte Character Set)?..what purpose we use it?

    Sai4AS4001,420 pointsBadges:
  • How to read MS SQL tables using iSeries RPG

    Has anyone found a technique for reading data directly from MS SQL using an iSeries RPG program?

    WoodEngineer6,875 pointsBadges:
  • Problem while using SSCANF funtion in RPGLE!

    Hi, I am trying to check whether a string is numeric or not so for that I'm using SSCANF but every time its giving me return a 0 . Not sure what I'm doing wrong! Below is my code: I am always getting i=0 ideally it should be 1234 ... Please suggest!

    munduuu435 pointsBadges:
  • Spool file info

    I need to capture spool file information from a job within that job. I can get most of the info from using RTVJOBA but how do I get the file number?

    RayM265 pointsBadges:
  • Key list in AS/400

     I have defined 3 keyfields in my logical file and I'm using them in my program as keylist parameters. Is it possible to perform chain operation using first and third keyfield? If not can you please tell me the other alternative?

    Ajit256010 pointsBadges:
  • Batch job performence

    Can anybody tell me how to reduce the running time of a Batch job?

    Sai4AS4001,420 pointsBadges:
  • Column heading issue with RUNQRY in CL

    I have a CL program which has a RUNQRY. I have two input files and I have defined the result fields. I have given an expression and I have used column heading. The issue is after executing the query, if I do a RUNQRY on the outfile, I am not able to see the column headings of the defined fields....

    RamvishakRamesh2,505 pointsBadges:
  • iSeries SQL Cobol

    In my COBOL SQL select statement that was previously running on V5R4, I was able to extract a date field defined with "date" as the data type. We are now on V7R1 and we get a data mapping error. No clue as to why? Any ideas? thanks

    Pgmr4660 pointsBadges:
  • DYMO LabelWriter 450 local printer troubles

    We are no longer able to print to our label printer. The PC we were using had to be replaced. We need to know how to set up this printer so it will print addresses via USB connection. I downloaded and installed the correct drivers for the printer. I used printer model *WSCST to configure the...

    Stigapproved30 pointsBadges:
  • Journal Before/After image not in plain text

    I have a journaled file that I need to review the before and after image of a field change. When I look at the field, the characters in both the before and after images are unreadable (strange characters, blocks, etc.). How do I view the journal image in plain text, or convert it to plain text?

    CollickB40 pointsBadges:
  • Updating a physical file

    Suppose I have a RPGLE Program P1 And P2 and a physical file PF1 . P1 using PF1 in update mode and p2 also using Pf1 in update mode. When P1 calls P2, it throws an error saying file locked. What can be done. I need to update pf1 in both the progs.

    jainamit380 pointsBadges:
  • webservice and iDB2 connections slow on startup

    We have a web service running on a SQL server sending data to our I-Series using a DB2 connection. The first time the service is run to submit an order, there is a long delay before it is submitted. On repeated orders it much quicker. Is there something we can do to speed up the initial connection?...

    ToddN200015,605 pointsBadges:
  • Data missing in CPYTOIMPF

    I am doing CPYTOIMPF FROMFILE(MIUOALLV1/LSJSEP) TOFILE(QTEMP/LOWA5P) + TOCCSID(*FILE) STMFCCSID(*PCASCII) + STRDLM(*DBLQUOTE) FLDDLM(';') + DECPNT(*COMMA)) Where LSJSEP is a file with 50 fields , total length of the fields is arounf 1500 , LOWA5P is a file with only one field of length 12000. The...

    asakla240 pointsBadges:
  • Sending Japanese characters from Websphere Message Broker to iSeries

    We have a requirement to send data from WebSphere Message Broker to an iSeries via MQ. The message triggers a call to an RPGILE program which will process the message and write the data out to JD Edwards database files. The messages on the broker are encoded as CCSID 1208. The iSeries OS has a...

    tonyflavell10 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