DSXchange

datisaq,

Where is your DataStage server installed.



Regards
Jay

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

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

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

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

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

Try quote=none rather than quote='none'

Or 'null'.

Should
final_delim=end
be
final_delim='end'?

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

Try with removing Column heading from ur input File like below:

200084|Issaq|23455
200116|Tanmoy|29555
100002|Thomas|45999

In the File Stage Properties:
1. Set 'First line column names' = False
2. Keep RCP enabled
3. Provide schema file

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!