Problem with Schema file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Thanks Ray and Craig, i've removed the comma and kept semicolon at the end also but the same error persists.
My input file looks like this:
Empno|Ename|Salary
200084|Issaq|23455
200116|Tanmoy|29555
100002|Thomas|45999
And my schema file:
record
{final_delim=end, record_delim='\n', delim='|', quote='null', padchar='#'}
(
Empno:int32 {quote=none};
Ename:string[max=255] {prefix=2};
Salary:int32 {quote=none,};
)
Do i need to set anything in the format tab or properties tab of sequential file stage?
please help me out...
My input file looks like this:
Empno|Ename|Salary
200084|Issaq|23455
200116|Tanmoy|29555
100002|Thomas|45999
And my schema file:
record
{final_delim=end, record_delim='\n', delim='|', quote='null', padchar='#'}
(
Empno:int32 {quote=none};
Ename:string[max=255] {prefix=2};
Salary:int32 {quote=none,};
)
Do i need to set anything in the format tab or properties tab of sequential file stage?
please help me out...
IBM Certified - Information Server 8.1
Thanks Ray and Craig, i've removed the comma and kept semicolon at the end also but the same error persists.
My input file looks like this:
Empno|Ename|Salary
200084|Issaq|23455
200116|Tanmoy|29555
100002|Thomas|45999
And my schema file:
record
{final_delim=end, record_delim='\n', delim='|', quote='null', padchar='#'}
(
Empno:int32 {quote=none};
Ename:string[max=255] {prefix=2};
Salary:int32 {quote=none};
)
Do i need to set anything in the format tab or properties tab of sequential file stage?
please help me out...
My input file looks like this:
Empno|Ename|Salary
200084|Issaq|23455
200116|Tanmoy|29555
100002|Thomas|45999
And my schema file:
record
{final_delim=end, record_delim='\n', delim='|', quote='null', padchar='#'}
(
Empno:int32 {quote=none};
Ename:string[max=255] {prefix=2};
Salary:int32 {quote=none};
)
Do i need to set anything in the format tab or properties tab of sequential file stage?
please help me out...
IBM Certified - Information Server 8.1
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Also,if the aboce does'nt work, just read from the original file, provide metadata for the same on Columns Tab & load it into another seq file.
Now,after running the job, u can check the log in director. In one of the status messages, schema would be generated for the input file.
Will surely work!
Now,after running the job, u can check the log in director. In one of the status messages, schema would be generated for the input file.
Will surely work!
Rgds,
MB
MB