Answer / rakesh

Hey Raju,
Actual Significance is *MAP will Map the Field
from From File to To File where ever it will find mapping
without error where as *drop will Drop off the Field where
ever it is not matching .

For Example : we want to copy 12 fields file data to
another File having 12 Fields plus 3 more addon , we have
to use the *Map and *Drop to add the data of 12 match
fields and drop the remaining.

Answer / nora alexander

It's for Record format field mapping - if you use *NOCHK it
just copies the data without regard to field type or size,
which is a bad idea.
*MAP
Fields with the same name in the from-file and to-file
record formats are copied, and any fields in the to-file
that do not exist in the from-file format are set to the
default value specified on the DFT keyword for the data
description specification (DDS) of the to-file or zero for
numeric fields, blanks for character fields, current
date/time for date/time fields, or null value for null-
capable fields.
If *MAP is specified, *DROP can also be specified. Mapped
fields may have different starting positions in the from-
file and to-file record formats.

If *MAP is specified and a valid conversion is defined
between the from-file field CCSID and the to-file field
CCSID, the character data is converted to the to-file field
CCSID. However, if either the from-file field CCSID or the
to-file field CCSID is 65535, the character data is not
converted.

*MAP allows for the conversion of date/time data and the
copying of null values.

*DROP
This value must be specified for field-level mapping if any
of the field names in the from-file record format do not
exist in the to-file format. If *DROP is specified, *MAP
can also be specified. When *DROP is specified, all the
field names that exist in both record formats must have the
same attributes and relative positions in the from-file and
to-file record formats, or *MAP must also be specified.
Null values are copied.

Answer / venki

i think it does not need that mush of cinfusion *map is for
just it checks he record format of to files *drop is also
same but it ignores the fild attribute it cheks for wheher
the teo data types are comptable or not

i'm working on progA , in that program i want to see the userids of the users who work on this program?

10 Answers   Four soft,

---

can any body correct the following code? Following a procedure which returns the maximum of two numbers.Correct the following code. P GETMAX B D GETMAX PI D NUM1 35 0 D NUM2 45 0 C IF NUM1 > NUM2 C RETURN NUM1 C ELSE C RETURN NUM2 C ENDIF P GETMAX E

1 Answers  

---

This is my Physical file 'EMPS' existing in library "TAMIL1" and its record format is 'EMPRCD" a)its source is R EMPRCD ENO 4 0 ENAME 10 EADD 10 b)The records present in EMPS are as follows ENO ENAME EADD 0001 tamil coimbatore 0002 kumar bangalore 0003 sunder bangalore 0004 arunkumar chennai 0005 pandi hyderabad 0006 santhosh hyderabad 0007 sasi salem 0008 kalai chennai 0009 suresh hyderabad 0010 vijay bangalore 0011 Arul chennai 0012 velu chennai 0013 khan bangalore 0014 praba chennai 0015 praba.p coimbatore 0016 anand ooty 0017 raja erode 0018 sankar erode 0019 vadivel namakkal 0020 anbu chennai 0021 Ajith mumabi c)now i want to select the 'ENAME' field records starting with 'S' for that i have created a RPG program its source code is PGM DCLF FILE(TAMIL1/EMPS) DCL VAR(&MYENO) TYPE(*CHAR) LEN(4) OVRDBF FILE(EMPS) SHARE(*YES) OPNQRYF FILE((TAMIL1/EMPS)) QRYSLT('ENAME *EQ %WLDCRD("S *")') READ: RCVF RCDFMT(EMPRCD) MONMSG MSGID(CPF0864) EXEC(GOTO CMDLBL(END)) CHGVAR VAR(&MYENO) VALUE(&ENO) SNDUSRMSG MSG(&MYENO) SNDUSRMSG MSG(&ENAME) SNDUSRMSG MSG(&EADD) GOTO READ END: CLOF OPNID(EMPS) DLTOVR FILE(EMPS) ENDPGM Is this coding correct sir,the program gets compiled,and if i call it it says query running but records are not displayed.please help me out

4 Answers   Virtusa,

---

How can we read a particular record from the database file which is not having DDS (Flat File). For example, there are 100 records in the flat file. How can we retrive 15th record in RPG/400 program (Without using CL)

6 Answers   CTS, IBM,

---

can you debug ile rpg program using isdb?

0 Answers   IBM,

---

How to identify the object has compiled with the debug view as *source without using STRDBG?

6 Answers  

---

How can you determine the number of characters in a variable?

3 Answers  

---

Hi Viewers can any body explain me how to update and ahange the already existed data in physical file using subfile ? please explain me with the code if possible?

1 Answers  

---

Anybody can explain the difference between SFLCLR & SFLINZ?

7 Answers  

---

in which journalling which attributes are necessary??/

1 Answers   CTS,

---

Suppose in CL we reach at end of file and again we have to reach from 1 record

3 Answers   TCS,

---

1.Write code to read the records from a file and load an array of size 99? Make sure that you take care of all the error conditions?

2 Answers   HSBC,

---