DSXchange

Thanks Ray,

Did you mean that I can copy the descriptor file definition from the Dataset management Utility and use it for schema file ?

Hi all, I have a requirement where I need to convert around 300 datasets into sequential files. And I am told not to do this with ORCHADMIN command because it runs on the head node. So I have decided to create a multi instance job for this. Now the pain is I dont want to write a schema file with 300...

Right Craig,

Whatever you said it perfect. I am seeing a valid invocation id as "Compiled".

As you suggested I will try to compile the base job again and check whether it clears off everything. Will keep posted on this.

My question here is how come an instance which has not run yet can have a state as "Compiled".

thanks Arun, Yes all these instances are parallel. They run at the same time. May be in an interval of few seconds. I cant run the job for only one instance. When it runs it runs for all the instances from Mainframe. I am sure that the invocation ids are not same for this job. I feel something is wr...

Hi, I am going through a strange problem. I have a multiple instance job which has instance id as "Invocatin Id". The job runs for around 20 multiple instances. The problem is for one of the instance the job is not running. It shows that instance in "Compiled" state. The original...

Hi, I successfully resolved the issue. Uninstalled Visual C++ 2003 Toolkit, Platform Development SDK, MKS Toolkit, and Datastage engine. Restarted the machine and Installed these in order. 1.Visual C++ 2003 Toolkit. And then set the environment variables for these. 2.Platform SDK for XP. Set environ...

Use 3 stage variables.

NewKey = Key Column
ConcatData = If NewKey <> NextKey ColumnC Else ConcatData:ColumnC
NextKey = NewKey


Use ConcatData stage variables for the new column derivation.
Hope this helps.

Why was that Craig ?



Any solutions for this ..

I got rid of this warning by adding a user defined PWD variable with value .(Dot) which was mentioned in one of the topics. ##W TFPA 000012 20:36:27(000) <main_program> Warning: the PWD environment variable is not defined. Remote process startup may be unsuccessful as a result.If your ORCHESTRATE jo...

Hi DS Lords, I have freshly installed DS EE on Win XP machine. The machine has Visual Studio 2005 and Platform SDK installed on it. While compiling jobs which have transformer I am getting the following error. I have serached through all the topics related to this error and tried all the solutions. ...

Hi All,

Thanks for the hint. In the previous run stuff i foudn that there are some junk data coming and currently i am fixing it. Will mark this topic resolved once I am done with fixing the junk value problem.

Thank you very much !! :D

Hi All, I have a setup of DS Server 8.0 on IBM AIX. The current job which I am talking about reads from a table in MS SQL 2005 and does 2 lookups and populates the result file as a Ebcdic data file which will be used in a mainframe machine. I have used a custom built routine to convert the data into...

I have the similar problem. And to add more the routine wont show up in the transformer derivation window. I can't delete it, rename it or overwrite it using another .dsx file. What I did is simply created another routine and replaced all my jobs which were using the old routine. Anyone has a soluti...

Hi, I have a requirement where I am getting a Char(10) field from source. Which might contain data like '15/100', '345/10', '01/125' like this. What I need to do is devide like each of them. Means '15/100' as 15 devide by 100 and so on. I am planning to use the field fucntion for this. I have never ...