Viewing But Not Reading
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 273
- Joined: Wed Oct 18, 2006 12:20 pm
- Location: Porto
Viewing But Not Reading
Hi, In my job, when, on the source side I click 'View Data...', then some 19 - 20 rows of data is being displayed.
But, when I run the job, 0 (ZERO) rows are being read!!
Plz explain.
But, when I run the job, 0 (ZERO) rows are being read!!
Plz explain.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Not enough information. What other stages are in your job? Are you using a filter command? Does the job execute using the same user ID as you use when you view data? (Have you checked that?)
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.
-
- Premium Member
- Posts: 273
- Joined: Wed Oct 18, 2006 12:20 pm
- Location: Porto
This is the desgin of my Job:
DB2 Stage
|
|
V
Transformer ------> SeqFile
|
|
V
Shared Container
The DB2 Stage has a join from 3 tables, for which the output happens to be some 19 rows. This I verfied by running the querry from DB2 Command Editor and also by clicking on 'View Data'.
Now when I run the job, there are 0 rows read , 0 rows written to SeqFiles.
There are no constraints used in the job.
DB2 Stage
|
|
V
Transformer ------> SeqFile
|
|
V
Shared Container
The DB2 Stage has a join from 3 tables, for which the output happens to be some 19 rows. This I verfied by running the querry from DB2 Command Editor and also by clicking on 'View Data'.
Now when I run the job, there are 0 rows read , 0 rows written to SeqFiles.
There are no constraints used in the job.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 273
- Joined: Wed Oct 18, 2006 12:20 pm
- Location: Porto
ray.wurlod wrote:No WHERE clause in the DB2 stage? Please check the generated SQL (in the job log). ...
Thsi is the FROM Clause:
EPM1PA.PS_JRNL_HEADER H,EPM1PA.PS_JRNL_LN LN,EPM1PA.PS_MB_ASCNTLDTTM DT,EPM1PA.PS_MB_JRNL_LN_SIS SIS
This is the WHERE clause....
DT.MB_ASCNTLJOBNAME ='#JOBNAME#'
AND H.JRNL_HDR_STATUS = 'P'
AND
H.POSTED_DATE >= DATE(DT.MB_JOBDTTM) AND
H.POSTED_DATE <= '#INPUTDATE#'
AND
H.BUSINESS_UNIT = LN.BUSINESS_UNIT
AND
LN.BUSINESS_UNIT = SIS.BUSINESS_UNIT
AND
H.JOURNAL_ID = LN.JOURNAL_ID
AND
LN.JOURNAL_ID = SIS.JOURNAL_ID
AND
H.JOURNAL_DATE = LN.JOURNAL_DATE
AND
LN.JOURNAL_DATE = SIS.JOURNAL_DATE
AND
H.UNPOST_SEQ = LN.UNPOST_SEQ
AND
LN.UNPOST_SEQ = SIS.UNPOST_SEQ
AND
LN.JOURNAL_LINE = SIS.JOURNAL_LINE
AND
LN.LEDGER = SIS.LEDGER;
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
-
- Premium Member
- Posts: 273
- Joined: Wed Oct 18, 2006 12:20 pm
- Location: Porto
When I run the SQl, I get the desired result.DeepakCorning wrote:Also copy paste the SQL in the SQL tool you have and run it and see if it returns any rows or not.
Also, when I do 'View Data' from the stage, I can see the desired rows being returned....
BUT
When I run the job,
0 rows read from PS_JRNL_HEADER_Link (DB2 to Transformer Link)
0 rows written to GL201_EPM_Intfc (Trans to SeqFile Link)
0 rows written to UpdateDttm (Trans to Sahred Container Link).
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
PS_JRNL_HEADER - Sounds like a Peopleosft Functionality. Does your job has a input link and output link from the table (DRS) to a shared container? Are you viewing data on the output link from the DRS?? As far as i know the shared container which you are talking about should get only one rows (Max Updated Time) and but you said the qury that you are running is giving you 19 rows??
-
- Premium Member
- Posts: 273
- Joined: Wed Oct 18, 2006 12:20 pm
- Location: Porto
No worries for the shared container part...I am worried abt theDeepakCorning wrote:PS_JRNL_HEADER - Sounds like a Peopleosft Functionality. Does your job has a input link and output link from the table (DRS) to a shared container? Are you viewing data on the output link from the DRS?? As far as i know the shared container which you are talking about should get only one rows (Max Updated Time) and but you said the qury that you are running is giving you 19 rows??
DB2-----> Trans -----> SeqFile links. Why no data is flowing on that???
No warning and errors!
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am