|
View previous topic :: View next topic
|
| Author |
Message |
Jiya_su
New User
Joined: 11 Dec 2006
Posts: 7
Location: hyderabad
|
|
|
|
hi friends
I want to update 2- 3 record of a table will u do by QMF or will write cobol-db2 program? |
|
| Back to top |
|
 |
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
|
|
Hi Jiya,
U can update records by QMF/SPUFi or cobol ,db2 PGm & easytrieve.
But u should follow ur shop process to do this. |
|
| Back to top |
|
|
priyesh.agrawal
Senior Member
Joined: 28 Mar 2005
Posts: 1448
Location: Chicago, IL
|
|
|
|
| Quote: |
| will u do by QMF or will write cobol-db2 program? |
Thru QMF/SPUFI only, why to write a whole program just for 2-3 records.
Even best option would be to use ur shop available utility which allows you to directly interact with tables and update records. Such as Platinum tool in my case. |
|
| Back to top |
|
|
Jiya_su
New User
Joined: 11 Dec 2006
Posts: 7
Location: hyderabad
|
|
|
|
HI
QMF/SPUFY is the simplest & easiest method but how to show output to TL Or Client |
|
| Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
|
|
Hi Jiya,
After ur update query Just give select query to fetch the rows which u have updated & then show the spufi o/p data set to TL /Client |
|
| Back to top |
|
|
mainframelover
New User
Joined: 27 Dec 2006
Posts: 6
Location: Bangalore
|
|
|
|
| or u can use fileaid for DB2 option.. |
|
| Back to top |
|
|
Jiya_su
New User
Joined: 11 Dec 2006
Posts: 7
Location: hyderabad
|
|
|
|
| THANKS TO ALL.......... |
|
| Back to top |
|
|
humpty
Warnings : 1
New User
Joined: 01 May 2005
Posts: 23
|
|
|
|
Simply use the CATALOG MANAGER tool to insert/update/delete records from the table. There can be nothing simpler than this.
cheers!! |
|
| Back to top |
|
|
|
|
