sandeep gubba


{ City } hyderabad
< Country > india
* Profession * developer as400
User No # 105093
Total Questions Posted # 4
Total Answers Posted # 3

Total Answers Posted for My Questions # 3
Total Views for My Questions # 11487

Users Marked my Answers as Correct # 3
Users Marked my Answers as Wrong # 1
Questions / { sandeep gubba }
Questions Answers Category Views Company eMail

How to get only unique records from a file which contains duplicate data using CPYF command ? Example : FILEA has duplicate records and FILEB is a UNIQUE defined.... and I want to get the data from FILEA to FILEB by eliminating all the duplicate records...

1 RPG400 4010

How do you proceed in case your active AS400 session has got disconnected suddenly, how can you get back to your session ? Is it possible??

1 RPG400 3178

In case if I want to know whether a record exists in a file, which one do you prefer CHAIN or a SETLL and why ?

1 RPG400 3018

How to create a login screen using a command instead of display file.... intention is to get a password field on a command..... how do you achieve this...

RPG400 1281




Answers / { sandeep gubba }

Question { 4010 }

How to get only unique records from a file which contains duplicate data using CPYF command ?

Example : FILEA has duplicate records and FILEB is a UNIQUE defined.... and I want to get the data from FILEA to FILEB by eliminating all the duplicate records...


Answer

There is an option in CPYF command which says " Error Allowed", making that as *NOMAX will trigger IGNORE option instead of CANCEL in CPYF processing; whenever there is duplicate record encountered.

Is This Answer Correct ?    0 Yes 1 No

Question { 3178 }

How do you proceed in case your active AS400 session has got disconnected suddenly, how can you get back to your session ? Is it possible??


Answer

Go to WRKACTJOB and hit F14 to include all the disconnected jobs, if that job is still active it will be visible there.

Note: Job active time after disconnection depends on SYSVAL

Is This Answer Correct ?    1 Yes 0 No


Question { 3018 }

In case if I want to know whether a record exists in a file, which one do you prefer CHAIN or a SETLL and why ?


Answer

If you just want to know whether the record exists or not, SETLL is best as it just points to the record and doesn't store the data in to fields ( time saving ) where as CHAIN will read and stores the data in to fields ( time consuming ).

Is This Answer Correct ?    2 Yes 0 No