RPG/400

Grouping the records in RPG

How to I group the records in the database based on one particular field?? When i try using a group by clause in the embedded SQL, it give me a 'SQL precompile failed' error. How do I handle this?? And i have to display the employee records grouped by their locations... how can this be done??

diff. between two date

Hello guys, I wanna do a one pgm which is find out date diff. between two date in rpg /400. Actually i did this in rpgiv...but now i want to do it in rpg/400. can somebody provide me a exact logic behind this.. Thanx in advance.....

iSeries IBM

What would be the output of the variable result? D RESULT S 5S O INZ(00011) C EVAL RESULT = %TRIM(RESULT) Please give me the correct answer for this A.0001 b.compile time error c.11 d.Runtime error

Password Expiry

Hi,if i want to change my password after 15 days ..then plz gv me a coding for that in rpgiv....

About Program Described input files

hi all, Can anyone explain me what is meant by Program described input files and what is the use of this files compared to Externally Described files and please give one complete example program of using Program described files with I SPECS and explain me about Record identification codes

Link for download subfile programming in RPG ILE

HI , i am working on ile rpg , & i just started to work on subfile programming . i want to lean subfile programming because i didn't work on it yet. i dont have any source like any document . i have downloded a pdf file for subfile programming its good but it is only For RPG not for ile. does it...

How to get job attributes for a different job that was submitted and is running on the system

I have a query. How to get job attributes for a different job that was submitted in batch and is running on the system ? Right now i am able to use RTVJOBA and get the job name of the Job that started. But i also have another job submitted in batch with a different job number. Could anyone help...

*Loval Setll positioning to last record

I have a very simple program which is reading records from a work file for writing to a subfile but the *Loval Setll is positioning to the last record in the file instead of the first. When I do my subsequent READ, I am getting %EOF. I have checked %ERROR (0) and %STATUS (0) after the SetLL but...

rpg/400

Hi, Im fresher for as/400.Actually im facing the interview on as/400.in one of the interview interviewer asked one question like what is rpg/400 and cl/400 life cycle.But i can not able to tell answer for this question.can any body tell me what is rpg and cl life cycle in real time cenario?

Convert a Cobol/400 File Spec to a RPG/400 DDS

How can easily convert a Cobol/400 File Spec to a RPG/400 DDS Spec?

SCAN/XLATE/CAT

Hi, Good evening every body.Can you tell me what is the difference between SCAN AND XLATE AND CAT ?in real time answers.

SFLNXTCHG

Hi, What is the meaning of SFLNXTCHG?Where we can use this,and when we can use?what is the main perpose

SETLL

Hi, Im venkat.Ive small question.Can any body clarify this question please? is there any equelent commands to SETLL*LOVAL in cl?

%SST

Hi, Im traying to get out put of this below mention simple logic code.But im geting out of different.(im trying with my laptop trhough my company server. DCL &FIELD1 *CHAR 10 VALUE('TCS AS/400') DCL &FIELD2 *CHAR 10 CHGVAR(%SST(&FIELD2 1 10))(%SST(&FIELD1 10 1) Can you tell me the...

AS/400

Hi, Can you tell me how to debug the program with RPG/400.(through STRISDB).Means can you tell me clearly stp by step.

version

HI, This is ibmi5 fresher team.Please tell me what is difference between cl and rpg

RPG/400 ,CL/400 lifecycle

Hi, Very good morning my friends.Can any body tell me rpg/400 and cl/400 life cycle.please

simple coding with load any array

Hi, Please tell me how to read the records from a file with load an array of size with error conditions

Pass parameter RPG 400

Hi, is there any solution to pass numeric parameter to the rpg program from the command line

to read a record RPG 400

Hi, Im learning AS/400 technology.Now im in RPG/400.Actuall my doubt is if suppose i used SETGT with *HIVAL,Which opcode is used to read a record (I think readp.But i have litle bit doubt).please clarify my doubt. ...