Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
not updating to IDMS database

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IDMS/ADSO
View previous topic :: :: View next topic  
Author Message
kcs4u2004
Warnings : 1

New User


Joined: 21 Apr 2008
Posts: 56
Location: Chennai

PostPosted: Wed Jun 24, 2009 8:10 pm    Post subject: not updating to IDMS database
Reply with quote

my cobol pgm is getting data from db2 database,and uploaded to IDMS database.I am doing analysis on one field which should be Y or N, the file which we are getting from db2 that file contains always Y or N for that field,when it is updated to IDMS DB,for some records that field is not getting any data(i.e its blank),but for all other records it is updating correctly(either Y/N),can somebody suggest what may be the problem,why IDMS databse is not able to pick up that value.
even I checked in online,for those records in online screen that field is getting populated,but the same value is not in the db.

can anybody suggest what might have gone wrong..
Back to top
View user's profile Send private message

sudharsan.soundararajan
Warnings : 1

New User


Joined: 15 Oct 2008
Posts: 17
Location: Chennai

PostPosted: Thu Jun 25, 2009 3:40 pm    Post subject:
Reply with quote

Hi Krish,

i have few question on your problem

Quote:
it is updated to IDMS DB,for some records that field is not getting any data(i.e its blank),


are you trying to obtain a record based on the CALC key and upadting a particular field as Y or N based on the input file?

Quote:
even I checked in online,for those records in online screen that field is getting populated,but the same value is not in the db


you mean to say that in online it is showing as Y or N(online screen gets the data from IDMS data base ?) , but you are not able to see the value in the DB for the same record?

Regard's
Sudharsan
Back to top
View user's profile Send private message
kcs4u2004
Warnings : 1

New User


Joined: 21 Apr 2008
Posts: 56
Location: Chennai

PostPosted: Thu Jun 25, 2009 5:10 pm    Post subject: Reply to: not updating to IDMS database
Reply with quote

Hi sudarshan,

1)it is updating based on input record(in input record the field always contains data(either Y or N))

2)yes,in the online screen Y/N is there,but not in databse.
Back to top
View user's profile Send private message
sudharsan.soundararajan
Warnings : 1

New User


Joined: 15 Oct 2008
Posts: 17
Location: Chennai

PostPosted: Thu Jun 25, 2009 5:21 pm    Post subject:
Reply with quote

Hi Krish,

i accept that your variable say A is getting updated in IDMS data base based on the input file.

say your input file is in the format
Code:
 XYZ              A
------------------------------------------------------------------------
 123              Y
 456              N

 


you mean to say that for the record having calc key '123' the variable A is populated as 'Y' and 456 it is populated as 'N'

When you see in online screen for the record 123 it is showing as 'Y'. the online screen fetches the data from IDMS database

and when you see it in backend (OLQ/DMLO) you are able to see only spaces.

is that correct what i am saying?
Back to top
View user's profile Send private message
kcs4u2004
Warnings : 1

New User


Joined: 21 Apr 2008
Posts: 56
Location: Chennai

PostPosted: Thu Jun 25, 2009 7:14 pm    Post subject: Reply to: not updating to IDMS database
Reply with quote

you are absolutely correct...thats what I m getting,online screen I m having data,but not in OLQ check of database.
Back to top
View user's profile Send private message
sudharsan.soundararajan
Warnings : 1

New User


Joined: 15 Oct 2008
Posts: 17
Location: Chennai

PostPosted: Fri Jun 26, 2009 8:46 am    Post subject:
Reply with quote

Hi Krish,

does the online screen you are seeing is related to your previous post
Quote:
how to make editable a field in online screen


Because i believe there must be a routine in the Online screen to show the default value as Y if the value in the data base is SPACES

Else if the online screen is taking the value from IDMS database only, then you might be looknig at the wrong record in OLQ
Back to top
View user's profile Send private message
kcs4u2004
Warnings : 1

New User


Joined: 21 Apr 2008
Posts: 56
Location: Chennai

PostPosted: Fri Jun 26, 2009 2:06 pm    Post subject: Reply to: not updating to IDMS database
Reply with quote

No,sudarshan,this is a different issue altogether..its also for an indicator,the previous issue i closed it successfully.......
Back to top
View user's profile Send private message
sudharsan.soundararajan
Warnings : 1

New User


Joined: 15 Oct 2008
Posts: 17
Location: Chennai

PostPosted: Fri Jun 26, 2009 2:46 pm    Post subject:
Reply with quote

hi Krish,

Quote:
Because i believe there must be a routine in the Online screen to show the default value as Y if the value in the data base is SPACES


did you had a look in to the online routine ....
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IDMS/ADSO All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Moving UDB database to Db2 on z/OS Keith Hooley DB2 4 Wed Sep 27, 2017 12:38 am
No new posts Updating the Trailer count in variabl... satheshbabur DFSORT/ICETOOL 6 Wed Aug 30, 2017 9:49 pm
No new posts IDMS DC027007 T58 TASK:ADS2 PROG:ADSO... gpowell382 IDMS/ADSO 2 Fri Jun 30, 2017 11:52 pm
No new posts Updating a VSAM file with DISP=OLD sheersh JCL & VSAM 8 Tue Mar 14, 2017 6:14 pm
No new posts Updating the counters after eliminati... PANDU1 DFSORT/ICETOOL 12 Mon Nov 21, 2016 9:47 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us