• Describe AS/400 command

    Hi, 'Describe select * from tablename'. We can use this statement from the DB2 command line , which results the complete definition of the table. Could you please tell me the same, which I can use from STRSQL, as describe is throwing an error. Thanks in advance

    HABBIE815 pointsBadges:
  • Monitoring IFS Directory in real time

    We have a requirement that people will FTP a file to IFS directory and we should monitor for arrival of the file and pick up the file and process in the application. Is there any way we can monitor IFS directory in real time for arrival of a new file. The file will be placed in IFS directory using...

    Babs312165 pointsBadges:
  • Massive bulk AS/400

    Is there a way to make a massive bulk for AS/400? For example: I have 5000 SKU's that we need to change price or cost. Right now, we do it manually. Is there a better and efficient way to do it?

    FELIXDIAZGARCIA25 pointsBadges:
  • VP and IT Manager

    Moved from 520 to 720. Do I need activation coder for Powerlock products AS/400 Audit and Network Security?

    csil06055 pointsBadges:
  • SQLRPGLE: How to evaluate field value in where condition

    Dear RPG users, Can we evaluate field value in where condition? I am looking for help in below query: select * from File_name where Date_Field + 2 days = Today_Date Date_field = 8P 0 Today_date = 8P 0 What I am looking for is the records which have passed 2 days as per today's date.

    rpgprogrammer200365 pointsBadges:
  • Life after AS/400: What skills will keep you marketable in today’s IT world?

    Hi Group, I have been working on AS/400 platform for the past 7 years. I would like to move to another technology. What skills will keep you marketable in today's IT world?

    mvrkrishna535 pointsBadges:
  • Entering a busy server

    How can I enter a busy server?

    suranjit5 pointsBadges:
  • Is iSeries FTP compatible?

    Is the iSeries secure FTP compatible with SFTP on other platforms

    RichK1151125 pointsBadges:
  • Embedded SQL using quotes to build field with wildcard

    How do I set up a cursor in RPGLE to select where a field is LIKE a character field using quotes with a wild card? The character field is a variable declared and built using a field in the program.  I have tried field LIKE :newfield with newfield setup as '%ch%' (single quotes). I tried field...

    cblanch25 pointsBadges:
  • How is the BPCS LX different from previous versions?

    How different is BPCS LX from BPCS V6 and Previous. It's written in RPGLE correct? Are the files essentially the same?

    willjim10 pointsBadges:
  • How to Monitor 100′s QZDASOINIT

    HiIs there a way to determine QZDASOINIT that has been logged in the system more that a day? I noticed our QZDASOINIT, QSQSRVR, QRWTSRVR connections are growing. How can this be monitored efficiently which seems that the job is running more thatn a day ago. Probably a run away process from...

    Jedlasquite360 pointsBadges:
  • Reading the part of the AS/400 string

    Hi, I have a Source line in QRpglesrc, There are N number of source line in my source physical file (Qrpglesrc). In that For Example I have a field, with Item = 'find the number of string' to be read. I want a logic to pick only the string within the quotes. it mean i need to pick the string within...

    srivijay1145 pointsBadges:
  • iSeries unattended backup

    I found a while back a CL program that can run in QCTL to ran an iSeries unattended backup, I tried it but the program hanged up. Have you seen any CL programs that can run an iSeries unattended backup?

    Dalverson5 pointsBadges:
  • What happen if ASP% increases in AS/400 LPAR?

    Does anyone know what would happen if ASP% increases in AS/400 LPAR?

    satyaki20 pointsBadges:
  • How to reduce ASP% in AS/400 system after it reaches the threshold?

    How to reduce ASP% in AS/400 system after it reaches the threshold?

    satyaki20 pointsBadges:
  • AS/400: How does CTLCHAR work

    Can anyone explain how CTLCHAR(*PRTCTL) work?

    yeepiyaya90 pointsBadges:
  • I’m new to the 400 and green screens

    What is the most efficient / quickest way to learn as/400 system admin/mgmt from the ground up? I'm looking for a logical path where each step builds on the previous. I have a windows background and understand the basic system admin tenets. I started with MC Press Primer and IBM Redbooks.

    sumguy15 pointsBadges:
  • How to print AFP Files with resides o n System i IFS

    afpmouse5 pointsBadges:
  • restoring a deleted folder in lotus notes

    Is there anyway to do this??

    Tmdc15 pointsBadges:
  • C4040-129-ENU IBM i 7.1 Administration

    Does anyone here knows where to get a leak or dump for this type of certification? Thanks

    excellentrandy1,160 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