• BI product

    We are using KBM software for our ERP system. We have a mandate to build a data warehouse so we can use a good BI tool to extract data. We would like to run this on our AS400. Does anyone have suggestions as to a good product for us to investigate?

    CharlieBrowne39,815 pointsBadges:
  • COBOL reading RPG created files

    I am trying to read a RPG created file with special characters in the data fields (EX: EP$DEPT,etc). Is there a way I can remap the fields in a COBOL program. I tried a logical mapping over the PF but when I rename the fields in the LF removing the $ sign, I get compile errors because the LF can't...

    Theraven35 pointsBadges:
  • Execute from a source member list

    I saw a colleague run something, and I know he built the user defined option (F16) "EX" in the WRKxxxPDM display, I don't know the CMD/CL routine or Syntax for the source file/type. Thanks in advance! Dan

    dinks5715 pointsBadges:
  • PRT01 is in MSGW

    When I check for the WRKCFGSTS, I am seeing this status: PRT01 * IPDS Offline or not yet available. Unable to vary on...

    didinu760 pointsBadges:
  • An OUTQ has been deleted from our system, unable to find even using dspjrne

    We have an OUTQ which got deleted yesterday, however we tried checking thru DSPJRNE and other means as LOGs, however it doesn't show up. The only thing which comes in the log is when the writer has ended. The obj deletion is not coming up.

    harisudhan211,005 pointsBadges:
  • FTP related

    We have send a file to a particular location can we see the content what we have sent, since they are saying that file they received is not in correct format? (users are saying header and footer was missed,getting some error) but could see header and footer was there from our end to the file we...

    ravula690 pointsBadges:
  • Running a script

    I have a compliance requirement to convert all FTP jobs to SFTP. However SFTP does not work on Windows 2008 server the same way it works in Unix or AS400. In windows 2008 server, when you send a file via SFTP, it can only place it on local hard drive of that server. Currently, our production 'XYZ'...

    ravula690 pointsBadges:
  • RPGLE trigger tables AS/400

    Hi, Does RPGLE triggers can be added to the tables? I created a Table and RPGLE Trigger. But I am getting error saying 'Receiver too small to hold the result'. But the same code is accepting the physical files. Do I need to set any attributes while creating the RPGLE triggers or tables? Please...

    As400pgmmer305 pointsBadges:
  • Debugging a Batch Job

    Hi,I was debugging a COBOL/400 batch job. I am proceeding as per the below steps: 1. SBMJOB ... HOLD(*YES) 2. STRSRVJOB JOB(jobnbr/user/jobnam) 3. STRDBG When source is displayed, press F12 4. RLSJOB JOB(jobnbr/user/jobnam) When Start Serviced Job display appears, press F10 5. When command entry...

    mvrkrishna525 pointsBadges:
  • Connection String for AS/400

    Hi all. Here I'm using iSeries Server. I just want to connect VB.NET with AS/400 database. Simply I want to retrieve some data from a PF on VB.NET. Anybody can you tell me what is the connection string should be used? If you have any simple sample code in VB.NET please post here... Surey

    Sureyz2,300 pointsBadges:
  • Example of Self-Join Logical File?

    Does anybody have an example of Self-Join Logical File code?

    svankipu560 pointsBadges:
  • Program is expecting a file not used in this call

    I have 2 different environments using 2 different library lists. A user takes an option from a menu and a CL program is called with overrides to a database file and then an interactive RPG program is called. The user then exits this program and then goes to the other environment (different...

    Sofarsogood60 pointsBadges:
  • Uploading PTF file from local PC to AS/400

    Hi, I do not have access to iSeries Navigtor to make this transfer. I need some ways to transfer a PTF from local PC to AS/400.

    didinu760 pointsBadges:
  • Remove Trailing & Leading Spaces in COBOL/400

    Hi Group, How do we remove Trailing & leading spaces from a field in cobol/400? Please explain with an example Thanks & Regards, M

    mvrkrishna525 pointsBadges:
  • Printing text in BOLD letters

    How to print the fields in bold letters in printer file? Can you give me a sample program?

    needanswers30 pointsBadges:
  • Using QUSRTVUS API in COBOL

    I want to list all the Job Schedule entries and save them in a Physical file , I used API QWCLSCDE to fetch that list in a User Space , then I did a QUSRTVUS to load the data in my COBOL program. As the variable Starting position and Length of data are Binary, and I am passing values 1 and 28 to...

    asakla240 pointsBadges:
  • Hi experts: AS400 + Hibernate

    Hi experts, Does Hibernate require AFTER and BOTH the Images of Journalling (Journalled files). Please let us know. Or After image alone is enough for Hibernate? AFTER or BOTH images is better to use for database? Thanks , Amutha

    As400pgmmer305 pointsBadges:
  • Message subfile

    Is there any way to prevent the message subfile to have the system generated messages? I have a monitor block in my program and the message tracked by the on-error block is appearing to the user through the message subfile, I dont want this to happen. Any suggestions?

    RamvishakRamesh2,410 pointsBadges:
  • Remove blank space and dash

    Hi, I wanted to know how can write code in RPGLE for input as 123-456-7 8 9  and output as 123456789? Please help.

    kirti26915 pointsBadges:
  • How does KLIST work?

    Hi, I'm debugging an RPG program and came across a 'KLIST ' with 'KFLDS'. What I know so far is that a KLIST is used as a search argument and KFLDS make up the argument, but what I want to know is how does this actually work? Are the KFLDS concentrated to make up one search argument or does a KLIST...

    jailall101735 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