Hi ...Can anybody please tell me how i should view the data from the properties of a sequential file in a parallel job. What iam doing is i used a sequential file to extract data, sort it and load the data in an sequential file.
But iam not able to see the data in the input file. when i compile there are no errors. but iam not able to run the job. I think, this is becoz it is not able to find the data. when i click the VIEW DATA button in the properties of the sequential filre, it it showing as NULL ARCHIVE. Can anybody of u give me some suggestions?
kiran.
viewing data from the input sequential file of a paralleljob
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 315
- Joined: Tue Oct 31, 2006 3:38 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard. :D
You may have more luck posting this question on the forum dedicated to questions and answers about parallel jobs - maybe not all of the folks there read the General forum.
What exact version of DataStage are you using? While versions from 6.0 onwards will let you design DataStage jobs on Windows, only version 7.5x2 will allow any form of execution (which includes View Data).
Note, also, that 7.5x2 is NOT the same as 7.5.2.
You may have more luck posting this question on the forum dedicated to questions and answers about parallel jobs - maybe not all of the folks there read the General forum.
What exact version of DataStage are you using? While versions from 6.0 onwards will let you design DataStage jobs on Windows, only version 7.5x2 will allow any form of execution (which includes View Data).
Note, also, that 7.5x2 is NOT the same as 7.5.2.
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: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
-
- Premium Member
- Posts: 315
- Joined: Tue Oct 31, 2006 3:38 pm
datatype in the sequential file of a parallel job
Iam using a column name called SSN and i defined it as an integer. since SSN has 9 digits.....it is automatically taking the length as 10. and iam using only one this column as input.samsuf2002 wrote:check the data types for the fields in source file
check the metadata and Properties of sequential file stage.
Import the meta data again. Open the sequential file and see how the columns are seperated, the end delimiter and see if the data is in double quotes. see if all these properties are given correctly in the properties tab in sequential file stage.
Mahadev V
-
- Participant
- Posts: 29
- Joined: Mon Nov 20, 2006 7:17 am
- Location: Melbourne
Re: viewing data from the input sequential file of a paralle
Kiran
I do have the same problem ,so let me know if u ll find any solution
I do have the same problem ,so let me know if u ll find any solution
Saugat Dey