i have a table wich consists of 10 colums , and i have to update only one column init , cani know how to do this using cursors
Cursor is used where there is in need of selection of multiple rows. since ur requirement is only one row y r u trying to do with cursor???? Try the simplest way my frnd
I dunno how this topic is in this question about JCL. how ever his question was to how to update using a curson when he have 10 columns in a table.
He just mentioned that he only want to update one column, not just one row. Any way, if you want to update using cursors, then declare a curson with update option. Then use the update sql with current option
DFSORT and Syncsort have similarities and differences. If you or anyone else on this board would like some documents prepared by the DFSORT Team that describe what we see as the advantages of DFSORT over Syncsort, as well as considersations for migrating from Syncsort to DFSORT, send me an e-mail offline (email@example.com). Please put "DFSORT" somewhere in your Subject line to catch my attention.