DSXchange

The manual tells you to do it. It used to be required as the last link when DS 4 came out, but in prior releases it didn't matter. Maybe IBM will change their minds. In the meantime, follow the manual.

Well, I hope this is close. create table ken (id integer, element varchar2(20) ) insert into ken values (1,'a') insert into ken values (2,'b') insert into ken values (3,'c') insert into ken values (4,'d') create table ken_cartx as select rownum "X...

Your example is not understandable. Your first table shows id ranged from 1 to 4, but your second table shows it ranged from 1 to 9,etc. Where does combo_num come from? Why does the "cartesian" type effect occur at 5, where the multiplication is a factor of the position after 5?

Read page 166 of your Server Job Developer's Guide.

No, it will not "reset". The job will abort when the log file exceeds 2.2GB.

DS Server edition 1.0 premiered in 1997 from VMark. DS/390 was acquired from Prism as the PWE tool sometime around 1998. PX was acquired from Torrent in 2001 as the Orchestrate tool. RTI came in 2002? from Mercator?. Server edition had 2000+ customers as of 2001 when Torrent was brought in, and cont...

As long as you understand the differences in coding between Ray's and my example, great. I used a more simplistic approach and demonstrated multiple functions that would be useful to know. Ray showed the powerful function OCONV and how to "stack" multiple operations as an inline dynamic array and fo...

When, where, why are you getting this message? What are you trying to do?

There isn't one. Write a job that does a SELECT MAX(yourkeycolumn) FROM yourtable and puts the result into the appropriate hashed file used by the function.

Custom job control. Look at a Batch job to get you started, all you need to do is capture the contents of FILE1 into an array and setup a loop. Consider something like this: UNIXcmd="cat ":FILE Call DSExecute("UNIX", UNIXcmd, ScreenOutput, ReturnCode) LineCount = DCOUNT&#...

If its in the same database, just differenct schemas, and the size of both input and lookup are huge, i would do a lookup in just the OCI stage. This way you are avoiding bringing in all the data first to the DataStage server, and then doing the join. All your doing in this case is just passing the...

This should help
http://www.dsxchange.com/viewtopic.php?t=85788

It is a bad idea to use the DS logs for permanent storage. Consider loading into a database if you need full history. Reimporting the job clears the log, so you can never make changes to the job. There is no method for "migrating" logs if you move to another project/server.

In the loop that pulls back the log messages, you'll want to put a conditional in there to only use the log message if the jobname.instance is found in the text string. The DS BASIC job control APIs for scanning job logs are not instance-aware, even if using the jobname.instance. Your change should ...

Welcome aboard. You should consider creating a loop to periodically check the status of the started jobs using the documented APIs. When you notice a job has now finished, take the appropriate action. The DSWaitForJob API is an infinite routine which waits forever for the controlled job to finish. I...