DSXchange

Hi,

My PX job contains Oracle Stage --> Transformer ---> Sequential file stage.In the Oracle stage I am using the RCP so that the columns are propagated up to Sequential file.In the sequential file I am using the schema file for meta data.The schema file is as follows.

(record
name:string[255];
BPH:nullable int32;
CPH:nullable int32;
HPH:nullable int32)

the same meta data is present in the Source table also.

When I run the job itis giving the following error.

main_program: Fatal Error: Caught ORCHESTRATE exception in main program: APT_ParseError: Error parsing schema: Expected record, got: "(", line 1)

Can anyone help me to resolve this.

Thanks in advance..
Siva[/b]

1.Move record outside braces.
2.semicolon to the last record

Then it will surely work

record
(name:string[255];
BPH:nullable int32;
CPH:nullable int32;
HPH:nullable int32;)

Regards
Sreeni

Hi ,

Thanks for your suggestion.

The job is working fine after the modification in the schema file.But I am unable to see the content of the sequential file.

3 Records are coming from the source and I am unable to see the records in the Output.In the sequential file stage the RCP Property is checked and I am using the schema file.

I have given the File name in the sequential file stage ,When I am trying to open from the datastage the View Data Option is Disabled and When I try to open the file in the Unix path the file is Empty.

Can you please help me regarding this.

Thanks in advance.

Siva

View data is disabled for schema loads. Rest is a coding issue

Regards
Sreeni

Hi ,

I am not using any meta data (Columns) in the entire job.While writing in to the Sequential file it is giving the Warnings as Null handling is not handling.For that I set the property in the Sequential file stage in the format tab Null Field value=0.

But still I am unable to get the data in the sequential file.

Can anyone help me regarding this.

Thanks
Siva

The null handling warning is your problem. If the sequential stage gets a null that it cannot handle, the record is dropped and not written to the sequential file. This applies for all columns.