Answer / vivek dwivedi

You can add field in file using sql. Alter table as below..

ALTER TABLE File_Name ADD COLUMN Field_Name SMALLINT NOT NULL DEFAULT 0

Answer / prabhu

Yes, After adding the key field try CHGPF.

I believe adding key fields and CHGPF will not change the record identifier so here no need to recompile your programs.

all i need to know about cmpseqdat parameter in cmppfm, how it works and can we retrieve line sequence and date from the output?

0 Answers  

---

what is *iso date format?

0 Answers   IBM,

---

What is the purpose of STRCMTCTL command?

1 Answers  

---

how do you specify page overflow indicator for printer files in rpg?

1 Answers   IBM,

---

it is possible declare variable values as variable using cl ? any cl command is there to declare values as variable

2 Answers  

---

what is multijoin logical file? what are the keywords available in joinlogical file? what are the mandatary keywords for joinlogical file? explai the keywords?

2 Answers   HCL,

---

which of the following operations does not zero the field flda defined as 4,0?

0 Answers   IBM,

---

can you explain the difference between spacea,spaceb,skipa and skipb. I'm new to learning about as400 and printer files. can any one give me an example using source code showing the difference that occurs between using these 4 keywords. A-Physical file PF004 source UNIQUE R RR STUNAM 10 ROLLNU 5 0 MARKS 3 0 SEX 6 K ROLLNU 4 records present in PF004 are STUNAM ROLLNU MARKS SEX KAVYA 12,344 55 FEMALE MADHAVAN 14,579 60 MALE RAMYA 14,785 70 FEMALE KRISHNAN 14,988 72 MALE B-Printer File PRINT1 source A R HEADER A 10 3'STUNAM' A 10 20'ROLLNU' A 10 30'MARKS' A 10 40'SEX' A R DETAIL A SPACEB(1) A STUNAM 10 3 A ROLLNU 5 0 20 A MARKS 3 0 30 A SEX 6 40 A R FOOTER A SPACEB(1) A 20'END OF REPORT' C-RPG/400 Program PRTTPG source FPF004 I F E DISK FPRINT1 O E PRINTER C WRITE HEADER C READ PF004 60 C *IN60 DOWEQ *OFF C WRITE DETAIL C READ PF004 60 C ENDDO C WRITE FOOTER C SETON LR D-spooled file result set Display Spooled File File . . . . . : PRINT1 Page/Line 1/10 Control . . . . . Columns 1 - 130 Find . . . . . . *...+....1....+....2....+....3....+....4....+....5....+.... 6....+....7....+....8....+....9....+....0....+....1....+.... 2....+....3 STUNAM ROLLNU MARKS SEX KAVYA 12344 055 FEMALE MADHAVAN 14579 060 MALE RAMYA 14785 070 FEMALE KRISHNAN 14988 072 MALE END OF REPORT Bottom F3=Exit F12=Cancel F19=Left F20=Right F24=More keys I have changed from SPACEB to SPACEA now in my printer file source E-Changed PRINT1 Source A R HEADER A 10 3'STUNAM' A 10 20'ROLLNU' A 10 30'MARKS' A 10 40'SEX' A R DETAIL A SPACEA(1) A STUNAM 10 3 A ROLLNU 5 0 20 A MARKS 3 0 30 A SEX 6 40 A R FOOTER A SPACEA(1) A 20'END OF REPORT' F-Spooled file Result Set after keyword change Display Spooled File File . . . . . : PRINT1 Page/Line 1/10 Control . . . . . Columns 1 - 130 Find . . . . . . *...+....1....+....2....+....3....+....4....+....5....+.... 6....+....7....+....8....+....9....+....0....+....1....+.... 2....+....3 KAVYAM 12344U 055KS FEMALE MADHAVAN 14579 060 MALE RAMYA 14785 070 FEMALE KRISHNAN 14988 072 MALE END OF REPORT Bottom F3=Exit F12=Cancel F19=Left F20=Right F24=More keys Overprinting not displayed.

0 Answers   Tieto,

---

what are the parameters required for calling ls & get command(SFTP COMMANDS) from cl progtram.... I want to transfer files(using GET COMMAND) that are retrieved by LS command ...FROM 1 SYSTEM TO ANOTHER... STEP 1:LS-list all files...from remote system STEP 2:GET-actually transfer the files(listed in step 1) from remote system to local system & get stored in some Physical file....Plz reply in detail...Thanx

1 Answers   EDS,

---

Can level check error occur if we do chgpf?

0 Answers  

---

What is the purpose of the following FORDHDR1 CF E WORKSTN $2SFN SFILE FMT2

1 Answers  

---

what is *inzsr used for?

1 Answers   IBM,

---