• AS400 FTP Issue

    Hi, We are using a tool (Viscom) which will read the ftp scripts from the QCTL (Another tool where FTP Scripts will be stored) and transfer the files to different ftp/as400 servers. We are trying to connect a FTP site from AS400 using the password as "acvy_p" and password as "10qp!)QP". When this...

    Maheshero40 pointsBadges:
  • Example of Cobol call to an SQL stored procedure

    I am new to the iSeries and need to know how to use a Cobol program to call an SQL stored procedure. Someone has already created the stored procedure for me, but I am not sure how to call stored procedures in Cobol on the iSeries. The passed data looks like: FIND_CLIENT ( IN LastName CHAR(35), IN...

    Dfe07225 pointsBadges:
  • Removing zeros from .csv file

    I'm creating a .csv file using CPYTOIMPF Command.. I have a numeric Field in the File. I want to remove the zeros since i am not using it regularly. Pls help me

    Babs30 pointsBadges:
  • AS400 Backup Job Submitted but not run

    I have setup my AS400 to run weekly backups. But all that happens is the job gets queued and is subsequently never run.  I have backup jobs on queue for last couple months. I have even changed the backup setting so that I am sure the selected library is not in use, but still the backup never runs....

    As400novice165 pointsBadges:
  • EBCDIC Database File Problem

    My company received a file supposedly in EBCDIC format. We copied it to the shared network drive and attempted to FTP it several different times using several different types. The file transferred but when displaying it the records were all variable length and appears to have CR or EOL special...

    SKF75 pointsBadges:
  • Command to show daily save file verification

    It there a command as with DSPOBJD QSAVSYS *DTAARA DETAIL(*FULL) to show  the Daily save file details, IF I am out of line here I apologize,

    Vandalia5 pointsBadges:
  • Create trigger using iSeries Navigator

    I am trying to ceate a simple trigger to a table to update a history file with the old rate when the rate changes in the master table. I have gone as far as creating the sql statement, but I am not able to make it to work (my sql is very limitted). Would it be possible to have some example that I...

    Myhandle5405 pointsBadges:
  • CL Report priniting

    I created a 4 pages report. When I print all the 4 pages prints in 2 papers. Its not prining in 4 pages

    Ije35 pointsBadges:
  • Trying to get select all in a dropdown from the AS400 to SSRS(Urgent)

    I am have troble trying to get a select all fuction using AS/400 data on Mircosoft reporting services. Normally I know you just go into the parameter and click multivalued but that is not working. I have create a Stored procedure to use the calender feature for date I don't know if there is a way...

    AMcAuley3105 pointsBadges:
  • Error trying to get a store produce to work from AS 400 to SSRS

    I have made a store procedure that runs fine but when I try to Call it into SSRS I am getting an error. The Error says SP_Convert_Date_MMDDYYY_to_CYYMMDD in *N type *N not found. Is there anyway of getting it to find my file in the AS 400 and what would I have to do?

    AMcAuley3105 pointsBadges:
  • Chat Server for the enterprise

    Can any one tell me about the best chat server for enterprise for internal messaing, file sending & video comferencing is added advantage.

    Jags nitco0 pointsBadges:
  • RPG /Free Local Data Area definitions

    I am trying to define the LDA with an external definition in RPG /free. Any help?

    Rstinsonindy15 pointsBadges:
  • Auditing User Access in AS/400

    I am trying to figure out how to audit user access at the record level. In the Audit Journal the entry types ZC and ZR tell me at the file level who has opened a file for Change or Read. In the Journal, the Journal code of R along with the type code will give me information on who has added,...

    wpoulin2,480 pointsBadges:
  • We’ll trade you an Xbox 360 for your knowledge!

    The holidays are approaching and so is your next chance to win an Xbox 360 by simply doing what you do around IT Knowledge Exchange. Between today and December 15th, the three members who accumulate the most knowledge points will win some great prizes:   1st Prize: Xbox 360 with 250GB hard drive &...

    MelanieYarbrough6,345 pointsBadges:
  • Configuration of HP P4515tn on Iseries 525

    How do I set up a HP P4515tn on Iseries 525 as a network printer allowing AFP fonts and MICR lines to print correctly from Payroll check application?

    SFairchild15 pointsBadges:
  • SAVACTWAIT time on SAVLIB, etc.

    Hi, Has anyone experimented with the SAVACTWAIT time on the SAVLIB command. The default on 120 second seems rather long. What I am looking for is a realistic value based on fact such as that if an object does not become available after 5 second the change that it will become available after 120...

    JohnDavid5 pointsBadges:
  • Impact Analysis – None Answered till now

    Hi all, I have a question and submitted long back. But till now i didn't get any reponse. Task: If there is any change in the length of a field or a new field added into the existing file, we need to do some Impact Analysis which is time consuming.So i thought of developing a utility for that....

    Kumari0 pointsBadges:
  • Compiling a CL program

    I have a CL pgm in that i used the OVRDSPF command. Now i changed the display file. I'm sure i need to compile the RPG programs that are using the display file. Have a doubt if i need to compile the CL pgm or not?

    Kvrs8070 pointsBadges:
  • AS/400 FTP error

    User try to perform FTP from QGPL into User working library and hit error CPF8A83 but authority level already given *all

    Keterv65 pointsBadges:
  • AS/400 RPGLE Program – Verifying a user profile

    I have a client that wishes to use a valid program in an entry application.  How can I verify a user profile within an RPGLE program? 

    Farmboy6920 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