• Scalar functions in GROUP BY

    Is there a reason why I cannot use a SCALAR function in a Group BY clause? I have a table with a column that is of type timestamp. I want to get a count of all dates for which there are multiple rows. So I devise a query of the sort SELECT COUNT(*), DAYS(TMSTP_COL) FROM MYTAB A GROUP BY...

    Sumithar0 pointsBadges:
  • WRKQRY Security Flaw / Users can Alter/ Replace Data in Production Files

    Can a user change or replace data, members, or the file itself (a prodcution file in a production lib) using WRKQRY...??? I have an auditor who believes in the "Define the Query" display, 2nd to last option ("Select output type and output form") you can specify 3 in the output type (3 = datafile...

    Gambitt7160 pointsBadges:
  • How to pop up login when using STRPCCMD

    How do you pop up loginwindow when using STRPCCMD?

    Bpulido35 pointsBadges:
  • Suppress FTP messages

    I've got a program that FTP's (put) files to another system. I always used the program in batch mode. Now I'm trying to ref the program interactively. But message 'Press ENTER to end terminal session.' requires user intervention. Does any know how I can suppress FTP messages while running in...

    Mtspudgun45 pointsBadges:
  • ftp spooled os/400(iseries) to pc format text or pdf

    i looking for solutions to help me the asking into the subject i looking for prices of solutions i looking freewere and i looking anything about the subject

    Luizmereb0 pointsBadges:
  • Error Reset Key

    I have a request that I have not done before. In my display file I use the IBM messages when there is an error. When the screen is displayed again it displays the field in question highlighted and then the user has to press the error reset key. Is there away so the user does not have to press the...

    RonKoontz1,780 pointsBadges:
  • Justify right in COBOL

    I have data where the format has been changed slightly by the carrier and now this change is causing my job to abend. The last page number of each file reads ex.'160 OF 160' however, the new format must read '160 of 160' which means that the last page number needs to justfied to the right to pos...

    Tm200930 pointsBadges:
  • STRQMQRY in batch on i5

    Can STRQMQRY be run in batch? I am getting error message: Global variable prompting is not allowed in batch mode. I am passing 2 parameters from a display screen

    TOASTY35 pointsBadges:
  • Purpose of binding directory in CGIDEV2?

    I'm a little stuck.  I'm trying to follow some guides regarding using CGIDEV2 on my iSeries V6R1 to do AJAX.  I've looked at easy400.net as well as some other references, but I keep having the same issue.  I keep getting error CPF980F 'Binding directory [dir] in library *libl not found.' Do I...

    Koohiisan5,045 pointsBadges:
  • Callin CLP with parameter

    Hi, I have a CL program which needs two Parametersa as a input, when i call a pgm with values, the value are not properly passed. It gives me decimal data error. For instance i gave values as Call pgm(clpgm) Parm('14' 'aaaaa') But it takes value as F1F44040404040. Hel me out soon. Thanks in advance...

    Keepsmilin5 pointsBadges:
  • Adopted Authority

    I am extemely new to RPG so I am looking for a simple code that uses adopted authority of SECOFR to an operator temporarily simply to enable users. I know that it can be done, but I would like to know the structure of it from and RPG standpoint. Thanks in advance.

    Rrnmla0 pointsBadges:
  • Does anyone on your team have an AS400 script handy to purge out oldest members of appended files?

    Basically, I'm hoping that somebody out there might already have a script or program that they use to purge out old members that get appended to static physical files on the MC400 (HNNE). I would be much obliged if you could send me the program or provide me a tip on where I can find a good script...

    GottaggedsoamnowIT0 pointsBadges:
  • Multiple message subfiles – one in a window

    My error message is not displaying in the window's message subfile. Both the main screen and the window have a message subfile defined. The RPG program defines the pgmq = '*'. Here's the dds R MSGSFL1 SFL SFLMSGRCD(24) @KEY1 SFLMSGKEY @PGMQ1 SFLPGMQ R MSGCTL1 SFLCTL(MSGSFL1) SFLDSP SFLDSPCTL SFLINZ...

    TabbyCat0 pointsBadges:
  • Stored Procedures in DB2/400

    Why do we need to write stored procedures on the AS/400 when we already have the application program and the dataabse both integrated into the system.

    Upen12290 pointsBadges:
  • HOW DO YOU DISPLAY A CONTROL RECORD, A SUBFILE, AND A WINDOW AT THE SAME TIME WITHOUT THE USER HAVING TO PRESS ENTER TWICE?

    WHEN A USER CHOOSES AN OPTION ON ONE SCREEN AND PRESSES ENTER, ANOTHER SCREEN WITH A CONTROL RECORD AND SUBFILE IS DISPLAYED. AS IT STANDS NOW, THE USER HAS TO PRESS ENTER AGAIN BEFORE A WINDOW IS DISPLAYED STATING, "ARE YOU SURE YOU WANT TO DELETE THIS RECORD?" IS IT POSSIBLE TO CODE A HARD RETURN...

    Volunteer0 pointsBadges:
  • iseries Client Access does not allow third parties applications to open the login screen to change password when it’s expired.

    Hello all: I will apreciate any help about this problem. I am a system administrator (mainly Active Directory) now dealing with this ISeries Client Access Problem in my 400 workstations. There are e few applications in the company, developed in FoxPro and Visual Basic, accesing the AS/400 (now a...

    Romanillo0 pointsBadges:
  • Convert Spooled file to Hexadecimal Values

    Is their a way that a spooled file be converted to hexadecimal values?

    Makoy050 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:
  • Checking if a job, which has a record lock, is doing anything before ending it

    We have some RPG code which will end a job if it has a record lock, but I would like to be sure that the job is not 'active' (not doing anything) before doing so. Is this sort of detail available via an API call ? Any examples would be gratefully received.

    REDHED0 pointsBadges:
  • Cross reference tool

    Hello, I'm currently working in an AS400 native RPG-environment, not ILE, and I want to create a cross reference for a part of the system(about 10 libraries). I'd like to create this by myself with the common commands on our system, I can do this thru DSPPGMREF and DSPBDR, DSPFD, DSPFFD, etc... But...

    Zappaz5 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.

Thanks! We'll email you when relevant content is added and updated.

Following