http://www.dsxchange.com/viewtopic.php?t=155280 WebMay 28, 2014 · 1. No. With a Loop, it goes around and around, one iteration at a time. 2. There is a final line terminator in your file. This means that you are generating an empty line when reading it. You need to eliminate that. Show how you convert your file to a delimited list, and we'll respond with that solution (usually in a User Variables activity).

Is there a way to use User Activity Variables to store SQL in Datastage

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 : … WebFeb 17, 2024 · This is to propagate stage variables at a Job Level. However the routine activity to accomplish your task would be as follows. Propagate SQL as a variable. Use … how to run flash websites

counter Increment in a loop - DSXchange

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 http://www.dsxchange.com/viewtopic.php?t=152647 WebDec 10, 2015 · How to pass all the accounts in to a user variable using user variable activity. I tried using Field(Execute_Command_83.$CommandOutput,@FM,1) in the expression of user variable activity. But it is only giving first account only. How to get all the account numbers which are result of execute command activity stage. k.v.sreedhar Top … northern sand and gravel sault ste marie mi