Expand Stage Schema

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
kpsita
Participant
Posts: 99
Joined: Tue Jul 21, 2009 11:43 pm

Expand Stage Schema

Post by kpsita »

Hi,
I am using Compress stage to compress a dataset. then when I use Expand to uncompress the compressed dataset it gives me some schema error. I went through the document and found that while using expand satge to uncompress, I should be using the compressed schema in the field layouts. How can I get the schema of a compressed file.

Thanks,
KPSITA
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Save it from the Columns tab of the Compress stage output link?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kpsita
Participant
Posts: 99
Joined: Tue Jul 21, 2009 11:43 pm

Post by kpsita »

I tried, but giving me the same error. The error is
When binding output schema variable "outRec": Cannot drop the case from tagged output; case "t.encoded".

here is my job design (JOB1) to Compress
Dataset1.ds ---------> Compress --------------->Dataset2.ds
field1(varchar1) field1(varchar1)
field2(varchar10) field2(varchar10)

JOB2 to Expand
Dataset2.ds ---------> Expand --------------->Dataset3.ds
field1(varchar1) field1(varchar1)
field2(varchar10) field2(varchar10)

Is my job design correct?

Thanks
KPSITA
agpt
Participant
Posts: 151
Joined: Sun May 16, 2010 12:53 am

Post by agpt »

Is the schema on Dataset2.ds is same as input as in your example it looks exactly the same.
kpsita
Participant
Posts: 99
Joined: Tue Jul 21, 2009 11:43 pm

Post by kpsita »

Yes, the schema is same for Input and output files. is it correct or do i have to mention a different schema for compressed dataset.

thanks
KPSITA
sendmkpk
Premium Member
Premium Member
Posts: 97
Joined: Mon Apr 02, 2007 2:47 am

Post by sendmkpk »

hi,

Can some answer this question now, i am facing same problem not able to read dataset with same schema as compressed
Praveen
Post Reply