DSXchange

Hi Erine Yes, the problem is with the external stage, i created a new job and tried connecting a external source with a sequential file, in the source program i mentioned as "ls \Datastage\Testinputfiles\XML_in_Books.xml" (without quotes), but in the sequential file stage i'm getting as &q...

believe me... In the external source stage i put the slash in the windows style (ls \Datastage\Testinputfiles\XML_in_Books.xml) , but i dont know why its getting converted to a unix style... :( ....... i even tried typing in the command prompt, i'm getting in the unix style only, probably ls convert...

Thanks for your response ernie... i have tried your suggestion (ls \Datastage\Testinputfiles\XML_in_Books.xml), but no luck...i'm still getting the same error Datastage error ============ The primary document entity could not be opened. Id=C:\IBM\InformationServer\Server\Projects\Training//Datastage...

Hi Thanks for responding I tried replacing colon with equal sign, like "C=/Datastage/Testinputfiles/XML_in_Books.xml" but getting the error as Datastage error ========= Source subproc: ls: File or directory "C=/Datastage/Testinputfiles/XML_in_Books.xml" is not found and i tried t...

Hi Chulet pls Correct me if my understanding is wrong The colon ":" that is specified in the link is the windows path name, which is the second character after "C" C:\Datastage\Testinputfiles\XML_in_Books.xml I'm not sure about how i can give the "*" wild character in t...

Hi Thanks for responding FYI -- I'm in windows environment. I tried your suggestions, but still getting the same error " Invalid data source specified: Invalid hostname: "ls C"." I have configured the external source as below Source Method: Specific Programs Source Program: "...

Hi I tried the option given for the external source " ls C:\Datastage\Testinputfiles\XML_in_Books.xml | sort " ( without quotes) i'm getting the error as "Invalid data source specified: Invalid hostname: ls C." and i did some googling for that and i ended up in the below link, bu...

Hi All I'm trying to read a XML file through a external source, but i dont know how to pass the file path alone to the XML input stage, i tried "cat" and echo commands but not getting file path to the XML input stage, can you please help me on this, thanks External source > XML input stage...

why dont you write some paper on this

thanks ray.. for your response..

thanks ray, i googled and tried in this site as well, but couldnt find any substantial documents regarding the datastage tables (ds_jobs, etc), is there
anywhere i can find one? and one more question, in what database these tables are constructed?

cheers
karthy

Hi we have a project which has more than 450 jobs, i need to find which jobs are using a shell script inside them, mostly all the unix scripts are called from the external source stage and all the scripts ends with ".sh" extension, so is there any easy way to find the names of those script...

yes, its resolved

Hi I finally able to run it, previously i was running the dsenv as just "dsenv" without the "." in front of it, i'm not a expert in unix can you please tell me what is the difference in running the script with "sh dsenv" and " .<space> dsenv" and "dsenv&q...

Hi when i execute the dsjob commands (after running the dsenv file ) inside a shell script its working fine, but when i run the dsjob commands in the command prompt (even after running the dsenv file) its not working even from bin directory? anything wrong with my environment varaiables?? should i h...

finally did some tweaking and it worked..

Transformer in sequential mode

Stage variable
svx=0
Derivation: if svx >19 then "1" else svx+1 = svx

Output link1
Constraint: if svx <=10

Output link2
Constraint: if svx >= 11