DSXchange

But carries baggage of it's own which may be too heavy. Like, an After routine is already defined for the job or such a simple task as renaming a file seems overly complicated to do it in two places, one fairly hidden in the GUI. I like using a DS Macro for this; #DSJobStartDate#.csv Everything has...

Hi All, I have a set of 10 jobs which are called by a sequence one after the other. The last 3 jobs are taking almost 75% of the total time required to run the sequence. This is because these jobs does the lookup with db2 tables which are huge in volume. To improve the performance of the sequence, I...

Hi, What is the best partition type that should be given when a lookup file set is created with a key? By default the partition type that comes when we drag and drop this stage to a job is "Entire". Will Entire partition cause the data to be written mutltiple number of times depending on t...

Thank you very much OddJob. Your solution worked for me. But later I found that I got messed up because the $PROJDEF variable assigning the default value which was wrong. In my case the starting and ending single quotes are given in the query itself as you can see select name, id from emp where name...

No special characters are allowed. If you need the special characters in a Transformer stage, consider using a Stage Variable's initialize capability to call a Function. Have a custom DS Function fetch the value from either: 1. the environment, 2. reading a file. Hi kcbland, If i am to try your fir...

Hi All,

I need to pass a special character (like char(128),char(129)....) as a parameter to my job. How do i do it?

I tried passing the hex values as \x80 OR 0x80 OR &H80
also the dec values as 128 OR \128

None of these works.

Thanks Ray and sud.

Hi All, I am reading a db2 table in Datastage with DB2 Enterprise stage and using the Read Method = Table. I want to give a order by clause to the columns selected using the select list property. Where do I specify this? I tried to give it in the where clause property though I don't have a where cla...

Hi, Try setting your Basic Transformer to run sequentially by setting the Execution mode to Sequential in the properties>>stage>>advanced tab IHTH (I Hope This Helps), ... Hi All, Is this problem solved? My job design is also the same as explained in the begining of this thread. I am getting the fo...

I tried by making one of the output link as Reject. But still the rejected records are not being captured by this link. Am i missing something here? Should I give any additional constraints for this to be done.

Any help in this regard please...

In the transformer prior to the DB2 API stage, on the rejectred link, in the constraints, use LinkVariable --> Outputs --> (DB2Link) REJECTED. This is applicable only for Server jobs. But what about in PX? In PX we cannot get the (DB2Link) REJECTED option. So then how will we capture the rejected r...

well you will need to get that value from a dataset and put it in a sequential file. As per the routine, you can do that in a sequence job. In the properties of job activity, click on the Value Expression of the Parameter ValRange and click on Routine and there you can call your routine. The output...

Sorry about that. Since tiagogen has already done with (i guess :roll: ) I thought we will continue in the same thread as it will be easier to communicate the idea. Yes but then the forum is totaly different... :( My parameterfile.txt is not a sequential file but it is a data set. So the code $JOB_P...

Sorry about that. Since tiagogen has already done with (i guess :roll: ) I thought we will continue in the same thread as it will be easier to communicate the idea. Yes but then the forum is totaly different... :( My parameterfile.txt is not a sequential file but it is a data set. So the code $JOB_P...

In my case I want to implement all these in one job. I have a db2 stage as the source which will have this query in it and the result i need to pass to the output stage. So what is the routine i should have which will populate the variable (#ValRange#) ? My job is in PX.