Convert datatype to Comp - 3

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
yatin.mittal
Participant
Posts: 20
Joined: Fri Oct 14, 2005 12:52 am

Convert datatype to Comp - 3

Post by yatin.mittal »

Hi,

I have to convert the datatype of some fields to comp - 3 whose storage is 1/2 byte.

can any body help me in this?

With Regards,
Yatin Mittal
Accenture Services Pvt. Ltd.
dssiddu
Participant
Posts: 66
Joined: Mon Nov 07, 2005 10:28 pm
Contact:

Post by dssiddu »

hi

use CFF stage,it will automaticaly converts.


bye :roll:
sunil_acc
Participant
Posts: 28
Joined: Thu Oct 20, 2005 5:49 am

cff dont havr o/p stage

Post by sunil_acc »

hi dssiddu

as Comp3 is reqired a output henc cff is not fruifull as it dont give output.

:roll:
Thanks
Sunil
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Yattin,

there is a builtin routine at sdk\DataType\DataTypePicComp3 which will convert a Comp-3 field into a numeric displayable one.

Sunil - a CFF stage will do this correctly, I am not sure what your issue is, but it will take a USAGE COMP-3 and convert it.
yatin.mittal
Participant
Posts: 20
Joined: Fri Oct 14, 2005 12:52 am

Post by yatin.mittal »

Hi,

CFF can only be used as Input stage.

We want data type to be in Comp - 3 format in target file.Bue the routines you are mentioning and CFF, can work in reverse order only
i.e. these convert Comp -3 to Any datatype.

But our requirement is reverse.

Please look at it and give me the solution.

With regards,
Yatin Mittal
Accenture Services Pvt. Ltd.
Post Reply