http://www.dsxchange.com/viewtopic.php?t=100438 WebOct 5, 2015 · Where the execute command counts the number of lines on your text file (ex: wc -l ~/MyTextFile.txt), the job activity is the job you previously created and the Start loop activity create a numeric loop from 1 to the execute command stage output. BI Consultant DSXConsult Top sharmabhavesh Premium Member Posts:38 Joined:Wed Jun 20, 2012 …

Looping in Datastage InfoSphere DataStage - IBM

WebDec 14, 2011 · Step:1 Count the number of lines in the file so that we can set the upper limit in the datastage start loop activity. sample routine to count lines in a file: Argument : … WebFigure 1. Example of using a loop in a sequence. The Start Loop stage, networkloop, has Numeric loop selected and the properties are set as follows: Figure 2. Numeric loop … how to simplify a quadratic equation

scheduler - How to start a DataStage Sequence job when a when …

WebSep 27, 2024 · 1. With your newly created SEQ_LOOP job open, go to the menu and choose Edit > Job Properties. We are going to add the TABLE_NAME parameter in the Properties section. Click OK to save. 2. … WebOct 29, 2010 · The StartLoop already has this list so just skip the UV stage and use the following syntax in your Job Activity's parameter: StartLoop_Activity_1.$Counter If your loop list is in fact something else or I'm not understanding what you need to do, please enlighten us with many details and we'll continue on with this. -craig WebMay 18, 2016 · In the Datastage Sequencer , use a Execute Command Activity to open the SQL file eg : cat /home/bk/query.sql In the job activity which calls your generic job . you should map the command output of your EC activity to a job parameter so if EC activity name is exec_query , then the job parameter will be exec_query.$CommandOuput nova beauty moreton wirral