• User Id in Pgm DS in case of Scheduled Batch Job.

    Hi All. An user's id can be retrieved inside the pgm from system Data Structure which contains the User Id invoking the pgm. Normally this is passed to a file field before writing/updating the file. If the file is updated by a Batch pgm then the Id of user submitting the job goes to the system DS...

    Dipendra0 pointsBadges:
  • SQL Statement

    Column qualifier or table SLGRREP undefined. update yyyyy/slf1rep set F1_CAP_AT_END = 'C' where (xxxxx/slgrrep.grbss || ' ' || xxxxx/slgrrep.grggr) = in (select yyyyy/slf1rep.f1BSS || ' ' || yyyyy/slf1rep.F1GGR from xxxxx/slgrrep, yyyyy/slf1rep, xxxxx/slsyrep where SLF1REP.F1_END_DATE >...

    Bandit100 pointsBadges:
  • Triggers

    Does the AS/400 have a cross-reference file or files that give the same kind of information about triggers as QADBFDEP and QADBFCST do for dependent files and constraints? If so, what is/are they called? Thanks

    Xixones0 pointsBadges:
  • Finding a program statement number in the Program Status Data Structure.

    According to the ILE RPG Reference manual, positions 21 - 28 of the SDS should contain the statement or listing number at the time of the dump. Whenever I deliberately invoke the dump (via *PSSR) this value is zero. I have checked it in debug mode before and after the actual DUMP and the value is...

    mygoodname0 pointsBadges:
  • Telnet on iSeries

    Is it possible to have multiple telnet ports listening at the same time for telnet connections on the iSeries? (i.e., the normal port 23, plus one or two additional ports to split traffic, etc.). If so, do you have to configure / start multiple telnet servers on the iSeries (one for each specified...

    Reltermann0 pointsBadges:
  • Delect members by age using CL

    I download a bank file once a day. I want to keep the last two weeks of files stored in members of file ARCHIVE. Typical member names might be 20041109, etc. How can I purge the members that are more than 15 days old using CL? Is there a way to convert a *CHAR variable into a *DEC variable? Is...

    DavidG19630 pointsBadges:
  • Do API’s ‘QSYRUPWD’ and ‘QSYSUPWD’ work with QSECOFR user profile?

    Our password maintenance programs, use API's 'QSYRUPWD' and 'QSYSUPWD'. They work a traet with standard profiles, but don't seem to work for user profile QSECOFR. (we also have a copy of this profile called WSECOFR and this doesn't work either). Is there a built-in 'block' on the QSECOFR profile...

    Rpm40 pointsBadges:
  • Using Query/400 to create SQL-style GROUP BY

    Greetings and salutations, I'm trying to put together a query for one of my users to track sales numbers and it is starting to give me a headache. I've put together a query using Query/400 with a break at each invoice to sum the dollar amount for each one. The issue is that on many of our invoices,...

    Kyoojin0 pointsBadges:
  • 9117-MMA Performance

    WE have recently installed a 9117 MMA p570 which has 11 partitions, 3 of which are iSeries. All disk is on DS6800. Our performance has gone backwards on the Production iSeries partition, runtimes blown out excessively though I have seen some batch jobs running faster. We  have heard thru the...

    Tonks20 pointsBadges:
  • Want to know the OS Installation date & Last OS Upgrade date..?

    How can i trace the date when OS installed on my iSeries Server & When it is Last upgraded to newer version....?

    Harish.kuolkhere190 pointsBadges:
  • AS/400 QUERY ; how can I calculate the month and year of 3 months ago in define result fields?

    I am using an AS/400 query in which I need the month and year of 3 months ago based on today's date. To get today's date I use current(date) but I need to know the month/year 3 month ago and the month/year of previous month undepending which day of the current month it is. Is that possible? I...

    Chrisjegoderie30 pointsBadges:
  • Damaged Object unable to remove

    Hi anyone else come across this problem. I have a damaged object which is causing the full system save backup to skip whe whole library with the damaged object in. The library is a user one with a object type of DSPF  Normaly a delete and create a damaged object fixes all, but I can not...

    Mell0rman270 pointsBadges:
  • System Upgrade Path Software and Hardware

    We have a 170 box running V5R1.  Which upgrade path is doable and or the best. Upgrade 170 with V5R1 to 270 running V5R2 Upgrade 170 with V5R1 to 270 running V5R4 Upgrade 170 with V5R1 to 525 LPAR running V5R4     

    2839005 pointsBadges:
  • Access paths

    What are Access paths/Recovery access paths in AS/400? Thanks in Advance.

    qmaster1,675 pointsBadges:
  • We are runing V5R1 OS400, how do I write to CSV file

    We are trying to write a program that will take the output of a report, & put it on a CSV file. This file will the be sent via email to user(s). Please provide with steps to accomplish this including foldersetup, etc.

    Proy5 pointsBadges:
  • AS400 Disk space

    AS400 Disk space I’ve just inherited the responsibility for a couple of old AS400 (model 510, OS V4R5) which are out of support and although I spent many years supporting AS400 I’ve not touched them in the last 6 years and I have a little problem with them. The problem is the system ASP is...

    Dazzaleeuk55 pointsBadges:
  • JAVA and i5

    Hi All, I want to know what is the best configuration of i5 system to run JAVA application such as M3 ERP.

    CAZAWI85 pointsBadges:
  • Use of Function Keys on OS/400 Command line

    Can I set up a function key to enable a command to be run from the AS400 command line

    Scram5 pointsBadges:
  • Launching AS/400-iSeries with DB2 and RPG

    I am new in AS400/ iSerices. Actually I am a software developer C#.Net in my office we have database on AS400/iSerices DB2. I usually use Sql. I want to install or launch AS400/iSerices on my home PC. Can anybody help me how launch AS400/ iSerices on my personal PC. Thanks in advance. Mr.SEA...

    Mr. SEA130 pointsBadges:
  • QAOSSS14B damaged object

    During a recent full save prior to an OS upgrade, I noticed the object QAOSSS14B in QUSRSYS is damaged. Recovery is to delete and restore from backup. Problem, couldn't find it on a backup. Any other recovery? Thanks in advance. Sam Kentopian

    kentopian110420 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