ASCII to Binary

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
attu
Participant
Posts: 225
Joined: Sat Oct 23, 2004 8:45 pm
Location: Texas

ASCII to Binary

Post by attu »

I have a sequential file with data in ASCII and would like to convert it into BInary using a CFF stage.
In the CFF stage I have some columns whose Native type is Group.
I want to map them using a transformer but some of the columns cannot be mapped and I am getting this error...

Could not find subrec "TDE_DISPLAY_TBL_ENTRIES"

The TDE DSplay TBL ENTRIES column has 6 more columns TDE TBL1, TDE TBL2 ........TDE TBL6.
any suggestions pls.

Thanks[/b]
prasadduvasi
Participant
Posts: 19
Joined: Wed Feb 15, 2006 11:08 am

Post by prasadduvasi »

Do not include group type columns in metadata
Prasad Duvasi
attu
Participant
Posts: 225
Joined: Sat Oct 23, 2004 8:45 pm
Location: Texas

Post by attu »

prasadduvasi wrote:Do not include group type columns in metadata
Then what should I use in place of Group :roll:
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Vector.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
attu
Participant
Posts: 225
Joined: Sat Oct 23, 2004 8:45 pm
Location: Texas

Post by attu »

I dont see the vecotr in the native type. how can I change the group to vector?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Right click on the column in the Columns grid. Choose Edit Row from the menu. In the bottom left corner you will find Vector and Subrecord. Once you have chosen Vector a new column called Occurs appears in the Columns grid.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
attu
Participant
Posts: 225
Joined: Sat Oct 23, 2004 8:45 pm
Location: Texas

Post by attu »

Thanks Ray.
Post Reply