DSXchange

Hi Kenneth,

A watch process was actually my first idea. I'm only afraid that a systematic watch for files every hour or half hour might be too heavy on resources for our DataStage Server. Especially for files which are supposed to be sent only during the 1st 5 days of each month.

Isabelle

Thanks to both of you for your answers; Actually I don't have the choice and I have to enable the user to send their own data when they ask to. otherwise I will have to check every hour if the concerned files have been updated and if so retrieve them to France (which is no better solution according ...

Hello Everybody, I have developed a datastage application that retrieves files from AS400 all over the world (which is scheduled at 6 every morning). Now the users are asking me to be able to send themselves their files when they are ready. I don't want to give them a hand on DataStage Director. Is ...

Hi Shawn, the problem is that the source column is alpha-decimal but some subtrings are decimal and can be packed. That is why, I think, datastage does not convert anything because source is char(200). The problem still persists : I tried to create my own routine (oconv (xxx, MP) ) but without succe...

hi
I put all what you said to me but did not find the "DataTypeEbcdicToAscii" routine...
can I download it from somewhere?

Thanks

Virginie

Hi, Thanks for your quick answer! I will try to be a bit clearer : a field is packed on our AS400 and when we try to get the content of this field via Datastage - ODBC Stage into a column type "char" , we can not read this data, we only obtain some pipes '||||', the numeric are packed and ...

Hi all
It is my first time in this forum...
We have some problem extracting packed data from our AS400 (condensed strings). We tried some routines in the SDK\DataTypes but with no success...

Has someone already encoutered this problem?

Thanks in advance,

Virginie