• Database Track Payment Information

    I need some expert advice.  I need an application to track payment information.  The payments are actually stored on the AS400 and the payment arrangements are stored currently on paper.  I was considering using Access and setting up an ODBC/OLEDB driver to my AS400 to collect the most update to...

    lorit365 pointsBadges:
  • E-mailing and Populating data into a Lotus Document from Reports on Multiple LPARs.

    Every month we have to gather BMRS tape usage data across 14 LPARs by copying the stats from a report and pasting it into an e-mail and also a Lotus Notes Document, which is a checklist item which gets posted as a Daily report.    I would like to know how one could read these stats into one...

    IT40010 pointsBadges:
  • Client Access V5R2 and AS/400

    A batch pgm written in VB is reading a data queue file that exists on AS/400. The read is coded so that it waits for data to be entered in the data queue (-1). When the batch pgm is waiting for data to be entered into the data queue the user is not able to start logon secession to the AS/400. If...

    Cz80pj0 pointsBadges:
  • Printer File query

    I believe Printer File DDS will be written in the RPG source itself. In that case, what is the necessity in creating the Printer File by using command CRTPRTF? Actullay why the program is not taking care of the creating the PRTF object when is defined as Program Defined in F spec.

    Kar425 pointsBadges:
  • AS/400 FTP error- TCP3D2C Secure connection error, return code -24

    I am trying to FTP from Backup AS/400 box to our Production AS/400 box or visa versa and I get the following error when trying to transfer a file of any significant size(larger than 1Kb):

    ShawnPgmr60 pointsBadges:
  • Querying multiple member PF with SQL

    I would need to SQL on a multiple member PF and I need to query the 2nd or nth member in the PF.  Is this possible just with an SQL query without using OVRDBF etc.?

    Rajgoaj280 pointsBadges:
  • how to code the parameters for API QUSRSPLA

    i want to get the last print file generated from a job which was created AFTER the time the program producing the print file ran. my methodology was to 1. rtvsysval qtime 2. execute the program 3. execute the api qusrspla 4. test the create time and determine if it was greater than the time i...

    matis75 pointsBadges:
  • HMC V7R3.2.0.1 connection problem

    Hi, I am trying to connect to HMC using client access.On the configure PC5250 screen I use the following: a Update the System Name to the HMC host name or TCP/IP address. b Set the port number to 2300. c Press the Properties button. The properties button will launch the Connection dialog shown...

    Hugheswilliams345 pointsBadges:
  • extracting data and converting AS400 date format

    hi, this question is very simple I should guess.. I am trying to extract data from AS400 into excel, and since date format is CYMD, I want it to show in a MM/DD/YYYY format. Please show me how.. Thank you very much! p.s. in SQL please

    MasterJediWannabe15 pointsBadges:
  • Isolation level in iseries DB2

    How to set isolation level in iseries DB2? please reply.

    ORS5 pointsBadges:
  • Difference between RPGIII RPG IV and RPGLE

    1)Can some one tell me the major differences between them? 2)Subprocedures, Built in func etc stuff does come under RPGIV or RPGLE? 3) I beleive Actiation groups, static Binding, modules, Service pgms.. does come under RPGLE? please explain me a bit clear, and it would be thankful if you have...

    Kar425 pointsBadges:

    Hi Every body ! I have been working on V4R4M0, Now have to work on SQL-RPG Programs. I don't know, how to write queries and other things . Can some one help me to learn SQL-RPG with good meterial ?

    Abdulonas400125 pointsBadges:
  • AS/400 Disaster Recovery – Restore Date preservation

    Is there a way to preserve an object's Restore Date (as seen when using the DSPOBJD command)?  Ex:  When conducting a Disaster Recovery test, we would prefer to retain the existing Restore Dates of our objects rather than having all objects updated with the Restore Date of our disaster recovery...

    JFISCHER5 pointsBadges:
  • Automaticall Refresh Display (COBOL)

    I have a need to have the screen do an Automatic Refresh. I have created a working sample using CLP and setting the Display file to waitrcd(5). CRTDSPF WAITRCD(5). So I know it can work. I have found several examples using RPG. I need to do it using COBOL. Can any one help? I have taken everything...

    KSC90 pointsBadges:
  • AS400 – From a HP LJ 1300 to a HP LJ P1505

    I just replaced a Locally attached HP 1300 laserjet with a HP 1505 Laserjet I series printer. The printer will print "Print Screens" but will not print our decals(??) I release the spool file, it goes back to a *SAV status but it will not print to the new printer. I have made sure the I series name...

    Rmason345 pointsBadges:
  • cpysplf problem in cl program

    i have a cl program with the cpysplf command that is executed within it. before executing, it retrieves all the spool file attributes from a declared file. when i debug the program all the attributes are correct but it doesn't copy to the physical file. the file is at the top of my library list and...

    SKF75 pointsBadges:
  • Programmatically (CLP) delete performance data.

    How do I programmatically (CLP) delete all performance data except the current month's data?

    Clathan15 pointsBadges:

    I have a program that emails from the spool file whenthe user uses option "E". I created this. Anyway. It blows up on a spool file that has a barcode in it defined. "Attributes of file RB421P not supported." b/c of AFPDS barcoding it fails to create the file so I can do snddst command. Any ideas...

    RonKoontz1,780 pointsBadges:
  • word/excel/presentation on as/400

    HI, i donno why IBM is still not come up with a good built- in tool like MS office with the IBM i.Emails and weblication should be also there inside the application which will really enhance the use of IBM i. Can any body project views on this plz?

    ten20081,150 pointsBadges:
  • InfoPrint – Spool File to PDF mapping object

    have got spool file to pdf working using infoprint, stored in IFS and sent as email. Does anyone have example of mapping object so change directory path and name of pdf file when stored in ifs? System uses job name etc. which will be variable. Thanks

    annehill55 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.