• Checking for a folder in IFS

    Hi, please tell me how to check for the existence of a directory/folder in the IFS file system from a CL program.

    ten20081,150 pointsBadges:
  • Housekeeping Stream Files

    I am working on a utility program to housekeep stream files based upon how many days ago the file was created. I checked the DSPLNK command, but, this command does not provide the creation date. Does anyone happen to know if there is such a command that would provide this information, and...

    Piano520 pointsBadges:
  • Conversion of SQL Server 2000 to iSeries DB2 V6R1

    Hi there. We are converting SQL Server 2000 to DB2 on iSeries V6R1. We’re ok with the JDE tables and views, but are having difficulty with the non-JDE tables, views, and stored procedures. Is there a tool or something that could help us? Thank you.

    Tprusko5 pointsBadges:
  • Dynamic screen manager exit points/programs

    How are we supposed to define / register exit points/programs to the system to be invoked by the use of bindable API's. (For example the QsnMovWinUsr API of DSM?)

    Mikekspar15 pointsBadges:
  • How do I retrieve the JOB/USER/NBR for a spool file generated by a GUI program?

    I have a GUI program which HAS to run interactively that generates a spool file. The HTTP job (Which is what I correctly retrieved using RTVJOBA & QUSRJOBI) is: Job: VOI User: QTMHHTTP Number: 303484 But the job that my spool file has is: Job: QPRTJOB User: <My user ID> Number: 303384...

    Orelalaith0 pointsBadges:
  • How to write flat file data into pf?

    Hi,,  M25 is one of my flat file which is 34 char length. I want to write data from flat file to normal pf. Pf contains 3 char field which is equally devide. Now generaly to read file we have to requre key field but flat file doesn't have any key field then how i will write this pf?     

    Sms121185 pointsBadges:
  • How to get AS/400 macro to pull data from Excel

    Hello I’m trying to create a macro on the AS/400 that will pull data from an Excel sheet and input data to the screen. I know how to create a macro to run the menu option by using the record macro button but not sure how to get it to access the excel file so it will run through the list.

    dluy688020 pointsBadges:
  • Socket() “too many files open” error – but no files are open

    I am writing an RPG Sockets program and when I call the "C" socket() function, I am receiving an "EMFILE 3452 Too many open files for this process" error.  However, there are no other files open in this program. The code and prototypes are exactly the same as an existing "C" client that is...

    Grahamlovelady5 pointsBadges:
  • Corrupt .dbf files

    Dear Sir/Madam, I am using a software bases on Clipper, i made all the entries and then I indexed. The program stopped working and closed. Since then I'm unable to retrieve the latest data from the .dbf files. Thanking you in advance.

    pliv8315 pointsBadges:
  • Declare variables in RPGLE program

    How will we declare variables in an RPGLE program which have the same field names of a file that is declared in the PF?

    vasanthisrini10 pointsBadges:
  • AS/400 Printing Trouble

    Hello. My company upgraded our AS400 from v5r4m0 to v6r1m0 about a year ago. Ever since we've had issues with printers going into *END status randomly. The printers are two IBM InfoPrint 6400's. We never had this issue on our old AS400. During the day when we see it happen we just WRKWTR and use...

    Lemonjello100 pointsBadges:
  • COBOL/400 Program-ID query

    Hello Friends, I have a question related to PROGRAM-ID. Scenario: Source name is “PGMA”.I specify program name as “PGMB” in PROGRAM-ID. While compilation it hasn’t thrown any compilation error. Since it’s not throwing any compilation error, then what is the significance of PROGRAM-ID...

    BibinGeorge130 pointsBadges:
  • Adding remote location in AS/400

    We have an AS/400 in California and wish to allow a new warehouse in Texas to communicate to our AS/400 and print forms in their warehouse. What is the easiest way to do this? I’m not sure if it is best to set up a T1 line with a modem and controller, or to use some sort of PC connection....

    zbbwoc95 pointsBadges:
  • Filesize PDF Spoolfile with overlay via InfoPrint or OVRPRTF TOSTMF WSCST(*PDF) Opties

    All, I'm doing some tests with spoolfiles with an overlay which I want converted to PDF. I have tested two ways, using the same overlay object, to do the conversion; - Via Infoprint tooling. Put the spoolfile in a special outq which is attached to the IFS - Via the 'new' OVRPRTF command which has...

    SanderP5 pointsBadges:
  • AS/400 CPYTOPCD

    I am using CPYTOPCD in AS/400 cl to copy an invoice spool file to a PC document. I then email the document to myself (as a test). My goal is to be able to email invoices, instead of printing them. I am using format PC data as *text. When I open my emailed document, the spaces have been randomly...

    DebOsborn5 pointsBadges:
  • External DB2 Database link/trigger

    In Oracle I can register a database link to other data sources. For example, through ODBC I have registered DB2 as a database link. In this way I can read/insert/update from/into DB2 tables.

    r.otto810 pointsBadges:
  • How to calculate diff in time of two diff time stamp

    I have a table in that two fields stores the value of time stamp for eg 2009-12-10-20.00.26.424000 - DQ1CREATED 2009-12-10-20.00.26.860000-DQ2CREATED these two fields should be compared such that if there is a diff of 5 mins I need to get an alert as well as if any one of the field is blank I need...

    PrashanthR0750 pointsBadges:
  • Can I backup to disk with BRMS?

    Can I backup to disk with BRMS?

    Webdevyahoocom5 pointsBadges:
  • Convert iSeries Character set in VB

    I am creating a VBA macro in an Excel spreadsheet to download selected data from an iSeries database. Running into an issue with character set. I don't understand VB well enough yet and have not had success w/ google in resolving this. I appear to be getting the data, but a lot of the fields are...

    azohawk620 pointsBadges:
  • Creating a PDF from multiple spool files

    I have a project where multiple spool files are created. The users want to view each spool file to determine which ones they want to keep. After viewing and deleting the unwanted spool files they want to create a PDF file to send. I have found ways of converting spool files to PDF right after they...

    lgronewold10 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