Hi All,
The job design is as follows
dataset
|
|
|
dataset------->lookup------>dataset(target)
(I dont know to put the diagram exactly, dataset is looked up with another dataset)
In the column definition on the target dataset there is a column named "AR_PRIM_PYMT_TP_DT".The rows ran fine.But when i tried to view the dataset it shows
" Error executing View Data command:
##E TOPK 000000 12:25:57(027) <_PEEK_IDENT_> Input dataset does not have field: "AR_PRIM_PYMT_TP_DT"....."
I tried to look the columns in dataset management but the column"AR_PRIM_PYMT_TP_DT" is not there.
I tried by checking "Runtime column propagation" in the administrator,but in vain. Please help me to resolve the problem
Dataset does not shows the columns
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 47
- Joined: Thu Oct 04, 2007 3:37 am
- Location: chennai
Dataset does not shows the columns
Cheers,
prem
prem
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Dataset does not shows the columns
Surround your diagram with Code tags and use Preview until you get it right.premupdate wrote:(I dont know to put the diagram exactly, dataset is looked up with another dataset)lem
Gosh, consistent results!premupdate also wrote:##E TOPK 000000 12:25:57(027) <_PEEK_IDENT_> Input dataset does not have field: "AR_PRIM_PYMT_TP_DT"....."
I tried to look the columns in dataset management but the column"AR_PRIM_PYMT_TP_DT" is not there.
Checking this in the Administrator has no effect whatsoever, it merely sets the default for subsequently-designed jobs.premupdate also wrote:I tried by checking "Runtime column propagation" in the administrator,but in vain.
You have to do some detective work. If, as you claim, the column is in the target Data Set stage, and if the job ran successfully (on which fact you were suspiciously silent), then the column should be there. If, on the other hand, the Data Set was created by an earlier version of the job, or by a different job, that lacked this column then I would expect to see the symptom you have described.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 47
- Joined: Thu Oct 04, 2007 3:37 am
- Location: chennai
Code: Select all
dataset
|
|
|
|
dataset------lookup--------dataset
This is my actual job design.
Cheers,
prem
prem
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Prefer
Now tell us which one is generating the problem.
Code: Select all
dataset1
|
|
|
|
dataset0------lookup--------dataset2
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 47
- Joined: Thu Oct 04, 2007 3:37 am
- Location: chennai
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: