• Auto increment in AS/400

    How do I have an auto increment column in a physical file?

    adriandjsanchez10 pointsBadges:
  • Authority to view a user profile

    I want to grant authority to our technical support personnel to see a user profile. How can I do this without giving them *ALLOBJ authority, or granting them object authority against each individual user profile?

    KDCKnowlton5 pointsBadges:
  • AS/400 Keyboard Shortcuts

    Can someone help me about the keyboard shortcuts in AS400? Previously, I was able to used some shortcuts like copy, paste and cut but now that I was transferred to other cubicle, keyboard shortcuts are not defined. Hope someone can help me. Thanks

    Radycal45 pointsBadges:
  • What’s the performance of CPYFRMQRYF and OPNQRYF?

    I would want to know the performance of this 2 commands OPNQRYF and CPYFRMQRYF. I will join 2 files and have some selection criteria. File A has 3000000 record and 1500000 number of deleted record in DSPFD. After that it execute CPYFRMQRYF command. So now the problem is this program take longer...

    yeepiyaya125 pointsBadges:
  • Convert IBM SCRIPT to AFP format

    How do you convert IBM SCRIPT to AFP format for printing purposes?

    AV228645 pointsBadges:
  • VBA code to transfer data from iSeries to Excel

    Hi everyone, could someone provide VBA code to automate the Transfer of data from the iSeries into an Excel 2003 Spreadsheet. Currently we have to manually use the iSeries Excel Add-In. All fields are left default except the Library/File field where we enter PRODDTA/F56EXT. The data then transfers...

    Mblair.au25 pointsBadges:
  • sFTP to AS/400

    Hi, We are currently FTP'ing a file to an AS/400 system and then use QUOTE command to invoke their program. We are now moving to sFTP and would like to know if there is an alternative for QUOTE command in sFTP to trigger their program. Many thanks!!

    psrini19865 pointsBadges:
  • Change program date in qsys

    What makes the change date change in lib qsys for programs?

    woodbine5 pointsBadges:
  • Netserver expert anyone?

    I'm trying to access windows folders on a server and I get this error: 'Error exchanging security information... Error Class:1, Code: 5 = Access denied. My passwords do match and I previously accesses these folders. The problem started when I changed my password.

    yaazhisai160 pointsBadges:
  • Setup SAVRST for secure connection between LPARs

    Is it possible to setup SAVRST to use a secure connection between LPAR's? I'm using V7R1.

    NotSoIBMguru15 pointsBadges:
  • AS/400: How to start a new session using menu option

    I have created a menu using STRSDA. I wanted to add a option to start a new session in IBM iSeries access. (Usually I open a new session by selecting file -> Run the same.) Is there any related command is available in AS/400 so that I minimize work in opening new session each and every time....

    RPOOJA110 pointsBadges:
  • AS/400 file downloaded to Windows Server

    When downloading AS/400 data files to MS SQL server files, will the storage size be about the same on server as it was on AS/400? We have a 102 gb AS/400 database library we want to download to SQL Server.

    jm101515 pointsBadges:
  • WhatsUp Gold to monitor iSeries

    Can Whatsup Gold Application monitor iSeries in a more detailed and deep down monitoring such as susbsystem, jobs, job count, logs, etc.? Thank you

    Jedlasquite360 pointsBadges:
  • SQL 9010 Error when using RUNSQLSTM

    I have a CL program having the following RUNSQLSTM RUNSQLSTM  SRCFILE(AMBDEV/MSRCAMB) SRCMBR(AMBJARRVK)            COMMIT(*NONE)                            AMBJARRVK is a SQL member file in MSRCAMB source file having this SQL statment DELETE FROM GDPF WHERE...

    MaldaTabbah5 pointsBadges:
  • Copy file from IFS with CPYFRMSTMF command

    Copying a file with command CPYFRMSTMF Hebrew characters are copied incorrectly. When I copy the same file from folders with the command CPYFRMPCD All the characters are copied correctly. I want to work in an area IFS directly, not from folders (QDLS).

    erezpe10 pointsBadges:
  • AS/400: Use PUSH Button for a numeric field

    How to use a push button with numeric field? I mean I have a numeric field of six length which is showing 456789 (for Ex). When I click this value like a button it need to show another window. Thanks in advance. Surey

    Sureyz2,525 pointsBadges:
  • The IT Blog Top 10: Oct. 29, 2009

    10. Choosing a block size when creating VMFS datastores Eric Siebert has written a guide on how to choose the right size for VMFS datastores. 9. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees explains a helpful VBScript trick. 8. Using VRDP to view...

    ITKE355,060 pointsBadges:
  • Overlay Positions vary

    Hi, I have used Overlay concept to populate data to the word document. In my development server, its worked fine. We got the report output with data fitted to the correct position. But when we promote this objects to client server, the data is not aligned properly. How to fix this issue?

    22917560 pointsBadges:
  • FTP of a file has stopped working. File not growing like it should

    We have a file that we FTP on a monthly basis to our I5. It is a positionally formatted file. In the past, we have had no problem with this, but late last year it stopped working. When we try to FTP the full file it gives us an FTP error of 426. The interesting thing is if I split the file in half...

    jokerb1925 pointsBadges:
  • FTP from iSeries to PC server

    I've written a script to ftp text file to PC server. Tried on command line, no issue. But put that in CL program, I got the following error message. My INPUT file is as follow “ USER username userpwd NAMEFMT 1 ASCII PROMPT CD /ftp LCD /FTP/outbox PUT datafile.txt CLOSE QUIT “ Log file shows the...

    ChrisLYL35 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