• DB2 on iSeries V7R1

    Hello all, Can any one help on communicating db2 database on iSeries (V7R1) with DB2 v9.7 client on Red Hat linux ( RHEL6) ..? Thanks in advance. Regards, shankar

    umashankar2a120 pointsBadges:
  • Getting info on DFU usage

    I'm embarrassed to ask, but ... Is there a way to find occurrences of DFU usage? Even better if it excludes DSPDTA. TMI - The prior regime here was pro DFU. So just revoking all authority to it would be disruptive in the short run. So identifying users/data files/dates would be a good start toward...

    aceofdelts2,330 pointsBadges:
  • Run query on AS/400

    How do I run a query on AS/400?

    dwaynef5 pointsBadges:
  • Trimming leading zeros in as/400

    Hi, I have a character input parameter of length 8. I have a customer number which may vary according to a query that user enters. This customer number is searched in an input file where the key field is numeric. I want to change this input parameter to numeric without any trailing zeros/blanks....

    Sangay635 pointsBadges:
  • How to find the fullpath/absolute path of a file at AS400?

    One program file (MYFILE) exist at one Library (MYLIBRARY), but how to know the fullpath/absolute path of this program file ? Can not find the file at /MYLIBRARY/MYFILE, where is the file located ?

    As400fullpath15 pointsBadges:
  • QSECOFR sign on

    DSPUSRPRF QSECOFR shows Previous sign on 08/01/16 05:34:21 Password verification not valid 0 Days before password expires 0 This suggests that a successful sign on took place but that the password is expired. Can anyone suggest why this is?

    Jonesy5 pointsBadges:
  • UIM menus in AS/400

    AS/400 question: In UIM menu Libraray was hard coded as shown below. :MENUI HELP='menu/option1' OPTION=1 ACTION='CMD ?CPYDLLICD FROMMBR() FROMLIB(BCDLLD3)' ACTION=' TOLIB(BCDLLD3)' ACTION='MBROPT(*REPLACE)' My question is: Without hard code the library (BCDLLD3) in UIM menu, how do I pick the...

    chowas400620 pointsBadges:
  • Encountering slow down at CPYTOSTMF command

    Hi. We have a program in AS/400 that uses CPYTOSTMF to download a AS/400 file located in qtemp to PC. However recently a slowdown has been observed when running this command (average of 10minutes), regardless if the number of records being downloaded. The program which has this command is being...

    Pinkgirl2185 pointsBadges:
  • Any suggestions on how to setup logging for Java programs in AS/400?

    Hi, I have written a simple Java program and am trying to setup the log4j. Unable to set it up. There is no error nothing, the program continues but the log file is just not created. I am using Apache log4j-1.2.16.jar and using log4j properties file to configure. Stuck with this for 2 weeks now and...

    Pranav0712110 pointsBadges:
  • Schedule bi-weekly job.

    We have a job that needs to run every two weeks (bi-weekly). The job scheduler (WRKJOBSCDE) only allows daily, weekly or monthly freguencies. Is there another way to schedule bi-weekly jobs?

    RonBender155 pointsBadges:
  • PDF not searchable with OVRPRTF and Overlay

    We are creating .PDF files with OVRPRTF and overlays, but the .PDF file is not searchable. Is there a way to make them searchable? Thanks!

    lscott15 pointsBadges:
  • Using two same files from different libraries in a RPGLE program.

    Hi All, Please guide me for the following problem. I got stuck into it. I want to operate same file from two different libraries in a RPGLE program. Remember we are taking the file names at runtime. So we don?t know the structure of files. Like the record format name etc. Again somehow I retrieve...

    navinnegi45 pointsBadges:
  • How to transfer an iSeries file

    How to transfer the file from one iSeries to another iSeries?

    ankit2002770 pointsBadges:
  • We’re looking to add a field description in a DB2/400 file

    My partner and I have a set of files on an AS/400 system but we don't have DDS for (the files were created in SQL). We would like to add field descriptions but we're struggling to find how to do this in AS/400.Could someone tell me how we can add a field description? Is directly updating...

    ITKE409,120 pointsBadges:
  • Upload to AS400 DB file

    Hi I am not so proficient in programming and i am looking for a way to upload an excel sheet into a database file (with same columns as in m excel) on the as400. I tried to FTP, but i goes in as a flat file. Various other FTP options using FDF etc have failed. Any suggestions ? Thanks Raman

    Dashingraman15 pointsBadges:
  • Record format in DB2/400

    How to check file name using record format in DB2/400?

    vishwaraj60 pointsBadges:
  • DB2 to Text File Conversion and Transfer

    I have created a Text File from my AS/400 DB2 table. I want to transfer this file from one iSeries system to another. How to do this?

    gvdsswami20 pointsBadges:
  • Reading a file twice in CL

    I declared a file in CL. I read all the records, i.e End Of File has reached. Now again i want to read he file from beginning within the same program.I tried with OVRDBF and POSDBF.But could not succeed.Can any body help me?

    Kumari0 pointsBadges:
  • AS/400 Job log not generating

    In my server JOB log (Spool file) {QPJOBLOG} is not generating for successfully completion jobs. Which parameters I need to check? Is there any system value I need to change?

    venky48470 pointsBadges:
  • Advantages of AS/400

    Hi, Please let me know the Advantages of AS/400 when compared to Windows, Unix servers. Regards S.Manjunath

    Accenture130 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