• Transfer of data from AS/400 DDS Described file to Excel spreadsheet

    I have a critical problem in AS/400 data fetch query in MS Excel (Petch SP2 loaded). I have created several Excel Sheets (in MS Office 2003) for fetching the data from AS400 using MS Office Query option under Data-->> Refresh Menu. Those excel sheets are using by so many different users on...

    Skm200520 pointsBadges:
  • Automatically refresh data from AS/400 DDS Described file to Excel spreadsheet

    Hi, Is there an easy way to automatically "refresh" the data in an excel spreadsheet from an AS/400 DDS Described Data file? I'd like the data to be collected whenever someone opens the spreadsheet. I can already get the data using a transfer request, but I have to start the request manually. I've...

    Gilly40023,730 pointsBadges:
  • Printing on AS/400

    I need to print multiple pages with the same page# coming in order. How can I do that?

    pwopen12240 pointsBadges:
  • Automated file transfer from AS/400 to PC (converted to text file)

    Dear all, I would like to know how to schedule batch job that automate file transfer from AS/400 to PC (converted to text file)? Thanks.

    ademah15 pointsBadges:
  • Access particular members in RPG

    Suppose I have a PF with 3 members. Is it possible to do READ/WRITE operation on particular 2 members?

    Amol1235 pointsBadges:
  • Multiple submission of a JOB

    Hi every one, Requirement 1.a : I have a CL program (ISC) which reads/process 10 Million records from an input file IF with some conditions and writes to a Output file OF1 with the help a RPG program R1. Now my requirement is to improve the performance of this read process by running/submitting...

    Sai4AS4001,420 pointsBadges:
  • Connect AS/400 with PC

    Please help if you can I want to connect my AS/400 520 with my PC. Please explain in a very simple tems how I can do it. What I have: 1. PC 2.AS/400 560. 3. Modem Ihave client access also. Can someone help me how to connect my pc with as/400. Thank you

    khan23275 pointsBadges:
  • declare file

    Are we still limited to one DCLF within a CLLE program?

    Jimnebe5 pointsBadges:
  • AS/400 backup with 3 LPARs in IBM i 7.1

    We built a new system with 3 LPARs with IBM i 7.1 . We setup the BRMS & using image catalog ,we created the virtual volume and scheduled the backups. Backups are performing perfect in virtual volumes also we can make a dupe tape using the physical media. My question is we have data of just 50...

    naresh1984365 pointsBadges:
  • Compile all dependent logical files at once

    I would like to convay my Thanks ReshmaG & Gilly400. My main requirement is I have a Physical file called PF1.On this there are 20-logical files are depended . I have changed some attributes on my PF1. Now I want to recompile all the Logical Files , which are depended on PF1. I am writing code...

    Khadar90 pointsBadges:
  • Free IT Book: Ubuntu Unleashed, 2011 Edition

    "Ubuntu Unleashed 2011 Edition presents advanced coverage of the popular Ubuntu distribution of Linux. Windows users, Mac users, and Linux enthusiasts have been increasingly turning to Ubuntu for a user-friendly and easy-to-use Linux distribution that remains useful to power users." To win this...

    MelanieYarbrough6,345 pointsBadges:
  • Use CVTDAT to convert date formats

    I have taken 2 parameters(like date and date types). A. If suppose date type is j, now i want to convert date to *MDY format B. If date type is M,now i want to convert date to *JUL format C, sending a Program message with the value of converted date. (With use of CVTDAT in cl coding.) Can anyone...

    Thara15 pointsBadges:
  • CPYFRMIMPF command not copying all records

    I need to copy records from work link to our database file, so I am using CPYFRMIMPF command in the following way: CPYFRMIMPF FROMSTMF(&LINK) TOFILE(SRINSOFT/EDI850WK) + MBROPT(*REPLACE) RCDDLM(*CRLF) + DTAFMT(*DLM) STRDLM('"') FLDDLM(',') + FROMRCD(2 *END) My worklink has 5 records but it...

    kennedy2802110 pointsBadges:
  • How to use CPYTOPCD on large files

    I have a file of over 3 gig. CPYTOPCD gives me an error message "Receiver value too small to hold result". Smaller files do work, any way to use CPYTOPCD on large files? Example: CPYTOPCD FROMFILE(BILLINGLIB/BILLN5) TOFLR(BILLS) + TODOC(&EXPDAT) REPLACE(*YES)

    Bum78bum780 pointsBadges:
  • CPYTOPCD creates wild character

    I have problem in CPYTOPCD command; I have one PF and one flat file.My RPG1 program dumps data first in PF then RPG2 program dump data with (~) saprater in Flat file. Then my CL program dump data from flat file to QDLS folder in TXT format. When I open the TXT folder in last row I see some wild...

    Nelson01250 pointsBadges:
  • Stop CPYTOPCD from creating additional record

    The CPYTOPCD command which copies iSeries files to the shared folders in QDLS puts an addtional record at the end of the PC document which I can only assume is the end-of-file delimiter. Is there any way to stop this record from being created?

    Luisreyes15 pointsBadges:
  • How to send a large PC doc from AS/400

    I can successfully copy data from a PF to a PC doc (via CPYTOPCD) and I can successfully e-mail the resultant PC DOC from the AS400 (via SNDDST) However, when I try to e-mail a large PC Doc (2 meg) I receive about 20 e-mails with *.DTF attachments, which are virtually unreadable. Any ideas?

    Riccardi0 pointsBadges:
  • STRPCCMD for path name with more than 123 characters

    I am trying to use the STRPCCMD command to open a PDF document from an iSeries 'green screen'. It all works okay until I try to open one with a large path name - the command can only handle 123 characters. Does anyone know a way to get around this? An API perhaps.

    Martin400 pointsBadges:
  • STRPCCMD – How to avoid black DOS screen popup

    I have a STRPCCMD command in my CL program to open an IFS folder which has the .CSV files. STRPCCMD PAUSE(*NO) PCCMD(''''start " " "\'+%trim(P@SYSNAME)+%xlate('/':'':DFTPATH)+'"'')' P@Sysname has the system name. I can see a popup DOS window but getting message the path not found. I am able to see...

    RamvishakRamesh2,505 pointsBadges:
  • CPF Errors

    Can any one please help me specify the most frequent CPF errors we get in AS400 environment, so that i will look into them..

    Sai4AS4001,420 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