MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Need to correct data in a Table

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities
View previous topic :: View next topic  
Author Message
arunkumar_e
Beginner


Joined: 06 May 2004
Posts: 27
Topics: 16
Location: Bangalore
PostPosted: Sun May 15, 2005 5:13 am    Post subject: Need to correct data in a Table Reply with quote
Hi Friends,
I am have a problem here, due to some wrong utility a table in our database has some wrong values in some columns. I need to correct them. Here is the unloaded data from the table for explaination.This is
The wrong data

Original
[code:1:188e9bf746]----+----1----+----2----+----3----+----4----+----5----+----6----+----7--

_________________
Arun
"Genius is one percent inspiration and ninety-nine percent perspiration." -- Thomas A. Edison
Back to top
View user's profile Send private message Send e-mail Yahoo Messenger
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
PostPosted: Sun May 15, 2005 5:58 am    Post subject: Reply with quote
arunkumar_e,

Can you post the table layout? I want the column names that needs to be updated and also the column names to look for.

I think you can run a SQL Query in spufi with replace function.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
arunkumar_e
Beginner


Joined: 06 May 2004
Posts: 27
Topics: 16
Location: Bangalore
PostPosted: Sun May 15, 2005 10:41 pm    Post subject: Reply with quote
Hi Kolusu,
please find the table layout
Code:

SRLZD_PROD_ID                          POSITION(       1         )
 INTEGER                       ,                                   
 PROD_OPT_VER_NUM                       POSITION(       5         )
 INTEGER                       ,                                   
 BASE_MACH_OPT_CD                       POSITION(       9         )
 CHAR(                     12) ,                                   
 PIN_NUM                                POSITION(      21         )
 CHAR(                     17) ,                                   
 BASE_MACH_CD                           POSITION(      38         )
 CHAR(                      8)                                     
      NULLIF(      46)='?',                                       
 OPT_CD                                 POSITION(      47         )
 CHAR(                      4)                                     
      NULLIF(      51)='?',                                       
 OPT_QTY                                POSITION(      52         )
 INTEGER                                                           
      NULLIF(      56)='?',                                         
 FROM_DT                                POSITION(      57         )
 DATE EXTERNAL(            10) ,                                   
 THRU_DT                                POSITION(      67         )
 DATE EXTERNAL(            10) ,                                   
 FROM_DT_INTGR                          POSITION(      77         )
 INTEGER                       ,                                   
 THRU_DT_INTGR                          POSITION(      81         )
 INTEGER                       ,                                   
 CURR_REC_IND                           POSITION(      85         )
 SMALLINT                      ,                                   
 DWLOAD_TS                              POSITION(      87         )
 TIMESTAMP EXTERNAL(       26) ,                                   
 DWOS_ID                                POSITION(     113         )
 SMALLINT                                                           

Also there are aound millions of records which needs to be updated, so is it feasible to run thru SPUFI.
_________________
Arun
"Genius is one percent inspiration and ninety-nine percent perspiration." -- Thomas A. Edison
Back to top
View user's profile Send private message Send e-mail Yahoo Messenger
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group