The job runs the first iteration fine with the variable A below:.I am now facing 2 problems right now that I need your help with. The shell script is below, I ran it fine on my system but no success on making it as part of the job. So with my knowing-nothing about shell script, I have searched for solutions and have this file to sleep until a specific time when minute like 30 or 00 (delay 0-1 minute but it's fine). But I realized now that it is affected by the running time of each iteration. The Execute Command I currently set the 'Sleep 1800' command for the job to sleep 30 minutes to end the iteration of the loop.
The first iteration the UserVariables pass variable A (SQL statement 1) to the Job Activity, from the second iteration, it will pass variable B (SQL statement 2) to the Job Activity.
The UserVariables Activity is to pass variables (SQL statement) to filter data getting in the Job Activity. The first loop iteration will load data from 8 PM the previous day to 8 AM the current day, and the others will load data that happens in the last 30 minutes. The job will run every 30 minutes (8 AM - 8 PM) to get real data. Here is the flow: StartLoop Activity -> UserVariables Activity -> Job Activity -> Execute Command -> Endloop Activity Please refer to Datastage EE configuration guide for more details on creating a config file.InfoSphere CDC delivers the change data to the target and stores sync point information in a bookmark table in the target database.Currently, I have a sequence job in DataStage.
#Execute command activity stage data stage versions how to
Please Read the Datastage EE Configuration Guide For more information on how to create a configuration file.To get rid of the error just go to the Job Properties - Performance and select Enable row buffer.Introduction This post serves as a guide to develop a DataStage job that processes data in a generic way to extract from multiple flat fil.If you get any results and the dsrpc is in WAIT state then you need to wait until it disappears you can also reboot the machine. If you get any results and DSRPC is in the WAIT state then you have to wait for it to disappear you can also start Calculator. Introduction this post serves as a guide to developing a DataStage Job that processes data in a generic way to extract from multiple flat profile. To get rid of the bug just go to the Job property performance and select Enable the data suffer.
0 kommentar(er)
