Problem with Schema file

Jayesh_09 · Post by **Jayesh_09** » Mon Oct 27, 2008 7:53 am

datisaq,

Where is your DataStage server installed.

Regards
Jay

datisaq · Post by **datisaq** » Mon Oct 27, 2008 8:28 am

Both the client and server components are installed on my local machine...

ray.wurlod · Post by **ray.wurlod** » Mon Oct 27, 2008 8:30 am

The bit at the end is a worry, an unneeded comma after quote=none and no terminating semi-colon for the final field definition.

chulett · Post by **chulett** » Mon Oct 27, 2008 8:35 am

Looks like this without smilies turned on, does that help?

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,};)

datisaq · Post by **datisaq** » Mon Oct 27, 2008 11:24 am

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...

datisaq · Post by **datisaq** » Mon Oct 27, 2008 11:26 am

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...

ray.wurlod · Post by **ray.wurlod** » Mon Oct 27, 2008 2:29 pm

Try quote=none rather than quote='none'

chulett · Post by **chulett** » Mon Oct 27, 2008 2:32 pm

Or 'null'.

abc123 · Post by **abc123** » Tue Oct 28, 2008 9:16 am

Should
final_delim=end
be
final_delim='end'?

datisaq · Post by **datisaq** » Wed Oct 29, 2008 11:00 am

I tried with all the various possibilities what you people have suggest?
But i ended up with the same result...

Can anyone give me a schema file according to the sample data file i've shown in my previous replies?

I'll be very much grateful to you guys...

mdbatra · Post by **mdbatra** » Thu Oct 30, 2008 1:34 am

mdbatra · Post by **mdbatra** » Thu Oct 30, 2008 1:49 am

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!