• How do I convert a Unix text file from IFS to a DB file on AS400?

    I've got a flat text file that I want to convert from AS400 IFS to a Database file. First I want to convert to a flat file just to prove I can. The File is being Sent via FTP from Unix to AS400/IFS. Files have been sent in both unix txt format and MDOS format. Both files can be displayed on IFS no...

    slack4002,715 pointsBadges:
  • RPG COMPLIATION ERROR QCLRTVJA

    Hi I am finding error while compliing RPG/400 program error is as follows Message . . . . : Total parameters passed does not match number required. Program QRGRT attempted to call program QCLRTVJA with 47 parameters. Program QCLRTVJA expects a minimum of 48 and a maxmum of 50 can any body tell me...

    Bu60 pointsBadges:
  • CL – Copy To Import File

    I am using the CPYTOIMPF fromfile(PF) to STMF('dir\acp&txtfile') where &txtfile is &curdt *tcat &curtm.(system date and time) The stream file is created as acp&txtfile and what i want is acp120108100150.

    0 pointsBadges:
  • import data from excel 2007 to iseries

    how do you import data from excel 2007 to iseries

    JimC11285 pointsBadges:
  • AS/400 iSeries Submitted Job/Batch Record Lock issue

    I have looked at the other record lock questions/answers on this board but have been unable to find an answer to this problem. I am trying to capture a record lock error in a submitted program. The program is coded to capture the File Status as shown below. I have tested this same record locking...

    kevleemor605 pointsBadges:
  • I want to know about the object QDDSPEXT in AS/400

    Hi, I want the details of the object QDDSPEXT object in AS400. Like..what is this object? what it does? etc. Thanks, Gadang

    Gadang45 pointsBadges:
  • Migration

    I like to migrate a database which is in IBM OS/400 V5R3MO (Source)using iseries navigator to Oracle 10g.In the source database there are few stored procedures and few triggers which I like to migrate from source to oracle too. So I like to know is Oracle migration workbench will able to do so or...

    792755 pointsBadges:
  • DSPF programming

    Hi Please explain... When i open a screen in update mode how does the value get displayed in the screen and when updated it gets updated in the file.what is the general coding logic used in this case.

    0 pointsBadges:
  • HA and Single Signon(SSO).

    I have three LPAR's that I have setup for HA High Availablity. I also use SSO for user authentication. How do I setup SSO on the HA side so when I do a role swap I dont have to give them all passwords. I

    Chris65020 pointsBadges:
  • RPG/Asset

    Can a rpg program in asset be converted to rpg400 or ile?If so how

    0 pointsBadges:
  • Flat files

    I have a data in data strucure then after i need to create flat files in txt format. please suggest me how can i proceed.

    Askt265 pointsBadges:
  • Journalling

    Hi, Is there a utility within the o/s of iseries to translate the outputfile from the DSPJRN command? I need to get the changed transaction as a the original file.

    tjgm88995 pointsBadges:
  • OPNQRY

    Hi ALL, I am trying to pass to variable to the query select. ----------------------------------------------------------------------------------------------- OVRDBF FILE(filename) SHARE(*YES) OPNQRYF FILE((library/filename) QRYSLT('DATE + *EQ "&SATDYYMD"') /*the variable contains the date*/...

    Secskc25 pointsBadges:
  • FTP with RPG

    I have a file which should be ftped to another server.I have the ftp script.Can you suggest 1.code to automatically ftp the file to another server 2.also to send email alerts using snddst if ftp fails.

    0 pointsBadges:
  • RPG query

    Hi Martin, thanks for the previous query. Now i want to read the data of a DB file and display the data via display file. I have written following code for this: FPFRPG1 IF E K DISK FDSP1 CF E WORKSTN C READ REC C DOW *IN03=*OFF C EXFMT DSP C IF *IN01=*ON C ENDIF C READ REC C ENDDO C SETON LR After...

    Shaddy20 pointsBadges:
  • Copying an externally-described file to the IFS

    Hello, I need to copy several externally-described files to the IFS. What is the best way to copy an externally-described file on the iseries to the IFS on the same iseries? I am wanting the file on the IFS to be in either EBCDIC, ASCII, BINARY, or Comma Separated Variable format. I thought about...

    Panthers905 pointsBadges:
  • TXT file naming using CL

    Hi I hve created a txt file from a pf using cpytoimpf.The name of the txt file should have ccyymmddhhmmss in its name.I can retreive the date and time parameters from qdate and qtime.How do i name the txt file using a CL.

    0 pointsBadges:
  • Removing Save Files

    How can I have BRMS remove a save file after a number of days. I was told to change the media policy to be "Save file Retension type = 2 (Days)" and "Retain Save file = 1 (one day)" I have to manually delete the save files

    Johnd0155 pointsBadges:
  • Login timestamp of an AS/400 user into a subsystem

    I want to extract all the timestamps of an particular user when he logged into the sub-system. Is there any report or file which extracts this information i.e login timestamp of an user in AS/400. Kindly provide me the solution. Thanks, Gadang

    Gadang45 pointsBadges:
  • I need help Debugging a Cobol CICS ADABAS application

    Debugging a Cobol CICS ADABAS application. The App is very OLD and the COBOL Source is being updated to LE COBIII but the client (LOCAL GOV) doesn't want to use CA intertest and the ADABAS Version is out of support v7.1 as of 2006. We have limited experience here in ADABAS so any help would be...

    Cmcl9510 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