View previous topic :: View next topic
|
Author |
Message |
kcs4u2004 Warnings : 1 New User
Joined: 21 Apr 2008 Posts: 56 Location: Chennai
|
|
|
|
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 |
|
|
sudharsan.soundararajan Warnings : 1 New User
Joined: 15 Oct 2008 Posts: 17 Location: Chennai
|
|
|
|
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 |
|
|
kcs4u2004 Warnings : 1 New User
Joined: 21 Apr 2008 Posts: 56 Location: Chennai
|
|
|
|
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 |
|
|
sudharsan.soundararajan Warnings : 1 New User
Joined: 15 Oct 2008 Posts: 17 Location: Chennai
|
|
|
|
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 |
|
|
kcs4u2004 Warnings : 1 New User
Joined: 21 Apr 2008 Posts: 56 Location: Chennai
|
|
|
|
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 |
|
|
sudharsan.soundararajan Warnings : 1 New User
Joined: 15 Oct 2008 Posts: 17 Location: Chennai
|
|
|
|
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 |
|
|
kcs4u2004 Warnings : 1 New User
Joined: 21 Apr 2008 Posts: 56 Location: Chennai
|
|
|
|
No,sudarshan,this is a different issue altogether..its also for an indicator,the previous issue i closed it successfully....... |
|
Back to top |
|
|
sudharsan.soundararajan Warnings : 1 New User
Joined: 15 Oct 2008 Posts: 17 Location: Chennai
|
|
|
|
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 |
|
|
|